What is datatable?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What do you mean by performing asynchronous operation using command object?
Explian About DataAdapters
What is ado or jdbc?
What is ado.net code?
Difference between OLEDB Provider and SqlClient ?
what is clustered index?why is it created?
What is ado full form?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
WHAT IS DIFF B/W VIEWS AND STORED PROCEDURE
How will you fill the gridview by using datatable object at runtime?
How to connect and retrieve data from database using dataset
what is a dataview?why is it used for?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)