> I need to get xml documents into sql server. I am using asp.net 2.0
> (c#). I have been advised to pull the xml document into a dataset and
> then push this to sql server. Can this be done without mapping the
> individual fields? If so can someone point me to an article that
> shows
> how to do this.

> If the above could be used I assume there would need to be code that
> automatically creates the tables in sql server from the dataset on
> the
> first run, then on other runs would insert from the dataset into sql
> server.

> As the xml document I will be receiving has a large number of fields,
> my aim is to bring the document into sql server without having to map
> the individual fields.

> Thanks for any help
> Danny

> if you store the xml docs as xml blobs in a single text column  then
> you don't need datasets or table mappings. You can programmatically
> retreive the blob by selecting the column you stored the doc in.

> --- Danny <dannygri...@gmail.com> wrote:

> > I need to get xml documents into sql server. I am using asp.net 2.0
> > (c#). I have been advised to pull the xml document into a dataset and
> > then push this to sql server. Can this be done without mapping the
> > individual fields? If so can someone point me to an article that
> > shows
> > how to do this.

> > If the above could be used I assume there would need to be code that
> > automatically creates the tables in sql server from the dataset on
> > the
> > first run, then on other runs would insert from the dataset into sql
> > server.

> > As the xml document I will be receiving has a large number of fields,
> > my aim is to bring the document into sql server without having to map
> > the individual fields.

> > Thanks for any help
> > Danny

> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com