这是我的代码:
protected void SendToServer_Click(object sender, EventArgs e)
{
DataTable Values = Session["valuesdt"] as DataTable;
if (Values.Rows.Count > 0)
{
//Fix up default values
for (int i = 0; i < Values.Rows.Count; i++)
{
Values.Rows[i]["Mobile1"] = Values.Rows[i]["Mobile1"].ToString() == "" ? 0 : double.Parse(Values.Rows[i]["Mobile1"].ToString());
Values.Rows[i]["Mobile2"] = Values.Rows[i]["Mobile2"].ToString() == "" ? 0 : double.Parse(Values.Rows[i]["Mobile2"].ToString());
Values.Rows[i]["Tel"] = Values.Rows[i]["Tel"].ToString() == "" ? 0 : double.Parse(Values.Rows[i]["Tel"].ToString());
Values.Rows[i]["Category"] = Values.Rows[i]["Category"].ToString();
}
DataTable dv = Values.DefaultView.ToTable(true, "Mobile1", "Mobile2", "Tel", "Category");
BulckCopyDataTable(dv, "client", 1000);
}
}
public void BulckCopyDataTable(DataTable dt,string DestinationTable,int batchSize)
{
connection.Open();
using (SqlBulkCopy copy = new SqlBulkCopy(connection))
{
copy.BatchSize = batchSize;
copy.DestinationTableName = DestinationTable;
copy.WriteToServer(dt);
connection.Close();
}
}
我不知道为什么数据库中会抛出此错误:
Mobile1 bigint, Mobile2 bigint, Tel bigint, Category nvarchar(MAX)
我在中找到了答案这个 bytes.com 线程 http://bytes.com/topic/sql-server/answers/808539-sqlbulkcopy-writetoserver-blowing-up-tables-identitycolumns.
您所要做的就是使用 SqlBulkCopyColumnMapping 将源表的列映射到目标表。
bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(0, 1));
bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(1, 2));
bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(2, 3));
bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(3, 6)); //look here, index is different
bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(4, 8)); //and again
bulkCopy.ColumnMappings.Add(new SqlBulkCopyColumnMapping(5, 9));
我也找到了同样的解决方案here https://stackoverflow.com/questions/11919593/sqlbulkcopy-the-given-value-of-type-datetime-from-the-data-source-cannot-be-conv在找到上述内容之前,但就我而言,源代码中缺少一些字段。尽管它引用了字段的实际索引/顺序,但字段的顺序正确。如果我没有缺少的字段,它就会起作用。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)