What is datatable?

Answers were Sorted based on User's Feedback



What is datatable?..

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

What is datatable?..

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

What is datatable?..

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

Post New Answer

More ADO.NET Interview Questions

Diff. b/w DataReader and DataSet?

8 Answers   Avon, Value Labs,


what is connection pooling ?

3 Answers   Vertex,


How can we serialize the dataset object?

0 Answers  


List the 4 common ado.net namespaces?

0 Answers  


Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

0 Answers  






What is ado control?

0 Answers  


Explain how to create dynamic gridview?

0 Answers  


How can we load multiple tables in a dataset?

0 Answers  


What is ado recordset?

0 Answers  


Explain the different row versions available in table?

0 Answers  


About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data ?

1 Answers   MMTS,


Give few examples of datareader that is used in different dataproviders.

0 Answers  


Categories