All interactions with a database are carried out through a data provider. In Section 5.10 we walked through the OLE DB data provider. This section steps through the analogous use of the SQL Server data provider defined within the System.Data.SqlClient namespace. It can be used with Microsoft SQL Server 7.0 or later versions.
Here are the steps necessary, using the SQL Server data provider, first to connect to and select data from a database, and then to fill a DataSet object with the retrieved data:
Once the data is within the DataSet object, we manipulate all of the data through that object. In our case we choose to display the data within a Web Forms DataGrid control.
18.219.34.62