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
2  1967 
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Darren |
last post by:
Hi wondering if anyone can help.
What i'm trying to do is get a company from a MSSQL database with the
COMPANYNO which is a 'uniqueidentifier'. Then with this COMPANYNO I want to
reference it to...
|
by: Steve Jorgensen |
last post by:
I keep having problems in which ADO disconnected recordset work under some
circumstances, but lose all their data at other times, having no rows or
fields, though the recordset object still exists....
|
by: Andrew |
last post by:
I'm a long time VB6/ADO and Java developer new to ADO.NET. I'm trying
to decide on best practices and I'd appreciate any assistance. I have
one specific question and another more general...
|
by: Steve Le Monnier |
last post by:
The ADO.NET DataSet is idea for application development, especially if you
need disconnected data. DataReader objects are great in the connected
environment but are forward only. What do you do...
|
by: gibster |
last post by:
Hi
I'm looking for some help comparing 2 datasets,
each dataset has 2 datatables;
the first table's rows consist of
text
status (1 or 0)
GUID
|
by: Rich |
last post by:
Hello,
I have to read and write around one million records from
an external data source to Sql Server2k every night.
That's a lot of I/O. I am using VB6 for this (takes
hours). I am...
|
by: garethdjames |
last post by:
For scalability we wish to use disconnected DataSets and hold them in
the application cache.
This means that multiple concurrent users will be reading the data (its
read only)
The DataSet is...
|
by: ist |
last post by:
Hi,
I am trying to create a Session-Wide, Disconnected, Updatable
DataTable (or DataSet) object and use it through an ASP.NET GridView.
The scenario is this:
1. When the page is first loaded,...
|
by: Peter |
last post by:
Hi!
I am frustrated! I spent a lot of time designing a custom dataset schema
(XSD file) using the Dataset designer. In my main form I had created an
instance of a typed dataset using that...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
