Shulou(Shulou.com)06/02 Report--

This article mainly introduces how to use web software for ADO.NET paging, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

ADO.NET pagination after a long time of development, many users are very familiar with ADO.NET pagination, here I would like to publish a personal understanding, and discuss with you. The ADO.NET database provider contains Connection, Command, DataAdapter, and DataReader objects. In normal ADO.NET programming, the first step is to create a Connection object and provide it with the information it needs, such as a connection string. Then create a Command object and give it the details of the SQL command to execute. This command can be a built-in SQL text command, a stored procedure, or direct access to the table. If desired, you can also provide parameters for these commands.

After creating the Connection and Command objects, you must determine whether the command returns the result set. If the command does not return a result set, ADO.NET paging can execute the command by calling one of several Execute methods. On the other hand, if the command returns a result set, you must determine whether to keep the result set for future use without maintaining a connection to the database.

If you want to preserve the result set, you must create a DataAdapter object and populate the DataSet or DataTable object with it. These objects can maintain the information in disconnected mode. However, if you don't want to keep the result set, but just want to execute the command in a quick way, you can use the Command object to create a DataReader object. The DataReader object, which requires a real-time connection to the database, is a forward-only read-only cursor. Let's take a look at an example of using ADO.NET paging asynchronous queries.

SqlConnection sqlConnection1 = new SqlConnection ("Data Source=localhost; Integrated Security=SSPI; Initial Catalog=Northwind"); / / create data connection SqlCommand selectCMD = new SqlCommand ("SELECT CustomerID, CompanyName FROM Customers", sqlConnection1); / / create and initialize SqlCommand object SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter (); custDA.SelectCommand = selectCMD; sqlConnection.Open (); / / create SqlDataAdapter object and retrieve data DataSet dsDataSet1 = new DataSet () based on SelectCommand attribute SqlDataAdapter1.Fill (dsDataSet1, "Customers"); / / use SqlDataAdapter's Fill method to fill DataSet sqlConnection.Close (); / / close the data connection and thank you for reading this article carefully. I hope the article "how to use web software for ADO.NET paging" shared by the editor will be helpful to you. At the same time, I hope you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.