后续的组合框没有加载我所做的更改

Question

我有一个代码，它将从mysql数据库中填充组合框。组合框将显示状态='YES'的所有组织。但是，如果我将状态从NO更改为YES，则后续组合框不会加载它。

这里是我的组合框代码：

string sql = "SELECT orgAbbrev FROM courseandorg WHERE status = 'YES'"; 
      conn.Open(); 
      MySqlCommand cmd = new MySqlCommand(sql, conn); 
      MySqlDataReader rd = cmd.ExecuteReader(); 

       while (rd.Read()) 
      { 

       cboOrg.Items.Add(rd["orgAbbrev"].ToString()); 
       cboOrg.ValueMember = rd["orgAbbrev"].ToString(); 
       cboOrg.DisplayMember = rd["orgAbbrev"].ToString(); 

      } 
      conn.Close(); 

这里的按钮的代码，我会更改状态：

 try 
     { 
      conn.Open(); 
      string sql1 = "UPDATE courseandorg SET status = @status WHERE connID = @connID"; 
      MySqlCommand cmd1 = new MySqlCommand(sql1, conn); 

      cmd1.Parameters.AddWithValue("@connID", textBox1.Text); 
      cmd1.Parameters.AddWithValue("@status", comboBox1.Text); 

      cmd1.ExecuteNonQuery(); 
      Showlist(); //This is my funtion in my datagridview 

     } 
     catch (Exception ex) 
     { 
      MessageBox.Show(ex.Message); 
     } 
     conn.Close(); 

Answer 1

更改代码这样

节一个

private void your_func() 
    { 
     string sql = "SELECT orgAbbrev FROM courseandorg WHERE status = 'YES'"; 
     conn.Open(); 
     MySqlCommand cmd = new MySqlCommand(sql, conn); 
     MySqlDataReader rd = cmd.ExecuteReader(); 

     while (rd.Read()) 
     { 

      cboOrg.Items.Add(rd["orgAbbrev"].ToString()); 
      cboOrg.ValueMember = rd["orgAbbrev"].ToString(); 
      cboOrg.DisplayMember = rd["orgAbbrev"].ToString(); 

     } 
     conn.Close(); 
    } 

第二节

 try 
    { 
     conn.Open(); 
     string sql1 = "UPDATE courseandorg SET status = @status WHERE connID = @connID"; 
     MySqlCommand cmd1 = new MySqlCommand(sql1, conn); 

     cmd1.Parameters.AddWithValue("@connID", textBox1.Text); 
     cmd1.Parameters.AddWithValue("@status", comboBox1.Text); 

     cmd1.ExecuteNonQuery(); 
     Showlist(); //This is my funtion in my datagridview 
     your_func(); //This is new change 
     conn.Close(); 
    } 
    catch (Exception ex) 
    { 
     MessageBox.Show(ex.Message); 
    }