NET系列教程2310B_09.ppt

Module 9:Accessing Relational Data Using Microsoft Visual Studio .NET Overview Overview of ADO.NET Creating a Connection to a Database Displaying a DataSet in a List-Bound Control Lesson: Overview of ADO.NET What is ADO.NET? Using Namespaces The ADO.NET Object Model What is a DataSet? Accessing Data with ADO.NET Practice: Identifying ADO.NET Components Using Namespaces Use the Imports or using statement to import namespaces Namespaces used with ADO.NET include: System.Data System.Data.SqlClient System.Data.OleDb Accessing Data with ADO.NET Practice: Identifying ADO.NET Components Students will: Move icons of various components of ADO.NET to the correct locations Time: 5 Minutes Lesson: Creating a Connection to a Database Using Server Explorer to Generate a Connection The DataAdapter Object Model Demonstration: Connecting to a Database Generating a DataSet Demonstration: Generating a DataSet Using Server Explorer to Generate a Connection Create a new data connection by dragging a Table from Server Explorer The DataAdapter Object Model Demonstration: Connecting to a Database Expand Server Explorer to a table in a SQL Server database Drag the table to an ASP.NET Web Form View the data using the SqlDataAdapter View the source of the page that was created Configure the DataAdapter object Generating a DataSet You can generate a DataSet… …through the UI… Creates a DataSet that allows you to access data as an object …or through code… and then fill… Demonstration: Generating a DataSet Create a typed DataSet from a DataAdapter Add a second DataTable from a different DataAdapter Show the schema of DataSet Lesson: Displaying a DataSet in a List-Bound Control What are List-Bound Controls? Displaying DataSet Data in List-Bound Controls Demonstration: Binding List-Bound Controls to a Database Practice: Using a DataGrid Demonstration: Customizing the DataGrid Control What are List-Bound Controls? Displaying DataSet Data in List-Bound Controls Set the properties Fill t