2 data adapters, 1 dataset

[J]

I want to read a .csv file into a dataset using an OleDbDataAdapter, then
update a SQL table from these rows. Is there any easier or more efficient
way to do this instead of spinning through the dataset rows and firing off
an INSERT for each of these rows? It seems to me that after I'd filled the
dataset using the OleDbDataAdapter, I could create an SqlDataAdapter for use
with this same dataset for updating. Seems as if I'd also need to map the
fields in the dataset to the Sql table. This all seems possible but I'm not
getting there with the code. Any help is appreciated.

 

[sloan]

Ship the dataset.GetXml() off to Sql Server...and allow it to process it.

http://support.microsoft.com/kb/315968

Note, Sql Server 2005 has a different method than OPENXML you might
investigate.

 

[bruce barker]

yes, thats what dataadapters where designed for and are seperate from
datasets.


-- bruce (sqlwork.com)