How to update a column in DataGrid using C#

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();

pen2satya
Profile Answers by pen2satya Questions by pen2satya
Oct 15th, 2007
9
3898

Questions by pen2satya

Ado.NET

Answer

Showing Answers 1 - 9 of 9 Answers

santosh.net.india

Nov 1st, 2007

Did u not set the data key property of datagrid,pl set key in data key feild

sureshnaspuri
Profile Answers by sureshnaspuri

Jul 10th, 2008

After seeing ur code i understood that u haven't call the bind method.

gridview1.EditItemIndex = -1;
after this u call the bind method .

gridview1.databind();//in this place u call the grid bind method n try it once.

ponss
Profile Answers by ponss

Jun 1st, 2009

int varid = (int)DataGrid1.DataKeys[e.Item.ItemIndex];
        TextBox lnm = (TextBox)e.Item.Cells[2].Controls[0];
        string str = lnm.Text.ToString();
        SqlCommand cmd = new SqlCommand("update customer set lastname='" + str + "' where id=" + varid, con);
        cmd.ExecuteNonQuery();
        DataGrid1.EditItemIndex = -1;
        DataGrid1.DataBind();