如何在不定义目标表的情况下使用 BulkCopy

发布于 2024-12-27 14:08:35 字数 632 浏览 0 评论 0原文

所有，

我有以下 BulkCopy 操作：

// Convert the FlexGrid to a DataTable.
DataTable currData = (DataTable)c1ErrFlexGrid.DataSource;

// Insert the data into the database.
SqlBulkCopy SqlBulkIns = new SqlBulkCopy(strConnString, SqlBulkCopyOptions.Default);
SqlBulkIns.BatchSize = 5000;
SqlBulkIns.DestinationTableName = String.Format("dbo.{0}", strTableName);
SqlBulkIns.WriteToServer(currData);

其中 strConnectionString 是定义的有效连接字符串。过去，当表 strTableName 存在并且定义了字段时，这种方法效果很好。我现在希望对运行时定义的 DataTable 执行此 BulkCopy 操作；即无需在SQL中预先定义表结构。这可能吗？如果是这样，怎么办？

感谢您抽出时间。

原文

All,

I have the following BulkCopy operation:

// Convert the FlexGrid to a DataTable.
DataTable currData = (DataTable)c1ErrFlexGrid.DataSource;

// Insert the data into the database.
SqlBulkCopy SqlBulkIns = new SqlBulkCopy(strConnString, SqlBulkCopyOptions.Default);
SqlBulkIns.BatchSize = 5000;
SqlBulkIns.DestinationTableName = String.Format("dbo.{0}", strTableName);
SqlBulkIns.WriteToServer(currData);

where strConnectionString is a defined and valid connection string. This has worked fine in the past when the table strTableName exists and the fields are defined. I now wish to perform this BulkCopy operation on a DataTable that is defined at run-time; that is, without predefining the table structure in SQL. Is this possible? If so, how?

Thanks for your time.

分享到QQ

分享到微博