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 |
Why ca not we use multiple inheritance and garbage collector paralelly in .net?
What are the major difference between classic ADO and ADO.NET?
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?
What are the functions of oledbdataadapter?
What is basic use of data view?
What are the major challenges in accessing data from a database?
What are the advantages using ado.net?
What is executenonquery ado.net?
can we change the data in dataset? if yes what is the process?
Explain ado.net features?
What is the use of sqldatareader class?