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,

---

i want 2 pass values(enterd in textbox)to table in sql server without using stored procedure in c#.plz tell me code with an example.

5 Answers   Softcon, Tecra,

---

Define the data provider classes that is supported by ado.net?

0 Answers  

---

What is microsoft ado.net?

0 Answers  

---

Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

0 Answers  

---

---

What are the steps in connecting to database ?

2 Answers   Microsoft,

---

Which is faster dataset or datareader?

0 Answers  

---

How do you sort the data in datagrid?

4 Answers   Choice Solutions,

---

Which object is used to add relationship between two Datatables?

0 Answers  

---

What are the ado.net objects?

0 Answers  

---

Does sqlclient and oledb class share the same functionality?

0 Answers  

---

What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?

0 Answers  

---