gridview paging problem

Question

0.00/5 (No votes)

See more:

Hi,
thins is gridview code in my webPage

ASP.NET

<asp:GridView ID="GridView1" runat="server" BorderStyle="None" OnPageIndexChanging="GridView1_PageIndexChanging" AllowPaging="True">
           
            <Columns>
                <asp:TemplateField HeaderText="Select">
                    <ItemTemplate>
                        <asp:CheckBox ID="IdSelector" runat="server" OnCheckedChanged="Button1_Click"/>
                    </ItemTemplate>
                </asp:TemplateField>
               <asp:HyperLinkField DataTextField="title" DataNavigateUrlFields="SubjectId" DataNavigateUrlFormatString="~/Topic/{0}" HeaderText="العنوان"/>
           </Columns>
            
        </asp:GridView>

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        if (Page.RouteData.Values["Id"] != null /*&& Page.RouteData.Values["index"] != null*/)
        {
            int id;
            if (int.TryParse(Page.RouteData.Values["Id"].ToString(), out id) == true /*&& int.TryParse(Page.RouteData.Values["index"].ToString(), out index) == true*/)
            {
                Adapter = new SqlDataAdapter("SELECT Subjects.SubjectId,Subjects.Title,AgePeriods.Period,Users.UserName From Subjects INNER JOIN AgePeriods ON Subjects.AgeId = AgePeriods.AgePeriodId INNER JOIN Users ON Subjects.UserId = Users.UserId WHERE CId = '" + id + "' ORDER BY Subjects.SubjectId DESC ", con);
                Adapter.Fill(ds, "Subjects");
                GridView1.DataSource = ds.Tables["Subjects"];
                GridView1.DataBind();
                for (int i = 0; i < GridView1.Rows.Count; i++)
                {
                    GridView1.Rows[i].Cells[1].Visible = false;
                    GridView1.Rows[i].Cells[2].Visible = false;
                }
            }
            else
            {
                Response.Redirect("homepage.aspx");
            }

        }

    }

}

C#

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {        
        int newPage = e.NewPageIndex;
        GridView1.DataSource = ds.Tables["Subjects"];
        GridView1.DataBind();
    }

paging is enabled, but the problem that when i add binding code into !postback block
paging does not work, either paging or using !postback, i use !postBack to be able to get selected checked checkboxes. Is there possible way to use paging & !postBack ?
thanks in advance

Posted 6-May-13 9:54am

Salah Abualrob

Updated 6-May-13 10:19am

v2

Add a Solution

Comments

Richard C Bishop 6-May-13 16:11pm

Your gridview does not show that paging is enabled.

Salah Abualrob 6-May-13 16:20pm

sorry, i posted it after changing, it's modified now :)

Richard C Bishop 6-May-13 16:22pm

No worries, why are you even using !Page.IsPostBack? You use that if you want to perform something if the page is not posting back. The gridview cannot get updated on the page unless you post back or do an async post back.

Salah Abualrob 6-May-13 16:25pm

their is a checkBox in gridView, when i want to get checked ones, it does not work without using !Page.IsPostBack(), i tried many way but useless !

db7uk 6-May-13 17:12pm

your pageindexchanging does not look right. ds.tables["subjects"]... where is this kept? viewstate, session? at the moment your pageindexchanging just fires a postback and does not bind to the original datasource.

Salah Abualrob 6-May-13 17:16pm

can you help with example ?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

db7uk · Accepted Answer · 2013-05-06T11:25:00

Ok, try:

C#

protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            if (Page.RouteData.Values["Id"] != null /*&& Page.RouteData.Values["index"] != null*/)
            {
                int id;
                if (int.TryParse(Page.RouteData.Values["Id"].ToString(), out id) == true /*&& int.TryParse(Page.RouteData.Values["index"].ToString(), out index) == true*/)
                {
                    Adapter = new SqlDataAdapter("SELECT Subjects.SubjectId,Subjects.Title,AgePeriods.Period,Users.UserName From Subjects INNER JOIN AgePeriods ON Subjects.AgeId = AgePeriods.AgePeriodId INNER JOIN Users ON Subjects.UserId = Users.UserId WHERE CId = '" + id + "' ORDER BY Subjects.SubjectId DESC ", con);
                    Adapter.Fill(ds, "Subjects");
                    GridView1.DataSource = ds.Tables["Subjects"];
                    GridView1.DataBind();

                    // add data to session to persist data
                    Session["SubjectsData"] = ds.Tables["Subjects"];

                    for (int i = 0; i < GridView1.Rows.Count; i++)
                    {
                        GridView1.Rows[i].Cells[1].Visible = false;
                        GridView1.Rows[i].Cells[2].Visible = false;
                    }
                }
                else
                {
                    Response.Redirect("homepage.aspx");
                }
 
            }
 
        }
        
    }

And then in the page index changing method:

C#

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {       
           // set your page index on the grid. you were missing this. The grid did not know which page to navigate to. 
           GridView1.PageIndex = e.NewPageIndex;

           // get your data back out of session.
           GridView1.DataSource = Session["SubjectsData"];
           GridView1.DataBind();
    }