|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DataSet Bulk Load QuestionI 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. 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. -- Show quoteWilliam (Bill) Vaughn President and Founder Beta V Corporation Redmond, WA (425) 556-9205 Microsoft MVP, Author, Mentor Microsoft MVP "xenophon" <xenophon@online.nospam> wrote in message news:hhn022l972kbpnpfg022j1st3704edvvmn@4ax.com... > 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.  |
|||||||||||||||||||||||
Other interesting topics