Question

combobox 更新

private void button2_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(comboBox4.Text))
{
MessageBox.Show("不能为空", "提示");
return;
}
string strsql = "begin transaction declare @R_num int; select @R_num=R_num from 入库流水账 where G_number=" + comboBox5.Text + "and R_number=" + comboBox4.Text + ";delete from 入库流水账 where R_number =" + comboBox4.Text + "and G_number=";
strsql += comboBox5.Text + ";update 库存帐 set G_store=G_store-@R_num where G_number="+comboBox5.Text+"commit transaction;";
ExeDMLSQl(strsql);
ExeQuerySql(ShowAllData);
comboBox4.Items.Clear();
conn.Close();
conn = new SqlConnection(ConnectString);
conn.Open();
SqlCommand cmd = new SqlCommand("select * from 入库流水账", conn);
SqlDataReader rea = null;
rea = cmd.ExecuteReader();
while (rea.Read())
{
comboBox4.Items.Add(rea["R_number"]);
}
rea.Close();

}
点击button之后，连同combobox也更新，可操作之后，并没有更新

Answer 1

知道了吧。end