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 we can provide data to ado.net?

551


What is full form of ado?

549


What is fill method in ado.net?

547


Does sqlclient and oledb class share the same functionality?

544


Data reader read and forward only, how is it possible to get 2 tables of data at a time?

505






Explain how to pass multiple tables in datasets simultaneously?

501


describe the dataset object in ado.net.

530


Which database is the ado.net?

509


What are the parameters that control most of connection pooling behaviors?

519


What is the use of ADO.NET and XML web services?

600


What is the difference between ADO and ADO.Net?

597


How do you update a dataset in ado.net?

557


How to generate a single aggregate?

548


What is ado.net and its architecture?

511


What is ado.net object model?

517