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

This article focuses on "how to add records in ADO". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to add records in ADO.

Not all databases support zero-length strings, and ADO adds records so errors may occur when adding records with blank fields. Therefore, it is important to check the data types supported by the database you are using, and you can enter zero-length strings (") in text, hyperlinks, and memo fields.

We want to add a new record to the Customers table in the Northwind database. First we need to create a form, ADO add record, which contains the input fields from which we need to collect data:

CustomerID: Company Name: Contact Name: Address: City: Postal Code: Country:

ADO add record when the user presses the confirm button, the form is sent to a file named "demo_add.asp". The file "demo_add.asp" contains code to add a new record to the Customers table:

Adding a record object structure to ADO is still very complex, and in the next layer of the DataSet object are DataTableCollection objects, DataRelationCollection objects, and ExtendedProperties objects. As mentioned above, each DataSet object is made up of several DataTable objects. DataTableCollection is to manage all DataTable objects in DataSet. Indicates that the parent / child relationship between two DataTable objects in DataSet is a DataRelation object. It associates rows in one DataTable with rows in another DataTable.

This association is similar to the association between primary key columns and foreign key columns between tables in a relational database. The DataRelationCollection object manages the DataRelation relationship between all the DataTable in the DataSet. DataSet, ADO add record, and DataColumn all have ExtendedProperties attributes in DataSet. ExtendedProperties is actually a PropertyCollection, and ADO adds records to store a variety of custom data, such as SELECT statements that generate datasets.

At this point, I believe you have a deeper understanding of "how to add records in ADO". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue 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.