Displaying the id/PK in a gridview?

#1

So how does everyone hide the primary key in a gridview with a datasource to
a table, let's say. If you don't display it, then you can't update the
records. Users don't want to see this field, particularly if it's a guid.
Example:

Select ID, ProductName from tblProducts is the datasource

The gridview has 2 bound fields, the id and the productname. If you set the
id to invisible, it's not rendered and it is lost when you attempt to update
that record.

#2

Add "ID" to the DataKeyNames property and take out of the query.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net

"eagle" <eagletender2001 (AT) yahoo (DOT) com> wrote

Quote:

So how does everyone hide the primary key in a gridview with a datasource
to a table, let's say. If you don't display it, then you can't update the
records. Users don't want to see this field, particularly if it's a guid.
Example:

Select ID, ProductName from tblProducts is the datasource

The gridview has 2 bound fields, the id and the productname. If you set
the id to invisible, it's not rendered and it is lost when you attempt to
update that record.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Displaying the id/PK in a gridview?

ASP.net Data Grid Control microsoft.public.dotnet.framework.aspnet.datagridcontrol

Displaying the id/PK in a gridview? - 07-18-2007 , 09:15 AM

Re: Displaying the id/PK in a gridview? - 07-19-2007 , 05:02 AM