ComboBox with Linq from MS-Access [Answered]RSS

• • Reply
  

  prografix

  None

  0 Points

  6 Posts

  ComboBox with Linq from MS-Access

  Feb 18, 2017 05:19 PM|prografix|LINK

  Hi - I'm trying to fill a combobox with Linq from MS-Access. But if I debug the code, the combobox is empty.

  I read some older posts but they didn't help. Where is the failure?

  OleDbConnection connection = new OleDbConnection();
  
          public Form1()
          {
              InitializeComponent();
              connection.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Pools.accdb; Persist Security Info=False;";
          }
  
          private void Form1_Load(object sender, EventArgs e)
          {
              try
              {
                  connection.Open();
                  connectionLabel.Text = "Connection successful!";
  
                  PoolsDataSet pool = new PoolsDataSet();
                  comboBoxPool.DataSource = (from x in pool.Pools
                                            select x.ID).ToList();
  
                  comboBoxPool.DisplayMember = "ID";
  
                  connection.Close();
  
              } catch (Exception ex)
              {
                  MessageBox.Show("Error" + ex);
              }
          }

• • Reply
  

  Rion William...

  All-Star

  113090 Points

  18367 Posts

  MVP

  Re: ComboBox with Linq from MS-Access

  Feb 18, 2017 06:16 PM|Rion Williams|LINK

  After setting the DataSource property, you generally need to call the DataBind() method to actually apply the changes :

  // Set your DataSource here
  comboBoxPool.DataBind();

  Blog | Twitter | Stack Overflow | LinkedIn
• • Reply
  

  prografix

  None

  0 Points

  6 Posts

  Re: ComboBox with Linq from MS-Access

  Feb 18, 2017 07:08 PM|prografix|LINK

  Thanks Rion, to fill my pool-Object was the problem. I got it with adding .Fill():

  ...
  connection.Open();
  connectionLabel.Text = "Connection successful!";
  
  PoolsDataSet pool = new PoolsDataSet();
  (new PoolsDataSetTableAdapters.PoolsTableAdapter()).Fill(pool.Pools);
  ...

  It's running ;)

• • Reply
  

  Rion William...

  All-Star

  113090 Points

  18367 Posts

  MVP

  Re: ComboBox with Linq from MS-Access

  Feb 18, 2017 07:24 PM|Rion Williams|LINK

  Perhaps the RefreshItems() method?

  Blog | Twitter | Stack Overflow | LinkedIn
• • Reply
  

  prografix

  None

  0 Points

  6 Posts

  Re: ComboBox with Linq from MS-Access

  Feb 18, 2017 07:34 PM|prografix|LINK

  You was faster than me ;) I edit my last post!

  Thanks a lot.