public void validateUser(String user_name, String access_code)
{
conn.Open();
int i;
sql = "SELECT * FROM user_credentials WHERE user_id = '" + user_name + "' AND access_code='" + access_code + "'";
mySqlCommand.CommandType = CommandType.Text;
mySqlCommand.CommandText = sql;
mySqlCommand.ExecuteNonQuery();
dataTable = new DataTable();
mySqlDataAdapter = new MySqlDataAdapter(mySqlCommand);
mySqlDataAdapter.Fill(dataTable);
i = Convert.ToInt32(dataTable.Rows.Count.ToString());
if (i == 0)
{
MessageBox.Show("check your credential..");
}
else
{
Landing_Page l = new Landing_Page();
l.Show();
}
conn.Close();
}
private void btnSignin_Click(object sender, EventArgs e)
{
//user validation
conn.Open();
MySqlCommand mySqlCommand = conn.CreateCommand();
mySqlCommand.CommandType = CommandType.Text;
mySqlCommand.CommandText = "SELECT * FROM user_credentials WHERE user_id = '" + tbUsername.Text + "' AND access_code='" + tbPassword.Text + "'";
mySqlCommand.ExecuteNonQuery();
DataTable dataTable = new DataTable();
MySqlDataAdapter mySqlDataAdapter = new MySqlDataAdapter(mySqlCommand);
mySqlDataAdapter.Fill(dataTable);
i = Convert.ToInt32(dataTable.Rows.Count.ToString());
if (i == 0)
{
MessageBox.Show("Check your credentials please.. !");
}
else
{
Landing_Page l = new Landing_Page();
l.Show();
Visible = false;
}
}