What is datatable?

Question Posted / badmoon

3 Answers
13264 Views
I also Faced
E-Mail Answers

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

Why do we need ado.net?

0 Answers

How would you connect to database using .NET?

0 Answers

How would u connect to database using .NET?

5 Answers TCS, Tesco,

What are the different methods available under the sqlcommand class to access the data?