Home arrow ADO.NET arrow Page 6 - Datasets in Microsoft.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
  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

Datasets in Microsoft.Net - Creating Dataset at Design Time
(Page 6 of 8 )

Right click on your project and add a new DataSet .xsd file to your project using the Add New Item dialog box.

ASP.Net datasets

Be sure to select the DataSet template in the dialog box rather than XML Schema. Selecting both item will add a new .xsd file to your project and launch the XML schema designer. However, DataSet schema files have an additional attribute set in their schema that Visual Studio .NET looks for to determine whether to treat the file as a standard XML schema or as a DataSet.

ASP.Net datasets

Once youíve added a new DataSet to your project, youíll see the same designer that you saw when we generated a DataSet based on DataAdapter objects, except that your new DataSet will be empty. Letís add a new DataTable to the Dataset. Next figure shows the shortcut (context) menu that appears when you right-click on the designer. Choose Add and then New Element from the shortcut menu to add a new DataTable to the DataSet. You can also choose the same command from the Schema menu.

blog comments powered by Disqus

- 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 

Developer Shed Affiliates


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