PRIMARY KEY required for WRITING to SQL DATABASE using DATA GRID?

[Guest]

I need an editable datagrid. But for editing a datagrid as shown in the
walkthrough: Using a DataGrid Web Control to Read and Write Data, the table
in the SQL database should have a primary key. But my table doesnt have one.
So what is the best way I can create primary key in SQL database?

Is UNIQUE IDENTIFIER a good option? Is it something like Auro Number of MS
Access which is automatically filled by the database for each row? If not ,
how can i make a primary key for that SQL table?

 

[bruce barker]

a UniqueIdentifiy in sqlserver is a GUID, not an autonumber. if you want an
autonumber add the identity constraint to an integer column.
UniqueIdentifiy has the advantage thet it can be assigned by sqlserver with
newid() function, or the caller.

-- bgruce (sqlwork.com)



| I need an editable datagrid. But for editing a datagrid as shown in the
| walkthrough: Using a DataGrid Web Control to Read and Write Data, the
table
| in the SQL database should have a primary key. But my table doesnt have
one.
| So what is the best way I can create primary key in SQL database?
|
| Is UNIQUE IDENTIFIER a good option? Is it something like Auro Number of MS
| Access which is automatically filled by the database for each row? If not
,
| how can i make a primary key for that SQL table?
| --
| pmud