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

This article mainly introduces "ADO. NET DataSet data filling method is what", in the daily operation, I believe many people in ADO. NET DataSet data filling method is what the problem is there are doubts, Xiaobian consulted all kinds of information, sorted out simple and easy to use operation methods, hope to answer everyone "ADO. NET DataSet data filling method is what" doubts help! Next, please follow the small series to learn together!

The DataSet object of the client is filled with data from the data source, and a DataTable object with a data structure consistent with that of the data source is formed inside the DataSet object. The DataTable object contains a DataColumn object set representing the data structure, a Constraint object set representing the data constraints, and a DataRow object set representing the data records. After the DataSet object is populated with data and data structures, the DataSet dataset acts as an offline database, and the data for client application operations is obtained entirely from the DataSet dataset. This is a client-side DataSet dataset that can be disconnected from the data source, that is to say, the relationship between them is a non *** connection relationship. Only when the client completes the data operation and needs to transmit the data back to the data source, the connection is established again. The DataAdapter object sends a data command request to the data source again, which is sent and executed by the data source when executing the Update () method of the DataAdapter object to complete the Update operation. After execution, the connection is disconnected again. There are two steps to populating a dataset with DataAdapter objects:

Step 1: Connect to the data source using Connection;

Step 2: Fill the tables in the DataSet using the Fill () method.

The fill dataset syntax is shown in the figure below:

Populating a dataset syntax diagram with DataAdapter objects

How to save data in an ADO. NET DataSet

The modified data in the dataset is then submitted to the data source. This working principle process has been mentioned many times in the previous chapter and will not be described too much here. Please see the figure below:

Operation diagram for submitting modified data from a dataset to a data source

The syntax for saving data changes in the ADO. NET DataSet is shown in the figure below:

Using DataAdapter Objects to Save Data Syntax Diagrams in ADO. NET DataSets

Here is just the application of the simplest Update () a table, through the SqlCommandBuilder object to automatically generate the relevant commands needed to update, do not manually write one by one, simplify the operation.

At this point, the study of "ADO. NET DataSet data filling method is what" is over, hoping to solve everyone's doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

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.