Q: Disconnected DataSets - automatic Add/Remove but with Guid Key instead of AutoIncrement int?

  • Thread starter Thread starter Sky
  • Start date Start date
S

Sky

Hello,
The books on C# I have read talk of using the DataSets in disconnected mode,
and Adding/Removing/Updating records from it, and letting it handle all the
updating on the Database in one batch finale...

But the examples were all based on using auto-increment columns.

Lately I've been backing away from Auto-Increment columns to move to
'uniqueidentifier' guid columns instead for my Key columns -- to allow for
better synching arch. with several disconnected PocketPC's in the future...
(So I've been told...)

Question:
How does one get to use this disconnected abilities of the DataSet if using
Guid's --
AND where I need to provide a new Guid() programmatically at post time if it
is a new record
(why? Because on SqlServer there is a command to do so -- but when porting
to MySQL where they don't have a built in function to generate a Guid if
none provided, you have to provide the value before posting...)

Voila. Convoluted question -- I apologize -- but any info, code sample,
anything that would get me to see the light on this one, would be FANTASTIC!
Sky
 
Hi Sky...

you can use the dataset with the data relations without any attribute being
decared as auto increment.

Do what ever manipulation you want an d finally update on the adapter...

http://www.codeproject.com/aspnet/
you can see some dataset code here..

Bye
 
Dear Madan:
The place you dumped me was sort of like a shopping mall...where to start?!
Did you have any specific example that you think relevant to the question I
posted?

Thanks so much,
Sky
 
Back
Top