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,

---

About ADO and its objects ?

1 Answers   DELL,

---

How to check if the Dataset has records ?

0 Answers   NA,

---

Some important instruction regarding ADO.NET connection string ?

0 Answers   NA,

---

What providers do you use to connect to oracle database ?

4 Answers   Digital GlobalSoft,

---

---

What is disconnected scenario in entity framework?

0 Answers  

---

What are relation objects in dataset and how & where to use them?

1 Answers  

---

What is ole2 format?

0 Answers  

---

Explain all the classes those are used for database connections between sql server and asp.net?

0 Answers  

---

What is the difference between Datareader and Dataset?

0 Answers  

---

Does dapper use ado.net?

0 Answers  

---

How do you update a dataset in ado.net?

0 Answers  

---