display the number of rows in a gridview on dropdownlist selection

Question

5.00/5 (1 vote)

See more:

hello GoodMorning,
i am trying to display the number of rows in a gridview on dropdownlist selection.But the problem i
am facing is that on page load for the first time its showing relevent result but on selecting some other value from the DDL Grid view is not iterating.
Please help me with this..??
here is the code:
in .aspx i have taken 1 DDL and 1 Grid view
in code behing:

C#

public partial class GridViewDemo : System.Web.UI.Page
{
    private void BindGridView1()
    {
        try
        {
            this.GridView1.DataSource = ProjectManager.GetHoodListing();
            this.GridView1.DataBind();
        }
        catch (Exception ex)
        { throw ex; }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (!IsPostBack)
            {
                BindGridView1();
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        GridView1.PageSize = Convert.ToInt32(DropDownList1.SelectedValue);
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataBind();
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        try
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {

            }
        }
        catch (Exception ex)
        { throw ex; }
    }
**************************************************
// project manager class

 public static DataTable GetHoodListing()
    {
        DataAccess objDA = new DataAccess();
        DataTable objDT = new DataTable();
        string strSql = "";
        try
        {
            strSql = string.Format("SELECT HLID, HLSeries, HLStyle, HLCanopProfile FROM HoodListing");
            objDT = objDA.ExecuteDataTable(strSql);
        }
        catch (SqlException sqlex)
        { throw sqlex; }
        catch (Exception ex)
        { throw ex; }

        return objDT;
    }

Posted 30-May-12 18:51pm

saurabh kumar mahto

Updated 30-May-12 19:00pm

codeBegin

v2

Add a Solution

2 solutions

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)

Bhargava Katta · Accepted Answer · 2012-05-30T18:59:00

Solution 1

include BindGridView1(); in GridView1_PageIndexChanging event.
u will get it.

Posted 30-May-12 18:59pm

Bhargava Katta

Comments

saurabh kumar mahto 31-May-12 1:36am

thanks a lot Bhargava..for your great support..
its working.

saurabh kumar mahto 31-May-12 2:40am

Hi,
everything is working fine but a small issue here is that when i click any umber in DDL its not iterating the Gridview on postback,and i have to click on page index for chage reflection.?
i want it to reflect on immediate postback..

Sandeep Mewara · Accepted Answer · 2012-05-30T19:31:00

You forgot to redefine DataSource in your PageIndexChanging event.

Modify your code to:

C#

// Pagesize set at the time of binding
private void BindGridView1()
{
        try
        {
            this.GridView1.DataSource = ProjectManager.GetHoodListing();
            this.GridView1.DataBind();

            if(Convert.ToInt32(DropDownList1.SelectedValue) != null)
              GridView1.PageSize = Convert.ToInt32(DropDownList1.SelectedValue);
        }
        catch (Exception ex)
        { throw ex; }
}

// page changed and grid rebind to reflect change
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
        GridView1.PageIndex = e.NewPageIndex;
        BindGridView1();
}

//To set grid with defined page as per set
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
       BindGridView1();
}