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

This article mainly introduces "how to create tables in ADO". In daily operation, I believe many people have doubts about how to create tables in ADO. The editor consulted all kinds of data and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts about "how to create tables in ADO". Next, please follow the editor to study!

The command constructor automatically generates the InsertCommand, UpdateCommand, and DeleteCommand properties of the data adapter based on the SelectCommand property of the data adapter (if SelectCommand executes a select ADO on a single table to create the table.

You can also create table-building DataTable objects by ADO: using the Fill or FillSchema methods of the DataAdapter object in DataSet, or using the ReadXml, ReadXmlSchema, or InferXmlSchema methods of DataSet from predefined or inferred XML schemas. Note that after you add a DataTable as a member to a DataSet Tables collection, you can no longer add it to any other DataSet table collection.

When DataTable was first created, there was no schema (that is, structure). To define the schema of a table, ADO must create a table object and add it to the table's Columns collection. You can also define primary key columns for a table, and you can create Constraint objects and add them to the table's Constraints collection. After you have defined the schema for DataTable, you can add data rows to the table by adding DataRow objects to the Rows collection of the table.

When you create a DataTable, you don't need to provide a value for the TableName property, you can specify it at other times, ADO creates the table, or leaves it empty. However, when you add a table with no TableName value to DataSet, the table gets a default name TableN incrementing from "Table" (which stands for Table0).

Description:

It is recommended that you avoid using the "TableN" naming convention when providing TableName values, as the names provided then may conflict with the existing default table names in DataSet. If the name provided already exists, an exception is thrown.

The following example creates an instance of the DataTable object, and ADO creates the table and gives it the name "Customers".

Dim customers As DataSet = New DataSet Dim customersTable As DataTable = _ customers.Tables.Add ("CustomersTable") at this point, the study of "how to create a table in ADO" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.