Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16275 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
Which is faster datareader or dataadapter?
List the 4 common ado.net namespaces?
What is the difference between Response.Expires and Reponse.ExpiresAbsolute?
Which object of ado contains datarow datacolumn collection?
What does executereader return?
What are the objects of ado.net?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
What is the difference between Optimistic and Pessimistic locking?
What is maximum pool size in ado.net connection string?
What is dao and ado?
Why do we use sqldataadapter?
How does entity framework work?
How do you connect to sql server database without using sqlclient?
What is execute scalar in ado.net?
What is the difference between data reader and data adapter?
