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

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

User Comments

Title: disconnected architecture   
Name: kinjalpadashala
Date: 2012-02-14 3:19:39 AM
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
is it posibile to insert the record enter at the 1st row of database every time?
Title: Connected Architecture   
Name: Vidhya Patel, India(mota)
Date: 2011-03-08 11:27:53 PM
I use this content in my's very useful for me....... so thanks a lot
Name: Manimegalai
Date: 2010-09-15 3:31:43 AM
That is great collection
thank u;;;;;;;;;;;;;;
Title: Thanks   
Name: Amin Anwar
Date: 2009-05-14 5:19:09 AM
That isgr8 collection;;;
Name: Saurabh Shrivastava
Date: 2007-02-20 11:46:46 AM
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
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
Excellent Overview. All topics are dicussed in an effective timeline.
Title: XML   
Name: Rajesh Medackel,India
Date: 2005-10-01 5:26:30 AM
Good write up .... Thanx
Title: ADO.Net   
Name: k
Date: 2005-05-03 11:31:30 AM
to the authors thanks a lot for the unselfish information

Product Spotlight
Product Spotlight 

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

©Copyright 1998-2024  |  Page Processed at 2024-07-15 4:20:57 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search