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

This article introduces the relevant knowledge of "what is the performance principle of ADO.NET". In the operation of practical cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1.ADO.NET performance loading XML data

In ADO.NET 1.*, the offline data access model is dominated by DataSet objects, so if you want to load XML data into DataTable, you must implement it through DataSet. If we operate only one data table and do not need to access multiple data tables, we still need to go through the DataSet class to assign DataTable data or export the data to XML

Documents, the process is a little tedious. The DataTable class of ADO.NET 2.0 adds the same as DataSet. ReadXML, ReadXMLSchema, WriteXML and WriteXMLSchema methods. So we can manipulate the DataTable instance directly without first creating an instance of the DataSet class to give the DataTable instance data, and then using only the DataTable instance.

2.ADO.NET performance result set loads DataTable directly

DataTable and DataSet can be generated from the DataTableReader object. Using the new method Load introduced by DataTable and DataSet in version 2.0, you can pass DataTableReader or any class object that implements the IDataReader interface. The following code passes the data of dt1 to the new data table dt2 through the Load method:

DataTableReader dtRdr = dt1.CreateDataReader (); DataTable dt2 = new DataTable (); dt2.Load (dtRdr)

When loading multiple rows of data using the Load method, you can first call the BeginLoadData method to avoid notification (notifications), index maintenance (index maintenance), and constraint checking (constraint checking), and then return the data through the EndLoadData method.

3. Update the records in DataTable back to the data source through the SqlDataAdapter class instance

Now we can also use an instance of the SqlDataAdapter class to update the record through DataGridView.

The Update method is overloaded by the following:

That's all for public int Update (DataRow [] dataRows); public override int Update (DataSet dataSet); public int Update (DataTable dataTable); public int Update (DataSet dataSet, string srcTable); "what is the principle of ADO.NET performance?" Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.