How to keep the page contents if it is posted back

Joma Rajab

10y835.NET

I need to keep the grid view which appears as a result of searching by id in the text field when the page id posted back. To illustrate, I have the link on grid view table takes me to another page then I have on the page link go back that grid view is not found because the page in posted back.

please help

thank you

6 Replies

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

Manas Mohapatra10y ago
Accepted answer
In below answer, it uses Session. Because if you store it cache then it will affect other users.

Note: If you want to change to Cache.

Find below code snippet:
private void view_back()
{
    SqlConnection con = new SqlConnection("ConnectionString");
    stringquery="SElEC where t3.user_type='Staff' and t1.IsDeleted = 0 AND t2.MID = '"+TextBox7.Text+"'";
    SqlDataAdapter ad = new SqlDataAdapter("select * from table", con);
    DataSet ds = new DataSet();
    ad.Fill(ds);
    //Cache.Insert("MId", TextBox7.Text, null , DateTime.Now.AddMinutes(30), TimeSpan.Zero);
    Session["searchText"] = TextBox7.Text;

    GridView1.DataSource = ds;
}

protected void Page_Load(objectsender, EventArgse)
{
    if(Session["searchText"] != null)
    {
        TextBox7.Text = Session["searchText"];
        view_back();
        rep_bind();
    }

    if(IsPostBack)
    {
        label10.Text="";
        view_back();
        Session["searchText"] = TextBox7.Text;
        grid.Visible=true;
    }
}
+1
Joma Rajab10y ago
Thanks
I am sorry for keeping post to you I added the code to post back page but it returns the case to the beginning which means when I go back to the page the grid view is not found and text field is empty
0
Manas Mohapatra10y ago
Use below code inside IsPostBack like below
if(!Page.IsPostBack)
{
if(Session["searchText"] != null)
{
TextBox7.Text = Session["searchText"];
view_back();
rep_bind();
}
}
+1
Joma Rajab10y ago
Thanks very much
Itworks but I cannot search with another id as the previous result on grid view stay there
please if you have any idea to fix it
thanks
0
Joma Rajab10y ago
Thanks Manas
//pageload
protectedvoidPage_Load(objectsender,EventArgse)
{
Cache["MId"]=TextBox7.Text;
if(TextBox7.Text!=null)
{
view_back();
rep_bind();
}
if(IsPostBack)
{
label10.Text="";
view_back();
Cache["MId"]=TextBox7.Text;
grid.Visible=true;
}
}
//searchcode
protectedvoidSearch(objectsender,EventArgse)
{
if(TextBox7.Text!=null)
{
SqlConnectioncon1=newSqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
con1.Open();
stringquery="SElECtt1.*,t2.*,t3.*fromdbo.MaterialASt1INNERJOINdbo.ModuleRelationAst2ONt2.MID=t1.MIDINNERJOINdbo.UsersASt3ONt3.UniID=t2.UIdwheret3.user_type='Staff'andt1.IsDeleted=0ANDt2.MID='"+TextBox7.Text+"'";
SqlCommandcom=newSqlCommand(query,con1);
SqlDataReaderdr;
dr=com.ExecuteReader();
if(dr.HasRows)
{
dr.Read();
rep_bind();
label10.Text="";
grid.Visible=true;
}
if(!dr.HasRows)
{
label10.Text="ModuleIDNotFound!";
grid.Visible=false;
}
}
}
//methodfordisplayinggridview
privatevoidrep_bind()
{
if(TextBox7.Text!=null)
{
SqlConnectioncon1=newSqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
con1.Open();
stringquery="SElECtt1.*,t2.*,t3.*fromdbo.MaterialASt1INNERJOINdbo.ModuleRelationAst2ONt2.MID=t1.MIDINNERJOINdbo.UsersASt3ONt3.UniID=t2.UIdwheret3.user_type='Staff'andt1.IsDeleted=0ANDt2.MID='"+TextBox7.Text+"'";
SqlDataAdapterda=newSqlDataAdapter(query,con1);
DataSetds=newDataSet();
da.Fill(ds);
GridView1.DataSource=ds;
GridView1.DataBind();
}
}
//forclickonviewlinkongridviewtoredirecttoaontherpage
publicvoidView()
{
Response.Redirect("View.aspx?Id="+(MaID));
}
//thisIdidtokeepthecontentsofthepagewhenitloadedandIcalledinloadmethodbutnotworkingjustitkeepserrormessageforif(!dr.HasRows)
privatevoidview_back()
{
if(TextBox7.Text!=null)
{
SqlConnectioncon1=newSqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
con1.Open();
stringquery="SElECtt1.*,t2.*,t3.*fromdbo.MaterialASt1INNERJOINdbo.ModuleRelationAst2ONt2.MID=t1.MIDINNERJOINdbo.UsersASt3ONt3.UniID=t2.UIdwheret3.user_type='Staff'andt1.IsDeleted=0ANDt2.MID='"+TextBox7.Text+"'";
SqlCommandcom=newSqlCommand(query,con1);
SqlDataReaderdr;
dr=com.ExecuteReader();
if(dr.HasRows)
{
dr.Read();
rep_bind();
label10.Text="";
grid.Visible=true;
}
if(!dr.HasRows)
{
label10.Text="ModuleIDNotFound!";//thisappearswhenthepageispostedback
grid.Visible=false;
}
}
}
me with an example of using cache I tried to keep the id in search text field in loading page but it still not working
can you please provide
please help I am really struggling with it
Thanks
+1
Manas Mohapatra10y ago
If you are playing with more than one page either you have to keep it Cache or server session variable.

If you play in one page then you can use viewstate concept to store results. But your cas is different.

So for your case first option is suitable.
0