PC Review


Reply
Thread Tools Rate Thread

Configuration of DataAdapter

 
 
Oriane
Guest
Posts: n/a
 
      21st Feb 2005
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 ?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?RG90TmV0SmVyb21l?=
Guest
Posts: n/a
 
      21st Feb 2005
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 ?
>

 
Reply With Quote
 
Oriane
Guest
Posts: n/a
 
      21st Feb 2005
I've got a primary key for sure.

"DotNetJerome" <reachjerome@_yahoo.com-remove-the-underscore-after@> a écrit dans le message de news: 18F6BE3A-7F0D-4A80-AAAC-(E-Mail Removed)...
> 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 ?
>>

 
Reply With Quote
 
Oriane
Guest
Posts: n/a
 
      21st Feb 2005
I had to re-create the table from scratch, and ... it works again.


"Oriane" <(E-Mail Removed)> a écrit dans le message de news: (E-Mail 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 ?
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
RE: DataAdapter Configuration Wizzard David Sceppa Microsoft ADO .NET 1 25th May 2005 05:50 PM
Exception thrown by the dataAdapter configuration wizard Oriane Microsoft ADO .NET 2 25th Feb 2005 09:50 AM
Configuration of DataAdapter Oriane Microsoft ADO .NET 3 21st Feb 2005 01:42 PM
Exception raised by the DataAdapter Configuration Wizard Oriane Microsoft Dot NET 1 15th Feb 2005 04:16 PM
Exception raised by the DataAdapter Configuration Wizard Oriane Microsoft ADO .NET 1 15th Feb 2005 04:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:36 AM.