When I configure the dataAdaptor i get "Could not determine which columns
uniquely identify the rows for TableName" and so the update and delete
statements are not built.

marcmc wrote:
Do you have a primary key set?

Chris

marcmc,

Does the table have a primary key defined?

Kerry Moorman


Show quoteHide quote

yep and a unique clustered index

i dropped the unique clustered index and now the message is "There were
errors configuring the data adapter."

Marc,

What do you mean by bug, is that to let the Microsoft people not look
anymore to these messages. You hide now real bugs with your message. So
please write only about a bug when you sure it is.

I will spare you how most active persons in this newsgroup call your
question.

Cor

Show quoteHide quote

Cor,
I apologise if I have broken any of the guidelines or rules regarding my post.
I have changed the title to DataAdaptor Issue.
I'll be honest I was hoping that the title would encourage more people to
look at it.
I've been using Microsoft.public on a number of different technologies for
many years and am unaware of any rule about this. Maybe you can clarify? Is
it a known issue? Is there a recommendation to solve?

anyway, does anyone know how to solve this?

marcmc wrote:
I also think you must configure your DATABASE to have a primary key.

Most likely is the key not a part of your select statement.

Cor

Show quoteHide quote

Multiple fields in a single textbox
Image Resource - not released
Unhandled exception
Updating Data from a dataGrid
Sending an Email from .net?
Translate Visual C++ to VB.NET
Closing all forms at once
How to import always the FIRST available sheet from EXCEL-File
Vb.Net 2003 Quirks
How to create a new sheet in EXCEL-File via OLEDBProvider