我是一个编程新手,已经在互联网上寻找了相当长的时间来解决我的问题,但很遗憾没有成功。请问有人能帮帮我吗?
我有一个包含不同表格的访问数据库,我想让所有表格出现在一个组合框中,例如:tblFood,tblCars,tblAnimals...
OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\School\Stage\Program testen\Program\bin\Debug\InventoryDB.accdb");
private void Form1_Load(object sender, EventArgs e)
{
con.Open();
OleDbCommand command = new OleDbCommand();
command.Connection = con;
string query = "Select * from ALL THE TABELS IN ACCESS";
command.CommandText = query;
OleDbDataReader reader = command.ExecuteReader();
while (reader.Read())
{
comboBoxTabel.Items.Add(reader["ADD THE TABLES TO COMBOBOX"].ToString());
}
con.Close();
}