Re: XML->Dataset->Database
- From: "Balasubramanian Ramanathan" <rbsubramanian@xxxxxxxxxxx>
- Date: Wed, 14 Jun 2006 15:30:38 +0100
Why can't you use bulk import and export feature of sqlserver. you can
import export xml documents also..
"David Harris" <DavidHarris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4BE8FD35-11EF-41AD-932E-476AFBE22841@xxxxxxxxxxxxxxxx
I am developing a type of data warehouse. Basically, we have 20 client
survey
machines that are each separated from the server by space and lack of
network. Yet both need to speak to each other such that the clients know
the
latest configuration information and the server contains completed survey
data from the clients. Currently I'm accomplishing this by using a few
special database tables to control the flow of information, and using XML
serialized datasets on both ends and a USB drive to move them back and
forth.
The design seems to work.
However, some of these tables have 50+ columns and creating manual insert
statements has gotten absurd. For example, on the server I generate a
dataset
based on what needs to be sent to the client, it works fine. I then read
in
that XML into a dataset on the client. So now, how do I best get that data
into the SQL database on the client side? The only way I've found to do it
is
to create a DataAdapter and insert each row at a time, after setting up
all
the commands, parameters, and filling out each row. This is absurd, it
winds
up being hundreds of lines. I really want something like this:
Dataset ds;
ds.connection = my connection;
ds.update();
After all, the schema is exactly the same on both ends! So, I don't really
expect the above, but there has to be an easier way than reinventing the
wheel. Basically, I have a dataset full of data that matches the database
I
want to get it inside, only it wasn't taken from that database so it's not
just a simple sqladapter.update() call.
Any ideas? Thanks in advance.
.
- Prev by Date: Re: Visual Studio 2003 Setup and Deployment Package
- Next by Date: Re: .NET poor threading architecture?
- Previous by thread: ListBox
- Next by thread: Re: XML->Dataset->Database
- Index(es):
Relevant Pages
|
