Thursday, October 31, 2013

sessions

login page:

 protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\codem\Documents\Visual Studio 2012\WebSites\WebSite12\App_Data\Database.mdf;Integrated Security=True");
        string s="select * from login where mobile='"+txtMobile.Text+"'and password='"+txtPassword.Text+"'";


        SqlCommand cmd = new SqlCommand(s,con);
        con.Open();
        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        sda.Fill(dt);
        if (dt.Rows.Count>0)
        {

            Session["a"] = "gmail";
            Response.Redirect("home.aspx");

        }
        else
        {
            Response.Write("fail");
        }
     



        con.Close();
     
    }




Home page.aspx
 protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["a"] != null)
        {

         
        }
        else
        {
            Response.Redirect("home.aspx");
        }


    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Session.Remove("a");

        Response.Redirect("login.aspx");
       
    }

1 comment: