private void Login_Click(object sender, EventArgs e) { SQLConnect conn = new SQLConnect(); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand(); String query = " SELECT * FROM `appusers` WHERE `username`= @admin AND `password`= @12345;"; command.CommandText = query; command.Connection = conn.GetConnection(); command.Parameters.Add("@admin", MySqlDbType.VarChar).Value = username.Text; command.Parameters.Add("@12345", MySqlDbType.VarChar).Value = Password.Text; adapter.SelectCommand = command; adapter.Fill(table); if (table.Rows.Count > 0) { this.Hide(); Main mform = new Main(); mform.Show(); } else { if (username.Text.Trim().Equals("") && Password.Text.Trim().Equals("")) { MessageBox.Show("Enter Username and Password to Login", "Empty Username and Password fields", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (username.Text.Trim().Equals("")) { MessageBox.Show("Enter Username to Login", "Empty Username field", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (Password.Text.Trim().Equals("")) { MessageBox.Show("Enter Password to Login", "Empty Password field", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("Username or Password is not correct. Please try again", "Incorrect username or password", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public void FillCombo() { SQLConnect conn = new SQLConnect(); DataTable dt = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand(); String query = " SELECT gender from sex"; command.CommandText = query; command.Connection = conn.GetConnection(); adapter.SelectCommand = command; adapter.Fill(dt); foreach (DataRow dr in dt.Rows) { sexcombobox.Items.Add(dr["gender"].ToString()); } }