Home arrow ADO.NET arrow Page 2 - Datasets in Microsoft.Net
ADO.NET

Datasets in Microsoft.Net


ADO.NET was designed to meet the needs of a new programming model: disconnected data architecture, tight integration with XML, common data representation with the ability to combine data from multiple and varied data sources, and optimized facilities for interacting with a database, all native to the .NET Framework.The ADO.NET DataSet is a memory-resident representation of data that provides a consistent relational programming model regardless of the source of the data it contains.

Author Info:
By: Raghav Nayak
Rating: 4 stars4 stars4 stars4 stars4 stars / 159
March 24, 2004
TABLE OF CONTENTS:
  1. · Datasets in Microsoft.Net
  2. · RecordSet Objects
  3. · Validating data in DataSet
  4. · Validation Properties of the DataColumn
  5. · The DataTable Object’s Constraints Collection
  6. · Creating Dataset at Design Time
  7. · Adding DataColumn Objects
  8. · New DataSet

print this article
SEARCH DEVARTICLES

Datasets in Microsoft.Net - RecordSet Objects
(Page 2 of 8 )

For example, if you use just the default settings for the ADO Recordset and Connection objects, you cannot get an accurate count of the number of rows in the Recordset. The Recordset object has a Supports method that developers often use to determine the functionality available: Can I modify the contents of the Recordset? If I update a row, will the Recordset send the change to the database immediately or will it be cached? Can I bind my Recordset to a grid? Can I move to the previous row?

The reason that not all Recordset objects support the same functionality is that the Recordset object tries to be everything to everyone. Whether you’re working with a firehose cursor, a server-side cursor, or disconnected data in ADO, you’re using a Recordset object.

Creating a DataSet

Using VB.Net


 Dim ds As New 
DataSet("DataSetName")
 Console
.WriteLine(ds.DataSetName)

Using C#.Net


DataSet ds = new 
DataSet("DataSetName");
Console
.WriteLine(ds.DataSetName);

Filling the DataSet Object

Filling the data from database into dataset object is a very easy process. Here we can use either SQL query or a stored procedure. Below is the example of how to fill data using query.

Using VB.Net


Dim strConnstrSQL As 
String
strConn 
"Provider=SQLOLEDB;Data Source=(local)NetSDK;" 
_
          
"Initial 
Catalog=Northwind;Trusted_Connection=Yes;"

strSQL 
"SELECT CustomerID, 
CompanyName, ContactName, Phone " 

_
         
"FROM Customers"
Dim da 
As New OleDbDataAdapter(strSQLstrConn)
Dim ds 
As New 
DataSet()
da
.Fill(ds"Customers")

Using C#.Net


string strConn
strSQL;
strConn 
"Provider=SQLOLEDB;Data Source=(local)\NetSDK;" 
+
          
"Initial 
Catalog=Northwind;Trusted_Connection=Yes;"
;
strSQL 
"SELECT CustomerID, 
CompanyName, ContactName, Phone " 
+
         
"FROM 
Customers"
;
OleDbDataAdapter da 
= new OleDbDataAdapter(strSQL
strConn);
DataSet ds 
= new DataSet();
da
.Fill(ds
"Customers");


blog comments powered by Disqus
ADO.NET ARTICLES

- Datasets in Microsoft.Net
- Latest Developments in the .Net World
- Introduction to .NET
- Automatic Generation of Single Table SQL Sta...
- Data Access in .NET using C#: Part 1
- All You Need To Know About ADO.NET: Part 2/2
- All You Need To Know About ADO.NET: Part 1/2
- Easing Transition From ASP and ADO to ASP.NE...
- A Practical Comparison of ADO and ADO.NET

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials