Data binding to a combobox and display the list in a drop down list

Dinusha Gamage

Dear Friends,

I want to bind data to a combo box and display it in a drop down list when it runs the application.

In the given below coding I have done coding but there are some problems. Here I have created the dataset and then load the data from data source. After that, I'm trying to bind data to the combo box and display that in the drop down list..... So, that is difficult for me..Hope anybody can help me.........

Thanks in advence.

public LostCustInfo ActiveCust()

{

SqlConnection scon = new SqlConnection(con.SetConnection());

scon.Open();

LostCustInfo LCust = new LostCustInfo();

string query = "SELECT cust_code,cust_name FROM CM_LOSTCUST WHERE active = 'Y'";

SqlCommand cmd = new SqlCommand(query, scon);

SqlDataAdapter adpt = new SqlDataAdapter(cmd);

adpt.Fill(LCust, "LostCustomer");

scon.Close();

return LCust;

}

private void ListCustomerCode()

{

LostCustInfo Lcust = new LostCustInfo();

Lcust = Lcust.ActiveCust();

if (!object.Equals(Lcust, null))

{

cboCustCode.DataSource = Lcust;

cboCustCode.DataBind(); // there is no method like this ?????

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Neetika Gupta18y ago
Also give the alias name to the column:
"SELECT cust_code, " + ' ' + "cust_name AS Name FROM customers";
You can use the same code:

if (!object.Equals(Lcust, null))

            {

                comboBox1.DataSource = Lcust.Tables[0];

                comboBox1.DisplayMember = "Name";

            }
Neetika Gupta18y ago
To display 2 fields in a drop down list, we can write the query like this:
"SELECT cust_code, " + ' ' + "cust_name FROM customers";

This query will fetch cust_code and cust_name as one column with space in between.
Dinusha Gamage18y ago
Thanks Manish....

I need to know that If you want to display two fields in the drop down list, How do you do that ? (such as cust_code and cust_name) Could you plz notify that in the given below coding?

if (!object.Equals(Lcust, null))

            {

                comboBox1.DataSource = Lcust.Tables[0];

                comboBox1.DisplayMember = "Name";

            }
Blocked Account18y ago
I am sending you the working code for that.

private void Form1_Load(object sender, EventArgs e)

        {

            ListCustomerCode();

        }

        public DataSet ActiveCust() // Create the data set

        {

            SqlConnection scon = new SqlConnection("server=.;database=Northwind;UID=sa;pwd=;");

            scon.Open();

            DataSet LCust = new DataSet();

            string query = "SELECT Name,City FROM tblCity";

            SqlCommand cmd = new SqlCommand(query, scon);

            SqlDataAdapter adpt = new SqlDataAdapter(cmd);

            adpt.Fill(LCust, "LostCustomer");

            scon.Close();

            return LCust;

        }

        private void ListCustomerCode()

        {

            DataSet Lcust = new DataSet();

            Lcust = ActiveCust();

            if (!object.Equals(Lcust, null))

            {

                comboBox1.DataSource = Lcust.Tables[0];

                comboBox1.DisplayMember = "Name";

            }

        }
Happy Coding!!