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
- 15221 Views
- Mind Tree, TCS, I also Faced
- E-Mail Answers
Answer Posted / aravazhi
Try this query you can avoid InvalidCastException...
string strQry = "update customer set lastname=@LastName
where id=@VarId";
SqlCommand cmd=new SqlCommand(strQry,con);
int varid = (int)DataGrid1.DataKeys[(int)e.Item.ItemIndex];
string LName = ((TextBox)e.Item.FondControl
("txtLName")).Text;//txtLname is ID of control
cmd.Paramters.Add(new SqlParameter("@LastName",LName));
cmd.Paramters.Add(new SqlParameter("@VarId",varid));
cmd.ExecuteNonQuery();
DataGrid1.EditItemIndex=- 1;
DataGrid1.DataBind();
| Is This Answer Correct ? | 15 Yes | 4 No |
Post New Answer View All Answers
What is microsoft ado.net?
What is the difference between Data adaptor and Data set?
Why is ADO.NET serialization slower than ADO ?
Is ado.net an orm?
How to maintain the relation between two tables in ADO.NET?
What are the important features of ado.net 2.0?
Which namespaces are used for data access?
What is ado and rdo?
Can we load multiple tables in a dataset?
What is difference between datareader and dataadapter?
What is difference between Dataview and Datatable?
What is ambient transaction?
What provider ado.net use by default? Explain the role of data provider in ado.net?
Explain the different row versions available in table?
What is connection in ado.net?
