Data adapters and datasets

  • Thread starter Thread starter R
  • Start date Start date
R

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
 
Hi, again, I got it, I was thinking wrong, again, I should ofcourse clear
the dataset...

Ronny
 
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
 
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
 
Back
Top