title: Get Text and int Form Mysql and store in a text box
body: <p>I am making an application witch uses a Browser to show a viral video a week.The url for the video is stored in a my MySQL database online along with an int that shows a counter in the top right hand corner, What I want to do is get the string of text from the MySQL data base and the in and write that information into a text box called Video1 and Counter. </p>
  
  <p>Here is some of my current code: </p>
  
  <pre><code>        private void Form1_Load(object sender, EventArgs e)
      {
  
          timer1.Interval = Convert.ToInt32(Refresh_Rate.Text);
          timer1.Enabled = true;
  
          try
          {
              string myConnrction = "datasource=************;port=3306;username=*******;password=*******";
              MySqlConnection myConn = new MySqlConnection(myConnrction);
              MySqlCommand SelectCommand = new MySqlCommand("select * from sql337069.Youtube where Video1='", myConn);
              MySqlDataReader myReader;
              myConn.Open();
              myReader = SelectCommand.ExecuteReader();
              while (myReader.Read())
              {
  
              }
  
  
  
              MySqlDataAdapter myDataAdapter =new MySqlDataAdapter();
              myDataAdapter.SelectCommand = new MySqlCommand(" select * sql337069.Youtube ;", myConn);
              MySqlCommandBuilder cb = new MySqlCommandBuilder(myDataAdapter);
              myConn.Open();
              DataSet ds = new DataSet();
              MessageBox.Show("Working");
              myConn.Close();
  
  
          }
  
          catch
          {
              MessageBox.Show("Null");
          }
  </code></pre>
  
  <p>So I guess I am looking for is something like <code>Video1.text += [?]</code>. </p>