Click here to Skip to main content
15,880,796 members
Home / Discussions / C#
   

C#

 
GeneralRe: Hide the command window Pin
Steven Campbell25-Apr-05 6:24
Steven Campbell25-Apr-05 6:24 
GeneralRe: Hide the command window Pin
Dave Kreskowiak25-Apr-05 8:25
mveDave Kreskowiak25-Apr-05 8:25 
GeneralRe: Hide the command window Pin
Sheela Krishnan25-Apr-05 11:20
Sheela Krishnan25-Apr-05 11:20 
GeneralAbout Resource File Pin
SAMURAI-MAN25-Apr-05 5:35
SAMURAI-MAN25-Apr-05 5:35 
GeneralOpening a specified folder; double-clickon system tray icon Pin
Anonymous25-Apr-05 5:33
Anonymous25-Apr-05 5:33 
GeneralRe: Opening a specified folder; double-clickon system tray icon Pin
Polis Pilavas25-Apr-05 8:53
Polis Pilavas25-Apr-05 8:53 
GeneralRe: Opening a specified folder; double-clickon system tray icon Pin
mav.northwind25-Apr-05 20:24
mav.northwind25-Apr-05 20:24 
GeneralExport generated data to database. Pin
StoneWolfSoft25-Apr-05 5:22
StoneWolfSoft25-Apr-05 5:22 
Currently I'm creating a c# app to extract data from a vendor specific text file and export it to an Access database.

OK, so I've created a DataSet with a DataTable in it, extracted the data from the file into the DataTable and now I'm trying to squirt this data into a table in the target database using a DataAdapter.

The target table has one key field defined within it.

If the table is empty all works as it should do, however if there is data already in the table the DataAdapter attempts to use an Insert command to update the data (when I think it should be issuing an Update command) and throws an error saying it would create duplicate keys.

And so the question.....
What method does the DataAdapter use to determine if the record being updated is new or changed? Does it look only at the key fields? or all fields?

Yours Despairingly
Simon
GeneralObject reference not set to an instance of an object. On Marshal.PtrToStructure Method Pin
mrxero25-Apr-05 4:44
mrxero25-Apr-05 4:44 
GeneralSaving socket connection information Pin
CheckDude25-Apr-05 4:27
CheckDude25-Apr-05 4:27 
GeneralRe: Saving socket connection information Pin
S. Senthil Kumar26-Apr-05 2:31
S. Senthil Kumar26-Apr-05 2:31 
GeneralRe: Saving socket connection information Pin
CheckDude10-May-05 5:59
CheckDude10-May-05 5:59 
GeneralGet Button Pin
The underdog25-Apr-05 2:51
The underdog25-Apr-05 2:51 
GeneralRe: Get Button Pin
Ashok Dhamija25-Apr-05 3:29
Ashok Dhamija25-Apr-05 3:29 
GeneralRe: Get Button Pin
Le centriste25-Apr-05 3:46
Le centriste25-Apr-05 3:46 
GeneralRe: Get Button Pin
mav.northwind25-Apr-05 3:52
mav.northwind25-Apr-05 3:52 
GeneralRe: Get Button Pin
Luis Alonso Ramos25-Apr-05 5:49
Luis Alonso Ramos25-Apr-05 5:49 
GeneralDiferences between null,close and dispose Pin
Enishi25-Apr-05 1:48
Enishi25-Apr-05 1:48 
GeneralRe: Diferences between null,close and dispose Pin
S. Senthil Kumar25-Apr-05 3:32
S. Senthil Kumar25-Apr-05 3:32 
GeneralRe: Diferences between null,close and dispose Pin
turbochimp25-Apr-05 5:54
turbochimp25-Apr-05 5:54 
GeneralRe: Diferences between null,close and dispose Pin
S. Senthil Kumar25-Apr-05 19:22
S. Senthil Kumar25-Apr-05 19:22 
GeneralRe: Diferences between null,close and dispose Pin
mav.northwind25-Apr-05 20:27
mav.northwind25-Apr-05 20:27 
GeneralRe: Diferences between null,close and dispose Pin
S. Senthil Kumar26-Apr-05 0:33
S. Senthil Kumar26-Apr-05 0:33 
GeneralRe: Diferences between null,close and dispose Pin
turbochimp26-Apr-05 5:10
turbochimp26-Apr-05 5:10 
GeneralRe: Diferences between null,close and dispose Pin
S. Senthil Kumar26-Apr-05 19:17
S. Senthil Kumar26-Apr-05 19:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.