/// <summary>
/// 将DataTable数据集导入SQL数据库.5中
/// 注意:DataTable中的列头和数据库总表的列名要一致
/// </summary>
/// <param name="dt">需要存入数据库的datatable</param>/// <param name="string">数据库表名</param>
public static bool BulkToDB(DataTable dt, string tablemark)
{
string connstring = ""//连接字符串
using (SqlConnection sqlConn = new SqlConnection(connstring))
{
SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConn);
bulkCopy.DestinationTableName = tablemark;
bulkCopy.BatchSize = dt.Rows.Count;
try
{
sqlConn.Open();
if (dt != null && dt.Rows.Count != 0)
bulkCopy.WriteToServer(dt);
}
catch (Exception ex)
{
return false;
}
finally
{
sqlConn.Close();
if (bulkCopy != null)
bulkCopy.Close();
}
return true;
};
}