从访问中获取组合框值
本文关键字:组合 获取 访问 | 更新日期: 2023-09-27 18:30:57
我有一个winform
项目,access file
作为database
。在我的一个表单中,我希望用户从combobox
中选择company
。
(坎帕尼列表在访问表中)
如何将company name
列设置为组合框下拉值?
试试这个
string qr1 = "select companyname from table1";
SqlCommand cmd1 = new SqlCommand(qr1, con);
con.Open();
SqlDataReader dr1 = cmd1.ExecuteReader();
cmbcat.Items.Clear();
while (dr1.Read())
{
cmbcat.Items.Add(dr1[0].ToString());
}
con.Close();
to Nimi
这是 OledbCommand 吗?
我的解决方案是....
public void make_cbDispatch()
{
string ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;"
+ "Data Source=I:''Projects''project.accdb;"
+ "Persist Security Info=False;";
string qr1 = "SELECT DISTINCT object "
+ "FROM tList "
+ "ORDER BY object ";
OleDbConnection con = new OleDbConnection(ConnectionString);
OleDbCommand cmd1 = new OleDbCommand(qr1, con);
con.Open();
OleDbDataReader dr1 = cmd1.ExecuteReader();
cbDispatch.Items.Clear();
while (dr1.Read())
{
cbDispatch.Items.Add(dr1[0].ToString());
}
con.Close();
}