C#如何使用ACCESS数据库字段填充Combobox

最新推荐文章于 2021-01-11 13:06:35 发布

天下第一刀2020

最新推荐文章于 2021-01-11 13:06:35 发布

阅读量2.1k

点赞数

文章标签：数据库 access c# string object button

本文链接：https://blog.csdn.net/lovegod12/article/details/3986690

版权

private void button1_Click(object sender, EventArgs e)

{

            string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=teacher.mdb";//数据库名
            OleDbConnection ODConn = new OleDbConnection(ConnStr);
            ODConn.Open();
            string sel = "select * from t1 ";//t1表名
            OleDbCommand ODComm1 = ODConn.CreateCommand();
            ODComm1.CommandText = sel;
            DataTable MyTable = new DataTable();
            OleDbDataAdapter MyAdapter = new OleDbDataAdapter(ODComm1);
            MyAdapter.Fill(MyTable);

comboBox1.DataSource = MyTable;
comboBox1.DisplayMember = "CompanyName";

comboBox1.ValueMember = "CumtomerID";

ODConn.Close();

}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            //显示combobox控件中当前选择客户的ID和公司名称
            string MyInfo = "当前ID是" + comboBox1.SelectedValue as string;
            MyInfo += ",companyName是：" + comboBox1.Text;
            MessageBox.Show(MyInfo, "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

}