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

Why ca not we use multiple inheritance and garbage collector paralelly in .net?

0 Answers  


What are the major difference between classic ADO and ADO.NET?

0 Answers  


How to perform sorting on a table in ADO.NET?

0 Answers   Petranics Solutions,


What provider ado.net use by default? Explain the role of data provider in ado.net?

0 Answers  


What are the functions of oledbdataadapter?

4 Answers  






What is basic use of data view?

0 Answers  


What are the major challenges in accessing data from a database?

0 Answers  


What are the advantages using ado.net?

0 Answers  


What is executenonquery ado.net?

0 Answers  


can we change the data in dataset? if yes what is the process?

1 Answers   Artech,


Explain ado.net features?

0 Answers  


What is the use of sqldatareader class?

0 Answers  


Categories