Click here to Skip to main content
15,884,353 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
See more:
Please give me code for understanding how to start session when a user login successfully.Please help friends.
Posted

Assuming if the user name and password stored in database , ex : stored in login table
in login page:


protected void butnLogin_Click(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection();
con1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
string sql1 = " select * from Login where Email = @email and Pass = @pass";
SqlCommand cmd1 = new SqlCommand(sql1, con1);
cmd1.Parameters.AddWithValue("email", txtEmail.Text);
cmd1.Parameters.AddWithValue("pass", txtPass.Text);

con1.Open();
SqlDataReader dr = cmd1.ExecuteReader();
if (dr.Read())
{
con1.Close();
Session["UserAuthentication"] = username;
Response.Redirect("main.aspx");
}


else
lblLoginFaild.Visible = true;

}


in mainPage.aspx

protected void Page_Load(object sender, EventArgs e)
{
if ( Session["UserAuthentication"] == mull)
{
Response.Redirect("~/login.aspx");
}
}
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900