Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

0 Answers  

---

What is the use of data grid?

0 Answers  

---

What is difference between Dataview and Datatable?

0 Answers  

---

What is ado recordset?

0 Answers  

---

Explain the difference between data reader and data set?

0 Answers  

---

---

How to create dynamic gridview?

0 Answers   MCN Solutions,

---

What is the Magic Tables in Sqlserver2000?

7 Answers   IBM, SQL Star,

---

Difference between OLEDB Provider and SqlClient ?

2 Answers  

---

What are the advantages using ado.net?

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,

---

What?s the role of the DataReader class in ADO.NET connections?

7 Answers   Honeywell, Ksb,

---

What are the advantages of using datalist?

0 Answers  

---