Looking for a Better Way

[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

 

[Ken Tucker [MVP]]

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

 

[Wayne Wengert]

Will do - thanks for the pointer.

Wayne