using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connection))
{
bulkCopy.DestinationTableName = "encasement";
DataTable dt = new DataTable();
dt.Columns.Add("work_order", typeof(string));
dt.Columns.Add("outer_box_code", typeof(string));
dt.Columns.Add("inner_box_code", typeof(string));
dt.Columns.Add("Product_code", typeof(string));
dt.Columns.Add("Gross_weight", typeof(string));
dt.Columns.Add("Net_weight", typeof(string));
dt.Columns.Add("Commodity_code", typeof(string));
dt.Columns.Add("Product_category", typeof(string));
dt.Columns.Add("product_sn", typeof(string));
dt.Columns.Add("Create_name", typeof(string));
dt.Columns.Add("create_time", typeof(DateTime));
dt.Columns.Add("factory_name", typeof(string));
dt.Columns.Add("Product_name", typeof(string));
dt.Columns.Add("weixiang", typeof(string));
foreach (var rowModel in dataRows)
{
DataRow row = dt.NewRow();
row["work_order"] = rowModel.work_order;
row["outer_box_code"] = rowModel.outer_box_code;
row["inner_box_code"] = rowModel.inner_box_code;
row["Product_code"] = rowModel.Product_code;
row["Gross_weight"] = rowModel.Gross_weight;
row["Net_weight"] = rowModel.Net_weight;
row["Commodity_code"] = rowModel.Commodity_code;
row["Product_category"] = rowModel.Product_category;
row["product_sn"] = rowModel.product_sn;
row["Create_name"] = rowModel.Create_name;
row["create_time"] = rowModel.create_time;
row["factory_name"] = rowModel.factory_name;
row["Product_name"] = rowModel.Product_name;
row["weixiang"] = rowModel.weixiang;
dt.Rows.Add(row);
}
// 写入服务器
bulkCopy.WriteToServer(dt);
}
public class EncasementModel
{
public string outer_box_code { get; set; }
public string inner_box_code { get; set; }
public string work_order { get; set; }
public string product_sn { get; set; }
public string Create_name { get; set; }
public DateTime create_time { get; set; }
public string Commodity_code { get; set; }
public string Product_code { get; set; }
public string Net_weight { get; set; }
public string Gross_weight { get; set; }
public string Product_category { get; set; }
public string Product_name { get; set; }
public string factory_name { get; set; }
public string weixiang { get; set; }
}
提交的时间格式为2024-03-14 11:37:56.3756000,数据库时间的类型为datetime2(7),但是一直提示 The given value of type String from the data source cannot be converted to type datetime2 of the specified target column.是什么原因呢