All You Need to Know about ADO.NET: Part 2/2
page 23 of 27
by Devarticles.com
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 41338/ 412

Designing Datasets
A DataSet is derived from an XML schema. An XML schema can:

  1. Describe 'shape' of the DataSet. In other words, it tells if the data is related or hierarchical.
  2. Validate the data being imported.
  3. Establish the relational structure of database tables.
Let's create a sample DataSet with the XML designer. We will assume that we are creating a DataSet for a new table called MyTable:

  1. Open a windows project.
  2. Select Add New Item from File menu.
  3. Select a DataSet and give it some name and then click open.
  4. Select the XML tools tab and drag an element on the designer.
  5. In place of 'Element1' type the name of the table (MyTable).
  6. Go to the next row in the element. Click the dropdown in the 1st column and select 'Attribute'.
  7. In the second column type the name of the attribute and select attribute type from the third column.
  8. You can add all the columns you need. You can also drag 'Key' from the toolbox and define a key for your table.
  9. Save the schema.
  10. Now, if you want another table, just follow the same steps over.

View Entire Article

Article Feedback

Title:  
Name:  
Url: ( Optional )
Comment:  
Please add 6 and 4 and type the answer here:

User Comments

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
Product Spotlight 
Learn More
.NET Tools
asp.net shopping cart
asp.net chart control






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2008 ASPAlliance.com  |  Page Processed at 11/20/2008 8:03:18 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search