grid view page number not working

Question

1.00/5 (2 votes)

See more:

Hi,
I am binding the gridview with different conditions. Page numbers are showing on grid view but on clicking nothing happens.
How to define logic in GridView1_PageIndexChanging event?

My code is as follow:

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

public partial class Main : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection();
    SqlCommand com = new SqlCommand();
    SqlDataAdapter da = new SqlDataAdapter();
    DataSet ds = new DataSet();


    protected void Page_Load(object sender, EventArgs e)
    {
        con.ConnectionString = "server = 10.139.244.22; initial catalog = Connectivity_Status; user id = sa; password = foRest4321";
        con.Open();
        if (!IsPostBack)
        {

            FillCircle(ddlCircle);

        }

    }

    protected void ddlCircle_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddlCircle.SelectedValue == "1")
            BindGridAll();
        else
            GridView1.DataSource = ds.Tables;
        GridView1.DataBind();
        FillDivision(ddlCircle.SelectedValue.ToString());
    }

    protected void ddlDivision_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddlDivision.SelectedValue == "1")
            BindGridDivisionAll(ddlCircle.SelectedValue.ToString());
        else
            GridView1.DataSource = ds.Tables;
        GridView1.DataBind();
        FillRange(ddlDivision.SelectedValue.ToString());
    }

    protected void ddlRange_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddlRange.SelectedValue == "1")
            BindGridRangeAll(ddlDivision.SelectedValue.ToString());
        else
            GridView1.DataSource = ds.Tables;
        GridView1.DataBind();
        BindGrid(ddlRange.SelectedValue.ToString());
    }

    protected void FillCircle(DropDownList ddlCircle)
    {
        try
        {
            com.CommandText = "SELECT [CIRCLE_ID],[CIRCLE_ENAME] FROM [Connectivity_Status].[dbo].[mCircle] ";
            com.Connection = con;
            da.SelectCommand = com;
            da.Fill(ds, "C");


            ddlCircle.DataSource = ds.Tables["C"];
            ddlCircle.DataTextField = "CIRCLE_ENAME";
            ddlCircle.DataValueField = "CIRCLE_ID";
            ddlCircle.DataBind();

            ListItem lstTemp6 = new ListItem("--Select--", "0");
            ddlCircle.Items.Insert(0, lstTemp6);
            ListItem lstTemp7 = new ListItem("All", "1");
            ddlCircle.Items.Insert(1, lstTemp7);

            ddlCircle.SelectedIndex = 0;
            da.Dispose();
        }
        catch (Exception ex)
        {
        }
        finally
        {
        }
    }



    protected void FillDivision(string value)
    {
        try
        {
            com.CommandText = "SELECT [CIRCLE_ID],[DIV_ID],[DIV_ENAME] FROM [Connectivity_Status].[dbo].[mDIVISION] where CIRCLE_ID = " + value + " ";
            com.Connection = con;
            da.SelectCommand = com;
            da.Fill(ds, "C");


            ddlDivision.DataSource = ds.Tables["C"];
            ddlDivision.DataTextField = "DIV_ENAME";
            ddlDivision.DataValueField = "DIV_ID";
            ddlDivision.DataBind();

            ListItem lstTemp8 = new ListItem("--Select--", "0");
            ddlDivision.Items.Insert(0, lstTemp8);
            ListItem lstTemp9 = new ListItem("All", "1");
            ddlDivision.Items.Insert(1, lstTemp9);
            ddlDivision.SelectedIndex = 0;
            da.Dispose();
        }
        catch (Exception ex)
        {
        }
        finally
        {
        }
    }


    protected void FillRange(string value)
    {
        try
        {
            com.CommandText = "SELECT  [RANGE_ID],[Div_id],[RANGE_ENAME] FROM [Connectivity_Status].[dbo].[mRANGE] where Div_id = " + value + " ";
            com.Connection = con;
            da.SelectCommand = com;
            da.Fill(ds, "C");



            ddlRange.DataSource = ds.Tables["C"];
            ddlRange.DataTextField = "RANGE_ENAME";
            ddlRange.DataValueField = "RANGE_ID";
            ddlRange.DataBind();

            ListItem lstTemp10 = new ListItem("--Select--", "0");
            ddlRange.Items.Insert(0, lstTemp10);
            ListItem lstTemp11 = new ListItem("All", "1");
            ddlRange.Items.Insert(1, lstTemp11);
            ddlRange.SelectedIndex = 0;
            da.Dispose();
        }
        catch (Exception ex)
        {
        }
        finally
        {
        }
    }
    protected void BindGrid(string value)
    {
        try
        {
            com.CommandText = ("select I_Info.RANGE_ID, mRANGE.RANGE_ENAME,I_Info.INTERNET_TYPE,I_Info.INTERNET_STATUS from Connectivity_Status.dbo.I_Info,Connectivity_Status.dbo.mRANGE where Connectivity_Status.dbo.I_Info.RANGE_ID=Connectivity_Status.dbo.mRANGE.RANGE_ID And Connectivity_Status.dbo.I_Info.RANGE_ID= " + value + "  ORDER BY RANGE_ENAME");
            com.Connection = con;
            da.SelectCommand = com;
            da.Fill(ds, "R");

            GridView1.DataSource = ds.Tables["R"];
            GridView1.DataBind();
            da.Dispose();

        }
        catch (Exception ex)
        {
        }
        finally
        {
        }

    }
    protected void BindGridAll()
    {
        try
        {
            com.CommandText = ("select I_Info.RANGE_ID, mRANGE.RANGE_ENAME,I_Info.INTERNET_TYPE,I_Info.INTERNET_STATUS from Connectivity_Status.dbo.I_Info,Connectivity_Status.dbo.mRANGE where Connectivity_Status.dbo.I_Info.RANGE_ID=Connectivity_Status.dbo.mRANGE.RANGE_ID ORDER BY I_Info.CIRCLE_ID,I_Info.DIV_ID,I_Info.RANGE_ID");
            com.Connection = con;
            da.SelectCommand = com;
            da.Fill(ds, "R");

            GridView1.DataSource = ds.Tables["R"];
            GridView1.DataBind();
            da.Dispose();
        }
        catch (Exception ex)
        {
        }
        finally
        {
        }

    }

    protected void BindGridDivisionAll(string value)
    {
        try
        {
            com.CommandText = ("select distinct I_Info.RANGE_ID, mRANGE.RANGE_ENAME,I_Info.INTERNET_TYPE,I_Info.INTERNET_STATUS from Connectivity_Status.dbo.I_Info,Connectivity_Status.dbo.mRANGE,Connectivity_Status.dbo.mDIVISION where Connectivity_Status.dbo.I_Info.RANGE_ID=Connectivity_Status.dbo.mRANGE.RANGE_ID and Connectivity_Status.dbo.mRANGE.DIV_ID = Connectivity_Status.dbo.mDIVISION.DIV_ID and Connectivity_Status.dbo.I_Info.CIRCLE_ID = " + value + " ORDER BY RANGE_ENAME");
            com.Connection = con;
            da.SelectCommand = com;
            da.Fill(ds, "R");

            GridView1.DataSource = ds.Tables["R"];
            GridView1.DataBind();
            da.Dispose();

        }
        catch (Exception ex)
        {
        }
        finally
        {
        }

    }

    protected void BindGridRangeAll(string value)
    {
        try
        {
            com.CommandText = ("select distinct I_Info.RANGE_ID, mRANGE.RANGE_ENAME,I_Info.INTERNET_TYPE,I_Info.INTERNET_STATUS from Connectivity_Status.dbo.I_Info,Connectivity_Status.dbo.mRANGE,Connectivity_Status.dbo.mDIVISION where Connectivity_Status.dbo.I_Info.RANGE_ID=Connectivity_Status.dbo.mRANGE.RANGE_ID and Connectivity_Status.dbo.mRANGE.Div_id  = Connectivity_Status.dbo.mDIVISION.DIV_ID and Connectivity_Status.dbo.I_Info.DIV_ID = " + value + " ORDER BY RANGE_ENAME");
            com.Connection = con;
            da.SelectCommand = com;
            da.Fill(ds, "R");

            GridView1.DataSource = ds.Tables["R"];
            GridView1.DataBind();
            da.Dispose();
        }
        catch (Exception ex)
        {
        }
        finally
        {
        }
    }
 protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        //BindGrid(Session["Language"].ToString());
      BindGridAll();
        //BindGridDivisionAll(Session["Language"].ToString());
        //BindGridRangeAll(Session["Language"].ToString());
    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                if (((Label)e.Row.FindControl("lblINTERNET_STATUS")).Text != " ")     
                {
                    if (((Label)e.Row.FindControl("lblINTERNET_STATUS")).Text == "not working")
                    {
                        e.Row.Cells[3].BackColor = System.Drawing.Color.Crimson;
                    }
                    else
                    {
                        e.Row.Cells[3].BackColor = System.Drawing.Color.Green;
                    }
                }
            }
        }
    }
}

