Diff B/W DataSet vs DataTable
Answers were Sorted based on User's Feedback
Answer / ruchi
A dataset can hold the data of multiple tables, whereas
data table can have only one table's data.
| Is This Answer Correct ? | 42 Yes | 3 No |
Answer / pranshu sharma
DataSet objects contains multiple DataTable objects.
| Is This Answer Correct ? | 26 Yes | 4 No |
Answer / ajay singh negi
Dataset is a collection of tables, which is used in
disconnected architecture.generally to fill dataset we use
fill method of dataadapter. datatable is just like table
which has columns and rows.
or
A DataSet is an in memory representation of data,It
containing one or more DataTables.
A DataTable is an in-memory representation of data,
typically retrieved from a database or XML source.
| Is This Answer Correct ? | 13 Yes | 3 No |
Answer / bharat pandey
The Best Difference between data table and dataset is that
the DataSet is serialized data source whereas datatable is
not. That is why web services can always returns dataset as
the result but not the datatables. All of the above answers
are childish and they can destroy your interview in just a
sec. when you answer those.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sandyni
A DataSet is an in memory representation of data,It
containing one or more DataTables.
A DataTable is an in-memory representation of data,
typically retrieved from a database or XML source and that
can hold only one table data
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / umarali1981
DataTable:
1.Meaning: A DataTable is an in-memory representation of a
single database table which has collection of rows and columns
2.Number of rows retrieved at a time:DataTable fetches only
one TableRow at a time
3.Provision of DataRelation Objects:As DataTable is a single
database table, so there is no DataRelation object in it.
4.Enforcing Data Integrity:In DataTable, there is no
UniqueConstraint and ForeignKeyConstraint objects available.
5.DataSource can be Serialized or Not:In DataTable,
DataSource cannot be serialized.
6.To know the example for DataTable, please try the URL:
http://www.dotnetperls.com/datatable
DataSet:
1.Meaning:A DataSet is an in-memory representation of a
database-like structure which has collection of DataTables.
2.Number of rows retrieved at a time:DataSet can fetch
multiple TableRows at a time
3.Provision of DataRelation Objects: In DataSet, DataTable
objects can be related to each other with DataRelation objects.
4.Enforcing Data Integrity:In DataSet, data integrity is
enforced by using the UniqueConstraint and
ForeignKeyConstraint objects.
5.DataSource can be Serialized or Not:DataSet is serialized
DataSource .That is why web services can always returns
DataSet as the result but not the DataTables.
6.To know the example for DataSet, please try the URL:
http://www.dotnetperls.com/dataset
Reference:
http://onlydifferencefaqs.blogspot.in/2012/08/difference-between-datatable-and-dataset.html
| Is This Answer Correct ? | 0 Yes | 0 No |
Differences between dataset.clone and dataset.copy?
What's the difference between Dataset.clone and Dataset.copy?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
Define different execute methods of ADO.NET command object ?
Do you use stored procedure in ado.net?
what is the criteria of selection in sbi interview?
1 Answers BCS, State Bank Of India SBI,
What is the difference between Dataset. clone and Dataset.copy?
Explain advantages of ado.net?
If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?
Define data access layer?
What do you mean by ‘batch updates’?
Can we load multiple tables in a dataset?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)