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 !");
}
}
