DataSet Bulk Load Question

[xenophon]

I have a DataSet with column schemata that matches a MSSQL
2000 table. I want to bulk insert all of the data (4000 rows) into the
database without creating a SQL-Insert statement. The data is already
validated and scrubbed, and speed is not all that important. Is there
a way to use SqlXml from C# to pump the data to the server (SQLXML is
not installed on the database server).

Thanks.

 

[William \(Bill\) Vaughn]

The 2.0 Framework's SqlClient data provider exposes SqlBulkCopy. If you're
targeting SS databases, this is the way to go. Do not use XML unless you are
being paid by the hour to watch the data crawl into your server.

--
William (Bill) Vaughn
President and Founder Beta V Corporation
Redmond, WA
(425) 556-9205
Microsoft MVP, Author, Mentor
Microsoft MVP