What is the quickest way to get an xml based dataset to add entries to SQL Server?

[MurdockSE]

Because there is no 'datareader' involved, what is the most efficient
way to get an XML based dataset to be added to an SQL server dataset? I
would hate to have to create a new SQL connection and iterate through
making "executenonquer y" for each row in the dataset. That seems
horribly in-efficient. I know of no other way to get an xml based
dataset to push data to the database though. Any pointers?

Thanks for any pointers,
Peter Robbins
Freelance Programmer C#/PHP

[John Saunders]

"MurdockSE" <mu*****@nc.rr. comwrote in message
news:11******** **************@ h48g2000cwc.goo glegroups.com.. .

Because there is no 'datareader' involved, what is the most efficient
way to get an XML based dataset to be added to an SQL server dataset? I
would hate to have to create a new SQL connection and iterate through
making "executenonquer y" for each row in the dataset. That seems
horribly in-efficient. I know of no other way to get an xml based
dataset to push data to the database though. Any pointers?

Use a DataAdapter and do an Update. Just make sure all the rows youi want
added are marked as being in Add state.

John

[MurdockSE]

Excuse my ADO.NET naivite (newbie alert*) but how do I iterate the
existing ds and set all of the rows to ADD?

For example:

DataSet ds = new DataSet("MyReco rds");
ds.ReadXml(xmlf ilename);

And the seperate SQL creations would be similar to this:

using System.Data.Sql Client;
using System.Data;

string strDBConnection = "server=(local) ;database=Datab aseName;user
id=UserName;pas sword=Pwd;conne ction reset=false;con nection
lifetime=5;Trus ted_Connection= Yes;"
SqlConnection dbConnection;
dbConnection = new SqlConnection(s trDBConnection) ;

string strSelectSql = "Select * from
[DatabaseName].[OwnerName].[TableName] order by FieldName";

//Open the connection
dbConnection.Op en();

//Create a command
SqlCommand selectSqlComman d = new
SqlCommand(strS electSql,dbConn ection);
SqlDataAdapter sqlData = new SqlDataAdapter( selectSqlComman d);
DataSet dsSelectData = new DataSet();
sqlData.Fill(ds SelectData);

How do I get the ds into the sqlData adapter set to ADD each row?
Peter Robbins

[MurdockSE]

I got the answer/s I was looking for here:

http://groups.google.com/group/micro...9226fef?hl=en&

Thanks again. You basically stated the same thing. My naive self just
needed a little extra push on the particulars. Thanks.

Peter Robbins