Question

C#中怎么用access数据库绑定下拉框

有数据库操作类

Answer 1

// 下拉框的下拉事件写下面代码
string connectionStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\Test.mdb";
using (OleDbConnection con = new OleDbConnection(connectionStr))
{
    using (OleDbCommand cmd = new OleDbCommand())
    {
        con.Open();
        cmd.CommandText = string.Format("SELECT ColumnName FROM TestTable ");
        cmd.Connection = con;
        using (OleDbDataReader reader = cmd.ExecuteReader())
        {
            while (reader.Read())
            {
                comboBox1.Items.Add(reader[0]);
            }
        }
    }
}