从MS Access中填充Combobox

Question

我是C＃和LINQ的新手，想在MS Access中用LINQ填充ComboBox。但是，如果我调试代码，则ComboBox为空。

我阅读了一些较旧的帖子，但它们没有帮助。失败在哪里？

private void Form1_Load(object sender, EventArgs e)
{
    try
    {
        connection.Open();
        label1.Text = "OK";
        PoolDataSet pool = new PoolDataSet();
        comboBoxPool.DisplayMember = "Pool-Name";
        comboBoxPool.ValueMember = "ID";
        comboBoxPool.DataSource = (from x in pool.Pools
                                      select x._Pool_Name).ToList();
        connection.Close();
    }
    catch (Exception ex)
    {
        MessageBox.Show("Error" + ex);
    }
 }

Answer 1

谢谢，要填补我的池对象是问题所在。我添加.fill（）：

connection.Open();
connectionLabel.Text = "Connection successful!";
PoolsDataSet pool = new PoolsDataSet();
(new PoolsDataSetTableAdapters.PoolsTableAdapter()).Fill(pool.Pools);
comboBoxPool.DataSource = (from x in pool.Pools
                           select x.ID).ToList();
comboBoxPool.DisplayMember = "ID";
connection.Close();

它正在运行;）