What is datatable?
Answers were Sorted based on User's Feedback
Answer / guneetinder singh
Datatable is a sql class which is used to create a temporary
table and working on it at run time.
Is This Answer Correct ? | 29 Yes | 3 No |
Answer / badmoon
The DataTable is an in-memory representation of a block of
data. We can create our own tables in code using a DataSet
and the types defined in the System.Data.OleDb or
System.Data.SqlClient namespaces. The following are the
core properties that are used while creating a DataTable.
CaseSensitive: Indicates whether string comparisons in
the table are case-sensitive or not.
ChildRelations: Returns the collection of child relations
of the DataTable (if any).
Columns: Returns the collection of columns that belong to
this table.
Constraints: Gets the constraints maintained by this table.
DataSet: Gets the dataset that contains this table.
DefaultView: Gets a customized view of the table that may
include a filtered view or a cursor position.
MinimumCapacity: Gets/Sets the initial number of rows in
the table.
ParentRelations: Gets the collection of parent relations
for this table.
PrimaryKey: Gets/Sets a primary key for the table.
Rows: Returns the collection of rows that belong to this
table.
TableName: Gets/Sets the name of the table.
Is This Answer Correct ? | 18 Yes | 8 No |
Answer / sandyni
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.
A DataTable is a collection of DataRow and DataColumn
objects.
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.
Is This Answer Correct ? | 8 Yes | 7 No |
Diff. b/w DataReader and DataSet?
what is connection pooling ?
How can we serialize the dataset object?
List the 4 common ado.net namespaces?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
What is ado control?
Explain how to create dynamic gridview?
How can we load multiple tables in a dataset?
What is ado recordset?
Explain the different row versions available in table?
About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data ?
Give few examples of datareader that is used in different dataproviders.