SqlDataSource - CRUD options grayed out

[nospam]

Hello all,

Using Net 2 0 and VS 2005 and MSSQL 2000...

I am a newbie to ASP. I am trying to created a screen to manipulate a
table - CRUD commands.

The problem is the checkbox to autogenerate the CRUD commands is grayed out.
- Drop SqlDataSource on design
- CreateNewConnection
- Login w/Windows authentication, test connection ok.
- Select table. Select all fields '*'.
- Select Advanced tab - both the 'Generate Insert, Update, Delete' and
'Use Optiomistic Concurency' buttons are grayed out.

I have tried saving select and reloading solution. No good.
I tried using 'sa' as the user. No good.
I double checked that the table in SS had permission to modify.

I tested with Northwind db and it works. crap!

Anyone have any ideas.

Many thanks,
bruce

[nospam]

Found my problem - no primary key on the table.

Thx.

"nospam" <[e-mail] in message
news:HqSHi.12720$mk2.11585@trnddc07...

Hello all,

Using Net 2 0 and VS 2005 and MSSQL 2000...

I am a newbie to ASP. I am trying to created a screen to manipulate a
table - CRUD commands.

The problem is the checkbox to autogenerate the CRUD commands is grayed
out.
- Drop SqlDataSource on design
- CreateNewConnection
- Login w/Windows authentication, test connection ok.
- Select table. Select all fields '*'.
- Select Advanced tab - both the 'Generate Insert, Update, Delete' and
'Use Optiomistic Concurency' buttons are grayed out.

I have tried saving select and reloading solution. No good.
I tried using 'sa' as the user. No good.
I double checked that the table in SS had permission to modify.

I tested with Northwind db and it works. crap!

Anyone have any ideas.

Many thanks,
bruce