- SQLConnection是SQL专用的
事务的提交与回滚
//读取数据库连接字符串
string connstr = "server=;database=;uid=;pwd=";
using (SqlConnection conn = new SqlConnection(connstr))
{
conn.Open();
//创建一个事务
SqlTransaction st = conn.BeginTransaction();
using (SqlCommand cmd = new SqlCommand(sqlstr, conn))
{
cmd.Transaction = st;
try
{
cmd.ExecuteNonQuery();
//提交
st.Commit();
}
catch
{
//回滚
st.Rollback();
}
}
}
批量加载数据库,使用SqlBulkCopy类,SqlBulkCopy类官方API
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(conn))
{
bulkCopy