searching record

I have a login project and it is running successfully but after login it is not saving the login session and because of this, i am unable to access the secure page. How to save the login session, please help me. Here is coding which i am using for the same...

//this is the code behind the login button click event

protected void log_Click(object sender, EventArgs e)
    {
        SqlDataSource sds = new SqlDataSource();
        sds.ConnectionString = ConfigurationManager.ConnectionStrings["myDbConnectionString1"].ToString();

        sds.SelectParameters.Add("username", TypeCode.String, this.username.Text);
        sds.SelectParameters.Add("password", TypeCode.String, this.password.Text);

        sds.SelectCommand = "SELECT * FROM [myTb] WHERE [username] = @username AND [password] = @password";

        DataView dv = (DataView)sds.Select(DataSourceSelectArguments.Empty);

        if (dv.Count == 0)
        {
            this.lblinfo.ForeColor = System.Drawing.Color.Red;
            this.lblinfo.Text = "Invalid username and password!";
            return;
        }
        else
        {
            // Creating session for user
            this.Session["username"] = dv.Row["username"].ToString();
            this.Session["password"] = dv.Row["password"].ToString();
            Response.Redirect("securepage/SecurePage.aspx");
        }
    }

What I have to use instead of red colored texts to work.

Help me !

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhimanyu K Vatsa16y ago
Hello...PJ Sir

SecurePage.aspx is simply a page which requires login (credential) to access it. Recent all pages are credential free. I have used below code in my configuration also.







Help me.....
PJ Martins16y ago
what is your code inside SecurePage.aspx to check that user is logged in?