当我插入一笔数据成功后;自动执行更新另外一个表格的动作;如下代码;更新不起作用
string sql = "insert into draw(ID,Line,DateTime,DUser,Quantity,category,re,action)values(@ID,@Line,CONVERT(varchar(100),GETDATE()),@DUser,@Quantity,@category,@re,@action)";
try
{
SqlCommand cmd = new SqlCommand(sql, DBHelper.con);
DBHelper.con.Open();
cmd.Parameters.AddWithValue("@ID", this.txtid.Text.Trim());
cmd.Parameters.AddWithValue("@line", this.txtLine.Text.Trim());
cmd.Parameters.AddWithValue("@DUser", this.txtUser.Text.Trim());
cmd.Parameters.AddWithValue("@Quantity", this.txtqty.Text.Trim());
cmd.Parameters.AddWithValue("@category", this.cbocategory.Text.Trim());
cmd.Parameters.AddWithValue("@re", this.txtre.Text);
cmd.Parameters.AddWithValue("@action", this.rdodraw.Text.Trim());
cmd.CommandText = sql;
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
string sql1 = "Update date set status='在线' where id = @ID";
cmd.Parameters.AddWithValue("@ID", this.txtid.Text.Trim());
DBHelper.con.Open();
SqlCommand cmd1 = new SqlCommand(sql1, DBHelper.con);
int result1 = cmd.ExecuteNonQuery();
if (result1 == 1)
{
MessageBox.Show("添加成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("添加失败", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
string sql = "insert into draw(ID,Line,DateTime,DUser,Quantity,category,re,action)values(@ID,@Line,CONVERT(varchar(100),GETDATE()),@DUser,@Quantity,@category,@re,@action)";
try
{
SqlCommand cmd = new SqlCommand(sql, DBHelper.con);
DBHelper.con.Open();
cmd.Parameters.AddWithValue("@ID", this.txtid.Text.Trim());
cmd.Parameters.AddWithValue("@line", this.txtLine.Text.Trim());
cmd.Parameters.AddWithValue("@DUser", this.txtUser.Text.Trim());
cmd.Parameters.AddWithValue("@Quantity", this.txtqty.Text.Trim());
cmd.Parameters.AddWithValue("@category", this.cbocategory.Text.Trim());
cmd.Parameters.AddWithValue("@re", this.txtre.Text);
cmd.Parameters.AddWithValue("@action", this.rdodraw.Text.Trim());
cmd.CommandText = sql;
int result = cmd.ExecuteNonQuery();
if (result == 1)
{
string sql1 = "Update date set status='在线' where id = @ID";
cmd.Parameters.AddWithValue("@ID", this.txtid.Text.Trim());
DBHelper.con.Open();
SqlCommand cmd1 = new SqlCommand(sql1, DBHelper.con);
int result1 = cmd.ExecuteNonQuery();
if (result1 == 1)
{
MessageBox.Show("添加成功", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("添加失败", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货