what is typed and untyped dataset
Answers were Sorted based on User's Feedback
Typed vs. Untyped Datasets
A DataSet can be Typed or Untyped. The difference between
the two lies in the fact that a Typed DataSet has a schema
and an Untyped DataSet does not have one. It should be
noted that the Typed Datasets have more support in Visual
studio.
| Is This Answer Correct ? | 34 Yes | 3 No |
Answer / parvez borkar
Typed Dataset provide compile time type checking. Also it
provides the names of the Columns of the types we are using
for that typed data set. This is something we dont get in
the normal datasets.
| Is This Answer Correct ? | 20 Yes | 7 No |
We can generate Typed Dataset based on a single table or
multiple tables which are related by using primary key and
foreign key relationships through visual stdio which
generates a xsd file. This is a strongly typed in-memory
cache of data.
Untyped dataset is one which is filled/generated using a
DataAdapter and a command object.
| Is This Answer Correct ? | 15 Yes | 3 No |
How to add a javaScript function in a datagrid?
How to add a check box or a dropdown list to a column in a datagrid?
How can we add relation between tables in a dataset?
What are the core objects of ADO.NET?
Which is faster ado.net or linq?
What is disconnected architecture in ado.net?
What is openquery?
what is Sql Native Client?
What is the difference between sqldatareader and sqldataadapter?
How will you fill the gridview by using datatable object at runtime?
How to add an aggregate column?
OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it
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)