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 13 of 27

by Devarticles.com
Feedback

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

Article Contents:

DataTable Objects

We use RecordSet objects as tables with ADO. Each RecordSet object corresponds to a database table. With Datasets, a similar function is handled by the DataTable object. A DataTable object is like a database table. It belongs to the datatables collection of the DataSet. If the DataSet contains data from multiple tables, one DataTable corresponds to one table or view. This way, the DataSet can mimic the structure of its underlying database. When we say that the DataSet is a container for data, we must keep in mind that the data is actually contained in the DataTable objects. In other words, a DataTable is an in memory cache of the data from one table. A DataTable can be instantiated just like any other object in VB.NET with the "New" keyword.

« (Page 12)

View Entire Article

(Page 14) »

User Comments

Title: disconnected architecture
Name: kinjalpadashala
Date: 2012-02-14 3:19:39 AM
Comment:
p/z help me how to select the data in grid and bind of textbox.

Title: thank you
Name: kartik
Date: 2011-03-24 1:04:35 AM
Comment:
is it posibile to insert the record enter at the 1st row of database every time?

Title: Ado.net Connected Architecture
Name: Vidhya Patel, India(mota)
Date: 2011-03-08 11:27:53 PM
Comment:
I use this content in my Presentation....it's very useful for me....... so thanks a lot

Title: ado.net
Name: Manimegalai
Date: 2010-09-15 3:31:43 AM
Comment:
That is great collection
thank u;;;;;;;;;;;;;;

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

Title: Ado.net
Name: Saurabh Shrivastava
Date: 2007-02-20 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: 2006-05-30 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: 2006-01-09 12:37:59 PM
Comment:
Excellent Overview. All topics are dicussed in an effective timeline.

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

Title: ADO.Net
Name: k
Date: 2005-05-03 11:31:30 AM
Comment:
to the authors thanks a lot for the unselfish information

Product Spotlight