protected void btnLogin_Click(object sender, EventArgs e)
    {
        try
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
            SqlCommand cmd = new SqlCommand("SELECT * FROM UserLogin", conn);
            conn.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                if (txtUserName.Text == dr[0].ToString())
                {
                    if (txtPassword.Text == dr[1].ToString())
                    {
                        Response.Redirect("FrmLogin.aspx");
                    }
                    else
                    {
                        lblError.Text = "UserName & Password do not match";
                    }
                }
                else
                {
                    lblError.Text = "UserName & Password do not match";
                }
            }
        }
 
        catch (Exception ex)
        {
            Response.Write(ex.Message.ToString());
        }
    }