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 is maximum pool size in ado.net connection string?

0 Answers  

---

How does entity framework work?

0 Answers  

---

what are types of Dataset ?

6 Answers   HCL,

---

Explain how can we load multiple tables in to dataset?

0 Answers  

---

---

What are the Different layers in ADO.Net?

10 Answers   eXensys,

---

Explain the role of data provider in ado.net?

0 Answers  

---

How can I retrieve two tables of data at a time by using data reader?

0 Answers  

---

How do you connect to sql server database without using sqlclient?

0 Answers  

---

What happens when u try to update data in a dataset in .NET while the record is already deleted in SQL SERVER as backend?

5 Answers  

---

Which provider is used to connect ms access, oracle, etc…?

0 Answers  

---

What is sqldatareader in ado.net?

0 Answers  

---