private void backButton_Click(object sender, EventArgs e) { AdminHome form = new AdminHome(ausername, apassword); form.Tag = this; form.Show(this); Hide(); }
private void adminLogin_Click(object sender, EventArgs e) { try { string MyConnection2 = "server=localhost;user id=root;password=greenery;persistsecurityinfo=True;database=user"; //Display query string Query = "select a_password from admins where a_username='******';"; MySqlConnection MyConn2 = new MySqlConnection(MyConnection2); MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2); // MyConn2.Open(); //For offline connection we weill use MySqlDataAdapter class. MySqlDataAdapter MyAdapter = new MySqlDataAdapter(); MyAdapter.SelectCommand = MyCommand2; DataTable dTable = new DataTable(); MyAdapter.Fill(dTable); foreach (DataRow row in dTable.Rows) { password = row["a_password"].ToString(); } //usernameTextBox.Text = password; if (password.Equals(passwordTextBox.Text)) { AdminHome form2 = new AdminHome(usernameTextBox.Text, passwordTextBox.Text); form2.Tag = this; form2.Show(this); Hide(); } else { MessageBox.Show("Wrong Username/Password !"); } dataGridView1.DataSource = dTable; // here i have assign dTable object to the dataGridView1 object to display data. // MyConn2.Close(); } catch (Exception ex) { MessageBox.Show("Wrong Username/Password !"); } }