public static void getKorisnikByUsernameAndPassword(DSLogin.KorisniksDataTable dtLogin, string username, string password) { SqlConnection cn = Connection.GetConnection(); if (cn.State == System.Data.ConnectionState.Closed) { cn.Open(); } try { SqlCommand cmd = new SqlCommand("usp_Login", cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; if (username != "") { cmd.Parameters.Add("@KorisnickoIme", SqlDbType.NVarChar).Value = username; } if (password != "") { cmd.Parameters.Add("@Lozinka", SqlDbType.NVarChar).Value = password; } SqlDataAdapter adapter = new SqlDataAdapter(cmd); adapter.Fill(dtLogin); } finally { } }
private void btnLogin_Click(object sender, EventArgs e) { //send txt username and pw to getuserlogin function var username = txtBox_Username.Text.Trim(); var password = txtBox_Password.Text.Trim(); DSLogin.KorisniksDataTable dtLogin = new DSLogin.KorisniksDataTable(); dtLogin.Clear(); DALogin.getKorisnikByUsernameAndPassword(dtLogin, username, password); if (dtLogin.Rows.Count == 1) { FrmDashboard formDashboard = new FrmDashboard(); this.Hide(); formDashboard.Show(); } else { MessageBox.Show("Check your username and password"); } }