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 are the different layers of ado.net?

0 Answers  

---

Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

0 Answers  

---

What is ado.net code?

0 Answers  

---

What is ODP.NET ?

1 Answers   TCS,

---

About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data ?

1 Answers   MMTS,

---

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

0 Answers  

---

Is it possible to edit data in Repeater control?

0 Answers  

---

How to check if the Dataset has records ?

0 Answers   NA,

---

Compare Data Reader & Dataset in ado.net?

0 Answers   MaxSolPro,

---

What are the advantages and drawbacks of using ado.net?

0 Answers  

---

what purpose of Indexing creating? directly we can search the reqired row with the help of query?what is the use of indexing?

3 Answers  

---