protected void Button1_Click(object sender, EventArgs e) { DataTable dt; getsearchprod gspobj = new getsearchprod(); id = gspobj.getsid(tbsearch.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; getsearchprod obj = new getsearchprod(); 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 img, product_name, product_Desc,product_price from Product where sub_category_id='" + scid + "'", conn)) { DataTable dt = new DataTable(); sda.Fill(dt); Searchprod.DataSource = dt; Searchprod.DataBind(); } } } }