*table为更新表名或插入数据表
SqlConnection conn = new SqlConnection(sqlConStr);
SqlCommand comm = conn.CreateCommand();comm.CommandTimeout = 500;
comm.CommandType = CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter(comm);
//comm.CommandText = "select * from TestDB";
SqlCommandBuilder commandBulider = new SqlCommandBuilder(adapter);
commandBulider.ConflictOption = ConflictOption.OverwriteChanges;
try
{
conn.Open();
//设置批量更新的每次处理条数
adapter.UpdateBatchSize = 5000;
adapter.SelectCommand.Transaction = conn.BeginTransaction();/开始事务
adapter.SelectCommand.CommandText = " select * from " + table.TableName;
adapter.Update(table);
adapter.SelectCommand.Transaction.Commit();/提交事务
}
catch (Exception ex)
{
if (adapter.SelectCommand != null && adapter.SelectCommand.Transaction != null)
{
adapter.SelectCommand.Transaction.Rollback();
}
throw ex;
}
finally
{
conn.Close();
conn.Dispose();
}