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 is ole db query?
Which method is used by command class to execute SQL statements that return single value?
What are good ado.net object to replace to ado recordset object.
Do you use stored procedure in ado.net?
What is the provider and namespaces being used to access oracle database?
What is executequery?
Which name space is used to get assembly details?
Difference between sqlcommand and sqlcommandbuilder?
What is the difference between a Dataset and DataReader? Can dataReader hold data from multiple tables?
3 Answers Fulcrum Logic, Merrill Lynch,
How to create data relations?
What is the difference between executequery and executenonquery?
What is a datareader object?
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)