组合框无法显示新添加的值
本文关键字:添加 新添加 显示 组合 | 更新日期: 2024-07-23 01:38:44
我在组合框中添加了一个新值,它应该根据我在数据库中的内容显示。但不幸的是,新的值没有显示出来。以下是我的代码。
string dbConn = "Data Source=.''SQLEXPRESS;AttachDbFilename=C:''Users''SONY''Desktop''FinalYearProject''FinalYearProject''bin''Debug''housewife.mdf;Integrated Security=True;User Instance=True";
void fill_Combo() {
SqlConnection conn = new SqlConnection(dbConn);
try {
conn.Open();
string query = "Select * From Food";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read()) {
string name = dr.GetString(1);
comboBox1.Items.Add(name);
}
conn.Close();
}
catch(Exception ex){
MessageBox.Show(ex.Message);
}
}
您应该使用一个可观察的集合作为数据源并绑定到该集合。请参阅WPF 中的Add items to comboBox
嗨,请尝试这样的东西,希望它能帮助
string dbConn = "Data Source=.''SQLEXPRESS;AttachDbFilename=C:''Users''SONY''Desktop''FinalYearProject''FinalYear Project''bin''Debug''housewife.mdf;Integrated Security=True;User Instance=True";
void fill_Combo() {
SqlConnection conn = new SqlConnection(dbConn);
try {
conn.Open();
string query = "Select * From Food";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds)
combobox1.DataSourse = ds;
combobox1.DisplayMember = "fieldname";
combobox1.ValueMember = "fieldname";
}
catch(Exception ex){
MessageBox.Show(ex.Message);
}
}