111,092
社区成员




SqlConnection conn = new SqlConnection(t_订单TableAdapter.Connection.ConnectionString);
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
t_订单TableAdapter.Connection = conn;
t_订单TableAdapter.Transaction = trans;
t_订单明细TableAdapter.Connection = conn;
t_订单明细TableAdapter.Transaction = trans;
try
{
t_订单TableAdapter.Update(sq_tbsDataSet.t_订单);
t_订单明细TableAdapter.Update(sq_tbsDataSet.t_订单明细);
}
catch (Exception ex)
{
trans.Rollback();
conn.Close();
MessageBox.Show("记录时出现错误", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}
trans.Commit();
conn.Close();
MessageBox.Show("记录已经成功保存", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return true;