How can I fill a combobox from sql database ( students table with id, and name columns ) , the display text represents the name of a student and the value of the item of combobox is the id for that student that when I get the value of the combobox I will get the id value
-
3Possible duplicate of Populating a ComboBox using C#Jim Fell– Jim Fell2016-06-10 21:05:42 +00:00Commented Jun 10, 2016 at 21:05
-
Possible duplicate of Fill Combobox from databaseuser9204293– user92042932018-03-26 02:38:54 +00:00Commented Mar 26, 2018 at 2:38
-
Possible duplicate of How to bind a List to a ComboBox?KyleMit– KyleMit ♦2019-04-26 22:21:03 +00:00Commented Apr 26, 2019 at 22:21
Add a comment
|
2 Answers
Below are the important properties for you.
A data source can be a database, a Web service, or an object that can later be used to generate data-bound controls. When the DataSource property is set, the items collection cannot be modified.
ComboBox.DisplayMember Property
A String specifying the name of an object property that is contained in the collection specified by the DataSource property. The default is an empty string ("").
A String representing the name of an object property that is contained in the collection specified by the DataSource property. The default is an empty string ("").
DataTable dataTable = GetDataTable("Select * from Student"); // You have to implement the ways to retrieve data from the database.
comboBox1.Datasource = dataTable;
comboBox1.DisplayMember = StudentName; // Column Name
comboBox1.ValueMember = StuentId; // Column Name
Here is one way if you want to add items programmatically.
private class Item
{
public string _Name;
public int _Id
public Item(string name, int id)
{
_Name = name;
_Id = id;
}
public string Name
{
get { return _Name; }
set { _Name = value; }
}
public string Id
{
get { return _Id; }
set { _Id = value; }
}
}
comboBox1.DisplayMember = "Name";
comboBox1.ValueMember = "Id";
comboBox1.Items.Add(new Item("Student 1", 1));
comboBox1.Items.Add(new Item("Student 2", 2));
comboBox1.Items.Add(new Item("Student 3", 3));
There are various ways of doing this.
2 Comments
wavedrop
In the example above you need to add "{get; set;}" to the Item class properties "Name" and "Id" otherwise the combo box will only display the object type.
Thomas.Benz
This works like a charm. Thanks.
First off you need to figure out how you're going to get the data back from the DB, but I'll assume you either know that or intend to ask another question in regards to that. From there, your best bet is to bind some collection to the ComboBox. Here is an example of doing that with a DataSet. You can also bind to List<T> or other IEnumerable<T>, which would make more sense if you're going to use LINQ to get at the data. Here is a question here on SO about binding a List to a ComboBox Perhaps you could tell us how you intend to get at the data so we could give you a more tailored answer?
