Select a combobox's Item when I insert into my textbox

Israel

Hi!

I need to make a logic that will select a certain item from my combobox when I insert a value into my textbox. For example, my combobox have three itens (Baby, adult and old) . Then "Baby" is between 0 to 3, "adult" is between 25 to 50 then "old" is between 60 to 90.

Means when I insert into my textbox one of these number its should display on my combobox one of this item.

See what I try to do but this is works when I select from combobox display one value into my textbox:

string str = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\INAC\Documents\Windows_Application_Samples\ComboboxItems_show_in_label\App_Data\office.mdb;Persist Security Info=False";

OleDbConnection con = new OleDbConnection(str);

string query = "select * from tablename where name = '" + comboBox1.SelectedItem.ToString() + "' ";

OleDbCommand cmd = new OleDbCommand(query, con);

OleDbDataReader dbr;

try

{

con.Open();

dbr = cmd.ExecuteReader();

while (dbr.Read())

{

string sname = (string)dbr["name"].ToString(); // name is string value

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

finally

{

con.Close();

}

4 Replies

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

Nilesh Shah9y ago
Accepted answer
For windows form application, following code should work, see attached project too
class MyItem
        {
            public int Age { get; set; }
            public string AgeText { get; set; }
        }

        private void PanelForm1_Load(object sender, EventArgs e)
        {
            comboBox1.Items.Add(new MyItem() { Age=0, AgeText= "Baby" });
            comboBox1.Items.Add(new MyItem() { Age = 25, AgeText = "adult" });
            comboBox1.Items.Add(new MyItem() { Age = 60, AgeText = "old" });
            comboBox1.DisplayMember = "AgeText";
            comboBox1.ValueMember = "Age";
        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            int val = 0;
            int.TryParse(textBox1.Text.Trim(), out val);

            if (val >= 0 && val <= 3)
            {
                comboBox1.SelectedIndex = comboBox1.FindStringExact("Baby");
            }
            else if (val >= 25 && val <= 50)
            {
                comboBox1.SelectedIndex = comboBox1.FindStringExact("adult");
            }
            else if (val >= 60 && val <= 90)
            {
                comboBox1.SelectedIndex = comboBox1.FindStringExact("old");
            }
            else
            {
                comboBox1.SelectedIndex = -1;
            }
        }
Israel9y ago
@Nilesh Shah

It's perfect. Thank you!
Israel9y ago
I am using Windows application
Nilesh Shah9y ago
what type of your project? web forms or asp.net web forms?
please mention in question clearly which solution you want
because solution will be different for all