Data adapters and datasets

[R]

Hi, I'm stuck, again...
I have, finally, managed to fill a dataadapter and linked a dataset to a
combo box, but, and maybe this is the problem, each time I run my code I
fill the dataset with new records. Is there a way to empty the data adapter
or shoult I rewrite my code?

Ronny

 

[R]

Hi, again, I got it, I was thinking wrong, again, I should ofcourse clear
the dataset...

Ronny

 

[Cor]

Hi R,

Good that you found it and told us that

Helps others not to search to help you.

I wished everybody did that.

Cor

 

[R]

Isn't what they cal "Netiquette"? ;-)

Ronny

 

[Jay B. Harlow [MVP - Outlook]]

Ronny,
In addition to Clearing the DataSet, you can add a PrimaryKey to your
DataSet, then when you fill it, rows with like keys will be replaced, of
course rows that were deleted in the database will still be in the dataset
if you use the PrimaryKey method...

If you don't have it, you may want to get David Sceppa's "Microsoft
ADO.NET - Core Reference" from MS Press as it is a good tutorial on ADO.NET
plus a good desk reference once you know ADO.NET!

Hope this helps
Jay