"MikeD" <mikedotdinnis@abraxashyphenukdotcom> wrote in message
news:%23BlUTQMtDHA.1088@tk2msftngp13.phx.gbl...
> Hello,
>
> I'm still a bit new to all this and am probably asking the question the
> wrong way but...
>
> I would like to represent a SQL Table in a data grid and allow the user to
> edit the values. In my simplest scenario a table has only an ID field and
a
> Name field. What I would like to be able to do is (if possible) only show
> the Name field in the datagrid, but when I do I run into problems about
> identifying that record when I wish to save the result back to the table.
>
> So far the only way I have managed to do it is to also show the ID field
and
> have it editable, but this could cause problems as the ID is auto
generated
> by the table and can not change.
>
> If I make the ID column read only then it errors when I try to read the
> value in the Submit code.
>
> How should I do this so the ID is preferably not visible but at a minimum
is
> not editable?
>
> TIA
>
> <M>ike
>
>

"James Radke" <jradke1@wi.rr.com> wrote in message
news:%23B0Z98dtDHA.1744@TK2MSFTNGP12.phx.gbl...
> Mike,
>
> It depends on how you are planning to do the update. Are you planning on
> having a textbox entry by using the edit command within a datagrid row, or
> are you planning on simply displaying a textbox, and allowing the user to
> key the data right in, like an excel spreadsheet?
>
> Jim
>
> "MikeD" <mikedotdinnis@abraxashyphenukdotcom> wrote in message
> news:%23BlUTQMtDHA.1088@tk2msftngp13.phx.gbl...
> > Hello,
> >
> > I'm still a bit new to all this and am probably asking the question the
> > wrong way but...
> >
> > I would like to represent a SQL Table in a data grid and allow the user
to
> > edit the values. In my simplest scenario a table has only an ID field
and
> a
> > Name field. What I would like to be able to do is (if possible) only
show
> > the Name field in the datagrid, but when I do I run into problems about
> > identifying that record when I wish to save the result back to the
table.
> >
> > So far the only way I have managed to do it is to also show the ID field
> and
> > have it editable, but this could cause problems as the ID is auto
> generated
> > by the table and can not change.
> >
> > If I make the ID column read only then it errors when I try to read the
> > value in the Submit code.
> >
> > How should I do this so the ID is preferably not visible but at a
minimum
> is
> > not editable?
> >
> > TIA
> >
> > <M>ike
> >
> >
>
>