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();
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
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
What is linq and entity framework?
What provider ado.net use by default? Explain the role of data provider in ado.net?
Define the executescalar method?
How can we load multiple tables in a dataset?
How to add a check box or a dropdown list to a column in a datagrid?
Where is adodb dll located?
What Is Difference Between Ado And Ado.net?
How to check if a datareader is closed or opened? IsClosed()
How is it possible to get 2 tables of data at a time by using data reader?
What is the advantage of ado.net?
What are the Features and disadvantages of dataset
What is the difference between linq and ado.net?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What are the major difference between classic ADO and ADO.NET?