c# Datatable批量写入数据库

DataTable dTable = new DataTable(“Table_RowData”);
dTable.Columns.Add(“SerialNo”, typeof(String));
dTable.Columns.Add(“DUT”, typeof(String));
dTable.Columns.Add(“HardBinNo”, typeof(String));
dTable.Columns.Add(“SWBin”, typeof(String));
dTable.Columns.Add(“DESCRIPTION”, typeof(String));
dTable.Columns.Add(“CatName”, typeof(String));
dTable.Columns.Add(“RePorbingFlag”, typeof(String));
dTable.Columns.Add(“TouchNumber”, typeof(String));
dTable.Columns.Add(“ProductName”, typeof(String));
dTable.Columns.Add(“TSMCLotID”, typeof(String));
dTable.Columns.Add(“INSERTTIME”, typeof(DateTime));
dTable.Columns.Add(“StartTime”, typeof(String));
dTable.Rows.Add(SerialNo, DUT, HardBinNo, SWBin,DESCRIPTION, CatName, RePorbingFlag, TouchNumber, ProductName, TSMCLotID, DateTime.Now, StartTime);

SqlConnection conn = new SqlConnection(“server=”+IP+";database="+databasename+";uid="+username+";pwd="+password+");
conn.Open();
SqlBulkCopy bulkCopy = new SqlBulkCopy(conn);
bulkCopy.DestinationTableName = “TSMC_FT1_DATA_ROWDATA”;//要插入的表的表名
bulkCopy.BatchSize = dTable.Rows.Count;
bulkCopy.ColumnMappings.Add(“SerialNo”, “SerialNo”);//映射字段名 DataTable列名 ,数据库 对应的列名
bulkCopy.ColumnMappings.Add(“DUT”, “DUT”);
bulkCopy.ColumnMappings.Add(“HardBinNo”, “HardBinNo”);
bulkCopy.ColumnMappings.Add(“SWBin”, “SWBin”);
bulkCopy.ColumnMappings.Add(“DESCRIPTION”, “DESCRIPTION”);
bulkCopy.ColumnMappings.Add(“CatName”, “CatName”);
bulkCopy.ColumnMappings.Add(“RePorbingFlag”, “RePorbingFlag”);
bulkCopy.ColumnMappings.Add(“TouchNumber”, “TouchNumber”);
bulkCopy.ColumnMappings.Add(“ProductName”, “ProductName”);
bulkCopy.ColumnMappings.Add(“TSMCLotID”, “TSMCLotID”);
bulkCopy.ColumnMappings.Add(“INSERTTIME”, “INSERTTIME”);
bulkCopy.ColumnMappings.Add(“StartTime”, “StartTime”);
bulkCopy.WriteToServer(dTable);
conn.Close();

上一篇:JS数据类型判断


下一篇:JavaScript基础(typeof以及类型转换)