protected void Button1_Click1(object sender, EventArgs e)
 {
     DataTable dt;
     getcid gspobj = new getcid();
     id = gspobj.getsid(TextBox1.Text, out dt);
     Response.Write(id);
     Session["sid"] = id;
     if (id != 0)
     {
         Response.Redirect("AfterSearch.aspx");
     }
 }
    protected void Page_Load(object sender, EventArgs e)
    {
        int scid;
        getcid obj = new getcid();
        scid = int.Parse(Session["sid"].ToString());

        if (!this.IsPostBack)
        {
            string constr = ConfigurationManager.ConnectionStrings["FlipkartConnectionString1"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(constr))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter("Select image1, product_name, product_Desc,product_price from Productdemo where product_id='" + scid + "'", conn))
                {
                    DataTable dt = new DataTable();
                    sda.Fill(dt);
                    dlProducts.DataSource = dt;
                    dlProducts.DataBind();
                }
            }
        }
    }