ComboBox Integer

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • HEISENBERG
    New Member
    • May 2015
    • 1

    ComboBox Integer

    Hi

    I have connected my program to an access database file, and when I select the numbers in the combobox (1, 2, 3 etc.) I want to automatically fill the other textboxes in the form .. it works if it's a string .. for example if i select a string (e.g. name) in the combobox it automatically fills the other textboxes, but it doesn't work if it's an integer.

    I know I must convert to int, but I don't know how because i have a query:

    Code:
    private void iD_FurnizorComboBox_SelectedIndexChanged_1(object sender, EventArgs e)
            {
                try
                {
                    connection.Open();
                    OleDbCommand command = new OleDbCommand();
                    command.Connection = connection;
                    string query;
                    query = "select * from Furnizori where id_furnizor = '" + iD_FurnizorComboBox.Text + "'";
                    int query_test = int.Parse(query);
                    command.CommandText = query;
                    OleDbDataReader reader = command.ExecuteReader();
                    while (reader.Read())
                    {
                        numeTextBox.Text = reader["nume"].ToString();
                        adresaTextBox.Text = reader["adresa"].ToString();
                        localitateTextBox.Text = reader["localitate"].ToString();
                        judetTextBox.Text = reader["judet"].ToString();
                    }
                    connection.Close();
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    connection.Close();
                }
            }
    I don't know where to parse the string to int.. thank you!!
Working...