471,356 Members | 1,657 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,356 software developers and data experts.

Configuration of DataAdapter

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 ?
Jul 21 '05 #1
3 1020
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
"Oriane" wrote:
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 ?

Jul 21 '05 #2
I've got a primary key for sure.

"DotNetJerome" <reachjerome@_yahoo.com-remove-the-underscore-after@> a écrit dans le message de news: 18**********************************@microsoft.com...
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


"Oriane" wrote:
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 ?

Jul 21 '05 #3
I had to re-create the table from scratch, and ... it works again.
"Oriane" <or****@guermantes.com> a écrit dans le message de news: eY**************@TK2MSFTNGP12.phx.gbl...
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 ?
Jul 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Stephen Noronha | last post: by
6 posts views Thread by Geoff Pennington | last post: by
13 posts views Thread by Doug Bell | last post: by
8 posts views Thread by Zorpiedoman | last post: by
2 posts views Thread by susan.f.barrett | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.