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

This article mainly shows you "how to use ADO.NET database", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "how to use ADO.NET database" this article.

The implementation method is somewhat similar to the ADO.NET database. The ADO.NET database to populate the ADO.NET database, or you can modify the data and then submit it to modify the specific data: thus, the structure and data of people, the table of DataSet, are copied into DataTable

Dim row as DataRow = dtable.NewRow ()

Row (0) = "Philip" row (1) = "Quinn" dtable.Rows.Add (row) dtable.AcceptChanges

So we create a new DataRow, just like creating a new data column with dtable.NewRow (), and we can also name the column Fname.

Instructions for using ADO.NET designer

Brief introduction to ADO.NET architecture explanation

Detailed instructions for the use of ADO.NET components

Perform ADO.NET object operation steps

The problem of establishing ADO.NET model

Because the above DataTable is from DataSet, if we update the DataTable,DataSet using the dtable.AcceptChanges method, it will also be updated:

Dim row as DataRow = dtable2.NewRow () row (0) = "Philip" row (1) = "Quinn" dtable2.Rows.Add (row) dtable2.AcceptChanges

From this diagram, we can easily figure out the relationship between DataSet, DataTable, DataRowCollection, DataRows, DataColumn, and DataColumnCollection. Create a DataSet and a DataTable; called "People" add three data columns and set their data properties; add them to the DataSet; to create another DataTable, this DataTable is a copy of the one you just created

The above is all the contents of the article "how to use ADO.NET Database". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.