Configuration of DataAdapter

  • Thread starter Thread starter Oriane
  • Start date Start date
O

Oriane

Hi,

When configuring a simple "Client" Sql table sqlDataAdapter, with one single primary key, I can't generate the Delete and Update command, although the Insert and Select command are generated.

The message is (translated from french...) : Impossible to determine the columns identifying uniquely the rows for "Client".

I don't understand

some ideas ?
 
Hi,

Usually the message would appear incase, if there is no primary key present
in the connected table. Make sure you've a primary key for your table.

Cheers,

Jerome. M
 
I've got a primary key for sure.

DotNetJerome said:
Hi,

Usually the message would appear incase, if there is no primary key present
in the connected table. Make sure you've a primary key for your table.

Cheers,

Jerome. M
Click to expand...
 
I had to re-create the table from scratch, and ... it works again.


"Oriane" <[email protected]> a écrit dans le message de news: (e-mail address removed)...
Hi,

When configuring a simple "Client" Sql table sqlDataAdapter, with one single primary key, I can't generate the Delete and Update command, although the Insert and Select command are generated.

The message is (translated from french...) : Impossible to determine the columns identifying uniquely the rows for "Client".

I don't understand

some ideas ?
 
Back
Top