My goal is to first authenticate the user, and then on the next page, /users/default.aspx present a header like:
Wecome: Full name
Username: username
Email: Email address
How do I get these variables for the next page? (page sent to for successful logon) Here's my select statement:
sqlstring = "Select username, password, fullname, email from SiteUser where username='" + username + "' and password ='" + password + "'" + " and active='True'";
How do I store the username, password, fullname as session variables with the sqldatareader?
protected void Page_Load(object sender, EventArgs e)
{
// Check if the user is already logged in or not
if ((Session["Check"] != null) && (Convert.ToBoolean(Session["Check"]) == true))
{
// If User is Authenticated then moved to a main page
...
Go to the complete details ...