StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I added a <strong>DataSet</strong> to the solution and droped the <em>Employees</em> table (from <em>Northwind</em>) in the designer, which automatically created the <strong>employeesBindingSource</strong>. I dropped a combobox and a button on the Form and I set the <strong>DataSource</strong> and <strong>DataMember</strong> of the combo. Then I handled some events:</p> <pre><code> private void Form1_Load(object sender, EventArgs e) { this.employeesTableAdapter.Fill(this.dS.Employees); } private int _i = 0; private void button1_Click(object sender, EventArgs e) { ComboBox combo = new ComboBox(); combo.DataSource = this.employeesBindingSource; combo.DisplayMember = this.dS.Tables[0].Columns[++_i].ColumnName; combo.Location = new Point(comboBox1.Location.X, comboBox1.Location.Y + comboBox1.Height * _i); this.Controls.Add(combo); } </code></pre> <p>So on each click, a new combo is added onto the form dynamically right under the previous combo. The combo is also bound to the next column in the Employees table (no boundary checks however). </p> <p>As you can see, this is pretty easy stuff. Hope this helps. </p> <hr> <p>Okay, so here is a variation of the code that could help you with that other question you asked in the comments of this answer. </p> <p>It assumes you have a <strong>Form</strong> with a button and a <em>DataSet</em> with table <em>Employees</em>. On button click it creates a combo, and fills it with data (the <em>Name</em> column of <em>Employees</em>). Each time you add a combo, it gets its own copy of the data (this is important to be able to remove items from one combo at a time). Then, every time you select a value in the combo, the combo is disabled and the other combos don't have that selected value in their list. </p> <pre><code> private int _i = 0; private void button1_Click(object sender, EventArgs e) { DataSet dataS = dS.Clone(); this.employeesTableAdapter.Fill((DS.EmployeesDataTable)dataS.Tables[0]); BindingSource bindSource = new BindingSource(dataS, "Employees"); ComboBox combo = new ComboBox(); combo.Name = this.dS.Tables[0].Columns[0].ColumnName + (++_i).ToString(); combo.DataSource = bindSource; combo.DisplayMember = this.dS.Tables[0].Columns[1].ColumnName; //This column is the Name of Employee combo.Location = new Point(button1.Location.X, button1.Location.Y + combo.Height * _i); combo.SelectedIndexChanged += new EventHandler(comboBox_SelectedIndexChanged); this.Controls.Add(combo); } private void comboBox_SelectedIndexChanged(object sender, EventArgs e) { foreach (Control ctrl in this.Controls) { if (ctrl is ComboBox && ctrl != sender && ctrl.Enabled) { ((BindingSource)((ComboBox)ctrl).DataSource).RemoveAt(((ComboBox)sender).SelectedIndex); } } ((ComboBox)sender).Enabled = false; } </code></pre> <p>This is pretty close to what you require, or easily adaptable to meet your expectations. Enjoy and please select an answer as the accepted one. Thanks!</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload