Class1 c1 = new Class1();
public void pldr1(DataTable dt1,string s1)
{//将dt1导入到指定表,s1为要目标表名,dt1为要导入的数据
if (c1.sqlcon1.State.ToString().Trim() == "Open")
{
}
else
{
c1.sqlcon1.Open();
}
try
{
using (SqlBulkCopy sqlBC = new SqlBulkCopy(c1.sqlcon1))
{
sqlBC.BulkCopyTimeout = 300;
sqlBC.DestinationTableName = s1;
sqlBC.ColumnMappings.Add("dev_id", "dev_id");
sqlBC.ColumnMappings.Add("sj", "sj");
sqlBC.ColumnMappings.Add("time1", "time1");
sqlBC.ColumnMappings.Add("y1", "y1");
sqlBC.ColumnMappings.Add("workNumber", "workNumber");
sqlBC.WriteToServer(dt1);
}
}
catch (Exception e1)
{
string s2 = e1.Message;
}
if (c1.sqlcon1.State.ToString().Trim() == "Open")
{
c1.sqlcon1.Close();
}
else
{
}
}