In ASP.NET, read data in the database can use DataReader and DataSet 2 ways, the differences are as follows: Use the DataSet object to read data. The following five steps are required: (1) Establish a database link, you can choose SqlConnection Or 01edbConnection. (2) Save the query in the SqlDataAdapter or OLEDBDataAdapter object. (3) Fill the data into the DataSet in the DataSet using the Fill method of the DataAdapter object. (4) Establish a DataView object to display data for the DataTable object, which can be omitted. (5) Bind DataView or DataSet to Server Control. Reading data using DataReader requires the following six steps: (1) Creating a database link, you can choose SqlConnection or OLEDBCONNECTION. (2) Open the database link using the OPEN method of the Connection object. (3) Save the query in the SQLCommand or OLEDBCommand object. (4) Call the ExecuteReader method of the Command object, read the data into the DataReader object. (5) Call the DataReader's READ or GET method to read - pen data so that you can't see it. (6) Call the CLOSE method of the Connection object, turn off the data sequence link.
