title: create a login page in vb.net by c# & mysql but it shows error message connection must be valid and open
body: <p>private void admin_submit_button_Click(object sender, EventArgs e)
          {
             try
             {
                 string myConnection = "datasource= localhost;port=3306;username=root;password=root";</p>
  
  <pre><code>           MySqlConnection myConn = new MySqlConnection(myConnection);
  
             MySqlCommand SelectCommand = new MySqlCommand("select * from mws.login_info where login_id='" + this.admin_id_textbox + "'and login_password1='" + this.admin_password_textbox1 + "' and login_password2='" + this.admin_password_textbox2 + "'");
             MySqlDataReader myReader;
             myConn.Open();
             myReader = SelectCommand.ExecuteReader();
             int count = 0;
             while (myReader.Read())
             {
                 count = count + 1;
             }
             if (count == 1)
             {
                 MessageBox.Show("username and password is correct");
             }
             else
                 MessageBox.Show("username and password not correct");
             myConn.Close();
         }
          catch(Exception ex)
         {
             MessageBox.Show(ex.Message);
  
  
  
  
  
          }
      }
  }
  </code></pre>
  
  <p>}﻿</p>