Hi Shaun

I've got it all working thanks.

The problem is there's so many ways to do the same thing and I don't know which is the most efficient.

For instance to delete...

Shaun Hi,

I'm writting a windows application to add new records to some tables.

I thought that you had to run dataAdapter.Fill

(which I assumed implies a Select statment)

to at least get the...

I'm using the Data Adapter Configuration Wizard.

The delete is from the DeleteCommand of the dataAdapter.Update.

How do I know the order of events in the dataAdapter.Update command?

Is this the best way to prepare a dataTable for an Insert operation, or are there alternative methods.?

In my case what I'm doing is reading thru an ascii text file, extracting...

Thanks for the reply

I guess that's the same as

Select * from tblMyTable Where 1 = 2;

that I found on my wanderings after posting here.

You say

"This will give you the right...

Thanks very much.

Everybodies got to be a newbi once

You say

"If a PRIMARY KEY constraint is defined on more than one column, values may be duplicated within one column, but each combination of values from all the columns...