Re: How to insert data from strongly typed dataset into database (jbx01)
- From: jbrag@xxxxxxxxxxx
- Date: 22 Sep 2005 21:42:57 -0700
Hi Bill, I thank you very much for help and quick response, appreciate
it!
Please use halbrag@xxxxxxxx for reply next time - will reach me
directly.
I realized I should be more precise. So here it goes. I had an XSD
schema which I used to generate a database in my MS SQL Server 2000 (I
used a freebee tool that accepts XSD file and drops/recreates the
database based on the XSD schema, xsd2db.exe). I'm receiving XML files
(actually they are XML strings passed to my URL, using GET), and my
intent is to easy-way store it in my database. So using Microsoft
xsd.exe I generated a strongly typed DataSet class, which added it to
my website application .NET C# project. Next, I populate a strongly
typed dataset instance from the XMLDocument instance created off an XML
string. So there should be a full schema match between the XML stream,
the dataset and the database.
Now, the question is: having the dataset populated this way how do I go
about inserting the (XML) data into my database, in a possible painless
way, letting the technology do most of the work.
A critical point to make: I may need to change XSD multiple times, or
re-apply the solution to many applications, each with a different XSD,
so writing as little code as possible is critical in the solution.
Not to sound too negative, but what looked like a Microsoft promise
with an introduction of a concept of Strongly Typed Datasets is bit
underdeveloped. One would expect a simple method Save or Insert.
Jacek B.
.
- References:
- Prev by Date: How can we detach /attach database in program?
- Next by Date: Re: stored Procedure question
- Previous by thread: Re: How to insert data from strongly typed dataset into database (jbx01)
- Next by thread: Re: How to insert data from strongly typed dataset into database (jbx01)
- Index(es):
Relevant Pages
|
