/// <summary> /// Login Credentials /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnLogin_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); SqlParameter[] sp = new SqlParameter[2]; sp[0] = new SqlParameter("@userid", txtLogin.Text); sp[1] = new SqlParameter("@pwd", txtPassword.Text); dt = bl.getExecutSP_DTWithParamter("userLogin", sp); if (dt != null && dt.Rows.Count > 0) { if (Convert.ToInt32(dt.Rows[0][0]) > 0) { this.Hide(); Movie _movie = new Movie(); _movie.ShowDialog(); } } else { txtLogin.Text = ""; txtPassword.Text = ""; MessageBox.Show("Login ID and Password is invalid."); } }
private void button1_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); SqlParameter[] sp = new SqlParameter[2]; sp[0] = new SqlParameter("@userid", textBox1.Text); sp[1] = new SqlParameter("@pwd", textBox2.Text); dt = bl.getExecutSP_DTWithParamter("userLogin", sp); if (dt != null && dt.Rows.Count > 0) { if (Convert.ToInt32(dt.Rows[0][0]) > 0) { Movie _movie = new Movie(); _movie.ShowDialog(); } else { //lblMsg.Visible = true; //lblMsg.Text = "Login ID and Password is invalid."; } } }