private void buttonLogin_Click(object sender, EventArgs e) { MY_DB db = new MY_DB(); SqlDataAdapter adapter = new SqlDataAdapter(); DataTable table = new DataTable(); SqlCommand command = new SqlCommand("SELECT * FROM login WHERE username = @User AND password = @Pass", db.getConnection); command.Parameters.Add("@User", SqlDbType.VarChar).Value = textBoxUsername.Text; command.Parameters.Add("@Pass", SqlDbType.VarChar).Value = textBoxPassword.Text; adapter.SelectCommand = command; adapter.Fill(table); if ((table.Rows.Count > 0)) { this.DialogResult = DialogResult.OK; MessageBox.Show("Login Success"); FormDashBoard dashBoard = new FormDashBoard(); dashBoard.Show(this); } else { MessageBox.Show("Invalid Username or Password", "Login Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }