All You Need to Know about ADO.NET: Part 2/2: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
All You Need to Know about ADO.NET: Part 2/2

page 19 of 27

by Devarticles.com
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 54947/ 465

Article Contents:

Record Management

Inserting a record

A blank record is inserted by using the NewRow method. The new row inherits all of the columns from the concerned table's DataColumnCollection collection:

Dim anyRow as DataRow = ExistingTable.NewRow

The code shown above is an example of adding a row. A row can be added using the add method of the DataRowCollection. After the new blank record is added, it is treated like an existing record and updated in the same way.

Deleting a record

A record is deleted using the Delete method of the DataRow object:

DsCustomers1.Customers.Rows(0).Delete()

Merging two Datasets

You can merge two Datasets by using Merge method of the DataSet object.

« (Page 18)

View Entire Article

(Page 20) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 8 and 4 and type the answer here:

User Comments

Title: Thanks
Name: Amin Anwar
Date: 5/14/2009 5:19:09 AM
Comment:
That isgr8 collection;;;
thanks

Title: Ado.net
Name: Saurabh Shrivastava
Date: 2/20/2007 11:46:46 AM
Comment:
Brilliant Work,It could be more useful by giving some code in it.

Title: Thank you
Name: Jayalakshmi baskaran
Date: 5/30/2006 5:39:23 AM
Comment:
I want to create the sqldataAdapter and the Dataset in Code
Can you please help it out

Title: Ado.Net
Name: Rohan Ragoo
Date: 1/9/2006 12:37:59 PM
Comment:
Excellent Overview. All topics are dicussed in an effective timeline.

Title: XML
Name: Rajesh Medackel,India
Date: 10/1/2005 5:26:30 AM
Comment:
Good write up .... Thanx

Title: ADO.Net
Name: k
Date: 5/3/2005 11:31:30 AM
Comment:
to the authors thanks a lot for the unselfish information

Product Spotlight