Posted 6-Aug-13 1:31am

ruby kaur

Updated 6-Aug-13 2:09am

Ankur^\m/

v4

Add a Solution

Comments

Ankur^\m/ 6-Aug-13 7:37am

This is a code dump. Please see the guidelines before you ask a question.
Put a debugger and seed what's wrong with the code. See if the code is executed or not. If yes, is there an exception or the logic is failing somewhere. When you have the specifics and are still not able to solve the issue, post that here.

Use 'Improve Question' to update the question with just the necessary details.

Harshil_Raval 6-Aug-13 7:50am

Agree with you. And other things is what you mean by gridview page number? Are you talking about paging?

Thanks7872 6-Aug-13 8:06am

Post only the code where you are binding the gridview and the page index changing method. Remove unnecessary code in order to make some one understand the code and rectify it.

Thanks7872 6-Aug-13 8:08am

One thing i noted here is you used try catch just to hide errors. If you remove that,i think error will be more self explanatory.

Ankur^\m/ 6-Aug-13 8:10am

@RelicV - When you are editing a question, be sure it edit it correctly. See the preview of your edit and if you are not getting it correctly, please leave it.

Thanks7872 6-Aug-13 8:23am

Some times it happens that the code dump is so lengthy and tags are replaced by characters. In that case it is very difficult to assume it as well as sometimes preview gets hang,so i think editing again is the only way in such scenarios.

