Looking for a Better Way

  • Thread starter Thread starter Wayne Wengert
  • Start date Start date
W

Wayne Wengert

I have an in-memory table I built from some XML input. There is no dataset.
The table acts as the datasource for a datagrid. I now find that I need to
write that entire table to a database (SQL Server). I know I can build the
DB table using CREATE TABLE and then populate it by iterating through the
in-memory table and using Insert Into statements for each row but I thought
I remembered seeing a way to just write the whole table but I can't find any
information on exactly how to do that?

Any ideas?

Wayne
 
Hi,

Take a look at OPENXML

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_openxml_1cx8.asp

Ken
--------------------------
I have an in-memory table I built from some XML input. There is no dataset.
The table acts as the datasource for a datagrid. I now find that I need to
write that entire table to a database (SQL Server). I know I can build the
DB table using CREATE TABLE and then populate it by iterating through the
in-memory table and using Insert Into statements for each row but I thought
I remembered seeing a way to just write the whole table but I can't find any
information on exactly how to do that?

Any ideas?

Wayne
 
Back
Top