2 replies to this topic

[globalmind]

Hi!
I'm new here and new at C# programming.

I need code that will fill combobox from database.
I made something like this, but this doesn't work:

private void comboCategory_SelectedIndexChanged(object sender, EventArgs e)

        {

  

            comboCategory.Items.Clear();

            string SQLcombo = "SELECT CategoryName AS ComboList FROM Category";

            SqlCommand cmdCombo = new SqlCommand(SQLcombo, cnnStore);


            cnnStore.Open();

            SqlDataReader comboReader;

            comboReader = cmdCombo.ExecuteReader();

            while (comboReader.Read())

            { 

                comboCategory.Items.Add("CategoryList");

            }


        }

And when item from combo is selected, it need to show data from database in textbox. (ID, Name and Description)



Any help is apriciated!!
ThX

[elizabethmwashuma]

hi, r u initially able to have the drop down items of the combo box from the database?

[sam_coder]

you might consider downloading more of the table, and storing it in something like a Data Table.
Caching the information locally would have some great advantages, like latency. Chances are users will select one item, and then select another.

But to answer your question, you're likely going to want to store more than the name on the combo box, you're also going to want to store an identifier, so you know which record to pull the rest of the information from.

use ValueMember for that
so when the user selects something, you can then use the SelectedValue property, which you can then use in your query against the table, to pull the rest of the information.