Editing a row in a datagrid

[mareal]

I have coded an updatable datagrid and can’t seem to obtain the original
value from the cell in order to run an update on the database. I can obtain
the (new) value typed by the user (see DataGrid1_Update), but I also need the
original/old value. How can I obtain it?

void DataGrid1_Edit(object sender, DataGridCommandEventArgs e)
{
DataGrid1.EditItemIndex = (int) e.Item.ItemIndex;
ddlTransmissionName_SelectedIndexChanged(sender, (System.EventArgs) e);
}

void DataGrid1_Update(object sender, DataGridCommandEventArgs e)
{
System.Web.UI.WebControls.TextBox tbFieldName = new TextBox();
tbFieldName = e.Item.FindControl("txtFieldName") as
System.Web.UI.WebControls.TextBox;
string sFieldName = tbFieldName.Text;

DataGrid1.EditItemIndex = -1;
ddlTransmissionName_SelectedIndexChanged(sender, (System.EventArgs) e);
}

[Elton W]

Hi Mareal,

You can save the datagrid's data source, e.g. datatable
(original/old value), in Session or Context object. Then
in Update method retrieve corresponding value from the
data source.

HTH
Elton Wang
el********@hotmail.com

-----Original Message-----
I have coded an updatable datagrid and canâ?Tt seem to obtain the original value from the cell in order to run an update on the database. I can obtain the (new) value typed by the user (see DataGrid1_Update), but I also need the original/old value. How can I obtain it?

void DataGrid1_Edit(object sender, DataGridCommandEventArgs e) {
DataGrid1.EditItemIndex = (int) e.Item.ItemIndex;
ddlTransmissionName_SelectedIndexChanged(sender , (System.EventArgs) e);}

void DataGrid1_Update(object sender, DataGridCommandEventArgs e) {
System.Web.UI.WebControls.TextBox tbFieldName = new TextBox();tbFieldName = e.Item.FindControl("txtFieldName") as
System.Web.UI.WebControls.TextBox;
string sFieldName = tbFieldName.Text;

DataGrid1.EditItemIndex = -1;
ddlTransmissionName_SelectedIndexChanged(sender , (System.EventArgs) e);}

.