Database

  • Thread starter Thread starter Mike B
  • Start date Start date
M

Mike B

I'm new to C# (standard edition). I was trying to work
with an Access detabase and a datagrid. When I drag a
table from the Server Explorer to my form, I am getting an
error generating UPDATE and DELETE commands ("could not
uniquely identify the rows for Table1"). I have a key
field defined in Access-what am I doing wrong?

Other than that it works OK (creating a dataset, linking
it to datagrid, etc.) in that I can display the records on
my form.

Thanks for any help,

Mike B
 
Mike

I have tried this with sql 2000 and access and i was getting the error until
I set the primary key on the table to a column with unique values(ensure
that your column has unique values otherwise the primary key will not be
set. This column also has a setting which does not allow nulls.

Also once you have set the primary key, I would delete your connection from
server explorer in dot net, then re-establish your connection. Once you
have done this, place the table on to the form.

Hope it works!
Kuv Patel
 
Back
Top