page numbers for grid view control in the web page using asp.net?

See more:

ASP.NET

Dear All,

page numbers for grid view control using asp.net

here we use two drop down list boxes and one grid view

and once select cars in dropdownlist1 display all cars details in grid view and drop down list2 also select high to low and low to high select any one will display records in gridview control displaying output properly but page numbers is not working properly

here below design and code please check reply this way correct or not and any another way please reply me


design:

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

public partial class Cars : System.Web.UI.Page
{
    SqlCommand cmd = new SqlCommand();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            LoadData();
            BindGridView();
            PriceList();
        }
    }
    private void LoadData()
    {
        string constr = "Data Source=pmnb3-PC;Database=Save;user id=sa;password=123;";
        string query = "SELECT ID, Name, Address, Email, Mobile, Category,Price FROM PostTable";

        SqlDataAdapter da = new SqlDataAdapter(query, constr);
        DataTable table = new DataTable();
        da.Fill(table);
        GridView1.DataSource = table;
        GridView1.DataBind();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        LoadData();
        BindGridView();
        PriceList();
    }
    protected void BindGridView()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

        if (DropDownList1.SelectedItem.Text == "Cars")
        {
            cmd = new SqlCommand("Select * From PostTable where Category='Cars'", con);
        }
        else if (DropDownList1.SelectedItem.Text == "Mobiles")
        {
            cmd = new SqlCommand("select * from PostTable where Category='Mobiles'", con);
        }
        else if (DropDownList1.SelectedItem.Text == "--Select--")
        {
            cmd = new SqlCommand("select * from PostTable", con);
        }

        SqlDataAdapter adap = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        adap.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        BindGridView();
    }
    protected void PriceList()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

        if (DropDownList2.SelectedItem.Text == "Price: High To Low")
        {
            cmd = new SqlCommand("Select * From PostTable order by price desc", con);
        }
        else if (DropDownList2.SelectedItem.Text == "Price: Low To High")
        {
            cmd = new SqlCommand("select * from PostTable order by price asc", con);
        }
        else if (DropDownList2.SelectedItem.Text == "Most Recently Ads")
        {
            cmd = new SqlCommand("select * from PostTable order by id desc", con);
        }

        SqlDataAdapter adap = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        adap.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
    }
    protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
    {
        PriceList();
    }
}