By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,129 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,129 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 18 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

"Sky" <ne********@nospam.xact-solutions.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
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

Nov 18 '05 #2

P: n/a
Sky
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
"Madan Nayak" <ma***@ubicsindia.com> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
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

"Sky" <ne********@nospam.xact-solutions.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
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


Nov 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.