What is datatable?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we load multiple tables in to dataset?

571


What is datasource in ado.net?

585


What is difference between dataset and datatable?

511


What is difference between datatable and dataset?

524


How can I retrieve two tables of data at a time by using data reader?

511






What are the different execute methods of Ado.Net?

553


List all the steps in order, to access a database through ado.net?

583


How do you connect to sql server database without using sqlclient?

561


What is sqldatasource?

523


How can we add relation between tables in a dataset?

547


What we do with the object of ado.net dataset after using it?

522


What are the different row versions available in table?

529


What is the difference between dataset and datatable?

485


What is the return type of executescalar?

495


Can datareader hold data from multiple tables?

675