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);
...
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); } }All-Star
114593 Points
18503 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 :
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():
It's running ;)
All-Star
114593 Points
18503 Posts
MVP
Re: ComboBox with Linq from MS-Access
Feb 18, 2017 07:24 PM|Rion Williams|LINK
Perhaps the RefreshItems() method?
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.