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
- 16039 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
Explian About DataAdapters
What is defaultview in datatable?
What do you know about ado.net's objects?
What is an ado connection?
Command objects uses, purposes and their methods.
Why is ADO.NET serialization slower than ADO ?
How to identify the updated rows in a dataset?
What is executenonquery ado.net?
What is the namespaces being used to access oracle database?
How can we save all data from dataset?
What is dataset object? Explain the various objects in dataset.
What does adodb stand for?
What is sql connection in ado.net?
What is sqlconnection and sqlcommand?
What are the data providers in ADO.NET framework?
