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 |
Is it possible to edit data in Repeater control?
What is the meaning of executenonquery?
What is sqldatareader?
How can we perform transactions in .net?
How do you update a dataset in ado.net?
What is ado or jdbc?
Which method in OLEDBAdapter is used to populate dataset with records?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
how can implement dropdownlist in particular of dataset when try to update?
What are the two fundamental objects in ADO.NET?
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
what is clustered index?why is it created?
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)