Ankur^\m/ 6-Aug-13 8:31am

In those cases, just leave it as it is and someone else will do it. Editing brings the question up in the queue and shouldn't be done again and again. In this case, RelicV edited it twice and that too incorrectly.

Thanks7872 6-Aug-13 8:33am

When we edit it,we dont know what went wrong. Once we press update button.then only we come to know. And when we try again then its possible that we get another member editing it so not able to do so(like i faced it while you were editing).

Ankur^\m/ 6-Aug-13 9:56am

The preview was brought for this very reason. Again as I said before, if it doesn't work or you do not understand what's wrong, leave it. Someone else who knows better will do it.

Thanks7872 7-Aug-13 0:07am

The editing in the first place is just help to the OP. The member who tried to edit had made it readable at least to some extent. Its not like that the question 'should be' formatted 100% correct and the way you think so. If you have problem,then cp has given you the rights to do so. Do it by your self. You can comment the editor if he removed something or changed the meaning of the question. He has worked according to guid lines.

You said Editing brings the question up in the queue ,dont you see new button on top of the list,try it and see what happens.

Ankur^\m/ 7-Aug-13 2:18am

I am implying that edits shouldn't be done again and again as it brings the question up in the queue. If you are editing, edit is correctly or just leave it. As far as I know the problem of multiple edits was one of the reason 'Preview' feature was brought in so that it can be avoided.
The editor has recently got editing rights. Most such people do multiple edits to earn more reputation points.

Thanks7872 7-Aug-13 2:33am

Most people are not that cheap to earn reputation points.And what you mean by The editor has recently got editing rights?.So what?CP has given him a right to do so. You should not have any objections regarding the same.Do you mean that he should not use that right until 6 or 7 months or so? What do you want to point at? I think you dont have knowledge about member reputation system.

http://www.codeproject.com/script/Membership/Reputation.aspx#Editor

If you are editing, edit is correctly. He did. He didnt do anything incorrect.

Every member edits at the best he can. If i find something wrong than i do the same,this can also make it up in the queue.If you are afraid of question coming up in the queue due to editing,use new button than.This baseless statements wont help you much in this regard.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 6-Aug-13 8:24am

Please debug and see what is happening... Whether clicking on the page number fires the event or not.

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)