Answer / vaidyanathan r.

Dataset is a collection of Datatables along with their
relations. Dataset is the copy of part/full of the actual
data base stored in the application during execution for
data manipulations.

And there is no equivalent methods to previous and next
methods of ADO as each table is treated as a seperate
objects inside the Dataset. However a particular record can
be retrieved by the "Rows" property of the Data Table.

Eg: DataRow dr = DataSet1.Tables[<TableIndex>].Rows
[<RowIndex>]

What is sql connection in ado.net?

0 Answers  

---

What is the difference between Datareader and Dataset?

0 Answers  

---

Sequence to connect and retrieve data from database useig dataset ?

6 Answers   MMTS,

---

What are good ado.net object to replace to ado recordset object.

0 Answers  

---

Why ca not we use multiple inheritance and garbage collector paralelly in .net?

0 Answers  

---

What is data reader in ado.net?

0 Answers  

---

What two types of data providers does ADO.NET supply? What determines which one you should use?

0 Answers   CDC,

---

What is the meaning of executenonquery?

0 Answers  

---

What are the 3 major types of connection objects in ado.net?

0 Answers  

---

How do you filter the data in datagrid?

2 Answers   Apps Lab, Choice Solutions,

---

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,

---

How do you implement locking concept for dataset?

0 Answers  

---