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
- 16054 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 dataset object? Explain the various objects in dataset.
What are the types of databinding?
What is ole db and odbc?
How to store data in memory?
What are two types of transaction supported by ado.net?
Describe datareader object of ado.net with example.
What are the data providers used in ado.net
How to add an aggregate column?
What is the difference between statement and preparedstatement interface?
What is a datareader object?
What are good ado.net object to replace to ado recordset object.
What is the difference between typed and untyped dataset?
What is the difference between Dataset. clone and Dataset.copy?
How to add a javaScript function in a datagrid?
How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
