edit row from datagrid while hiding the record ID

[Dica]

i need to allow the user to select a row from my dataGrid for editing. as
such, i include the record ID in the first column and then extract like so
when retrieving the record details:

protected void gvLocations_edit(object sender, GridViewEditEventArgs e)
{
// load the record details into the edit fields //
GridView gvRecord = (GridView)sender;
string sThisRecord = gvRecord.Rows[e.NewEditIndex].Cells[0].Text;
...
}

i've been told i need to exclude the record ID from the datagrid, so i set
the column's visibility property to false. now my code fails as index[0] is
no longer the record id but a varChar column.

how to fix?

tks

 

[Mark Rae [MVP]]

i need to allow the user to select a row from my dataGrid for editing. as
such, i include the record ID in the first column and then extract like so
when retrieving the record details:

protected void gvLocations_edit(object sender, GridViewEditEventArgs e)
{
// load the record details into the edit fields //
GridView gvRecord = (GridView)sender;
string sThisRecord = gvRecord.Rows[e.NewEditIndex].Cells[0].Text;
...
}

i've been told i need to exclude the record ID from the datagrid, so i set
the column's visibility property to false. now my code fails as index[0]
is no longer the record id but a varChar column.

how to fix?

You're using a GridView, not a DataGrid - it's really helpful to call things
by their correct names when posting in these newsgroups...

Hidden columns in GridViews are not rendered by default to the client as a
security measure - the DataKeyNames property should be used instead:
http://msdn2.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.datakeynames(vs.80).aspx

Alternatively, you can force the hidden column(s) to be databound and
rendered, but this is not recommended:

MyGridView.DataSource = <datasource>;
MyGridView.Columns[0].Visible = true;
MyGridView.DataBind();
MyGridView.Columns[0].Visible = false;