Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / abhishek
A DataSet is made up of a collection of tables, relationships, and constraints. In ADO.NET, DataTable objects are used to represent the tables in a DataSet. A DataTable represents one table of in-memory relational data; the data is local to the .NET-based application in which it resides, but can be populated from a data source such as Microsoft SQL Server using a DataAdapter For more information, see Populating a DataSet from a DataAdapter (ADO.NET).
The DataTable class is a member of the System.Data namespace within the .NET Framework class library. You can create and use a DataTable independently or as a member of a DataSet, and DataTable objects can also be used in conjunction with other .NET Framework objects, including the DataView. You access the collection of tables in a DataSet through the Tables property of the DataSet object.
The schema, or structure of a table is represented by columns and constraints. You define the schema of a DataTable using DataColumn objects as well as ForeignKeyConstraint and UniqueConstraint objects. The columns in a table can map to columns in a data source, contain calculated values from expressions, automatically increment their values, or contain primary key values.
In addition to a schema, a DataTable must also have rows to contain and order data. The DataRow class represents the actual data contained in a table. You use the DataRow and its properties and methods to retrieve, evaluate, and manipulate the data in a table. As you access and change the data within a row, the DataRow object maintains both its current and original state.
You can create parent-child relationships between tables using one or more related columns in the tables. You create a relationship between DataTable objects using a DataRelation. DataRelation objects can then be used to return the related child or parent rows of a particular row.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What is difference between executequery and executeupdate?
How can we serialize the dataset object?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
What is difference in record set and dataset?
Explain how to pass multiple tables in datasets simultaneously?
What is an orm, and why would you use one instead of plain old ado.net?
Explain the differences between oledb sql server, oledbdotnet provider?
Why is it important to close an ado.net application?
How can we load multiple tables in to dataset?
What is the significance of CommandBehavior.CloseConnection ?
How we can provide data to ado.net?
What is row state?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
What is connected architecture in ado.net?
