title: change the text box values according to the combo box selection
body: <p>I am new in C# here i am trying to bind combo box with access database.
  I bound the combo box with column name but i can not display the value of details(Column) in text box based on the selection of combo box.</p>
  
  <p>in my database there is a table which contain the 3 coloumn
  1.id
  2.wesitename
  3.Details
  and 
  this is my code</p>
  
  <pre><code> private void button1_Click_1(object sender, EventArgs e)
          {
   string ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\nazarmak\\Documents\\newwebsite.accdb;Persist Security Info=True";
  
          OleDbConnection con = new OleDbConnection(ConnectionString);
          OleDbCommand cmd = new OleDbCommand("select websitename, Details from newweb", con);
          OleDbDataAdapter da = new OleDbDataAdapter();
  
           DataTable dt = new DataTable();
  
          try
          {
              con.Open();
              da.SelectCommand = cmd;
              da.Fill(dt);
  
  
              this.comboBox1.DisplayMember = "websitename";
              this.comboBox1.ValueMember = "websitename";
              this.comboBox1.DataSource = dt;
  
  
  
          }
          catch (System.Exception ex)
          {
              MessageBox.Show(ex.Message);
  
  
          }
          finally
          {
  
              con.Close();
          }
  
      }
  </code></pre>