string connectionString = new PublicDBHelper().GetCon(System.Configuration.ConfigurationManager.AppSettings["constring"].ToString());

using (SqlConnection destinationConnection = new SqlConnection(connectionString))

{

destinationConnection.Open();

using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.CheckConstraints | SqlBulkCopyOptions.FireTriggers))

{

try

{

bulkCopy.DestinationTableName = "A";//要插入的表的表明

bulkCopy.ColumnMappings.Add("billno", "billno");//映射字段名 DataTable列名 ,数据库 对应的列名

bulkCopy.WriteToServer(tblDataDetails);

}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

}

finally

{

// Close the SqlDataReader. The SqlBulkCopy

// object is automatically closed at the end

// of the using block.

}

}

}

实际使用过了,效果不太太好太明显

转自http://www.cnblogs.com/shikyoh/archive/2011/07/01/2095633.html