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; } }