Answer / rajeev

It is possible to insert many records and just save it to DB
without loop.

Answer / nahaz nizam

Ya we can do it by using XML.we can send records with XML
format to the procedure as datatype xml in proc

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 you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

0 Answers  

---

Which database is the ado.net sql connection object designed for?

0 Answers  

---

how to add a selected row of a gridview to another gridview without reloading the page??

2 Answers  

---

How do you find the count of records in a dataset?

0 Answers  

---

What is the provider and namespaces being used to access oracle database?

5 Answers   E2E, Microsoft,

---

What is the use of adodc?

0 Answers  

---

WHAT Are the major major compnents of a data provider in ADO.net.

14 Answers   Infosys, Wipro,

---

Which is faster sqldataadapter and sqldatareader?

0 Answers  

---

What is the role of data provider in ado.net?

0 Answers  

---

What is command class in ado.net?

0 Answers  

---

What are all the commands used with Data Adapter?

0 Answers  

---