private void cbxFormula_SelectedIndexChanged(object sender, EventArgs e)
{
DataTable dataTable = new DataTable();
SqlConnection connection = new SqlConnection(connstr);
string sql = "select * from " + cbxFormula.Text + "";
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sql, connection);
connection.Open();
sqlDataAdapter.Fill(dataTable);
DgvGongShi.DataSource = dataTable;
}
cbxFormula.DataSource = data1;
cbxFormula.DisplayMember = "FormulaName";
cbxFormula.ValueMember = "FormulaName";
设置断点调试后,给combobox绑定数据源,直接运行到comboBox的SelectedIndexChanged事件,所以调顺序即可
cbxFormula.DisplayMember = "FormulaName";
cbxFormula.ValueMember = "FormulaName";
cbxFormula.DataSource = data1;