Answer / sandeep singh shekhawat

There are two type of Data set

When We create dataset programmely taht is weak type data set.
like DataSet ds=new DataSet();

But when We Create a DataSet using XML Schema(Xsd) that is called strong type data set that has extension .xsd
and create when we do working with LINQ to XML.

Answer / radheshaym

A typed dataset is derived from the Dataset class and has an
associated XML schema, which is created at the time of
creation of the datset.
An Untyped dataset does not have any associated XML shema.In
an untyped dataset,the tables and columns are represented as
collections.Because an XML shema is not created for an
untyped datset,the structure of an untyped dataset is not
known during compilation.

Answer / shiva

Dataset is collection of datatables.the collection generaly
represented as *)tables-rows-columns-constraints
DataSet ds;//declre variable
->ds.Tables["index"]
->ds.Tables.Rows[index]
->ds.Tables.Rows[rIndex].[cindex]
->ds.Tables.Columns[inedx]
->ds.tables.Constraints[index]

What are the steps to connect to a database?

0 Answers  

---

Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

0 Answers  

---

How can we perform transactions in .net?

0 Answers  

---

What is ado.net explain with diagram?

0 Answers  

---

What does datareader object do?

0 Answers  

---

How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();

2 Answers   Mind Tree, TCS,

---

Does executenonquery return a value?

0 Answers  

---

What are the different row versions available in table?

0 Answers  

---

What are the Data providers in ADO.Net?

0 Answers  

---

What providers does ado.net uses internally ?

3 Answers   Digital GlobalSoft,

---

How to find the given query is optimised one or not?

0 Answers  

---

What is ado.net connection?

0 Answers  

---