1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

grid view paging not working properly.

Discussion in 'C#' started by jackparsana, Oct 2, 2010.

  1. jackparsana

    jackparsana New Member

    Joined:
    Oct 2, 2010
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    hi,

    Code:
    public void bingdrid()
        {
            cmd.Connection = con;
            cmd.CommandText = "SELECT     Customer.* , convert(varchar(50),StarteTime,103),convert(varchar(50),EndTime,103), CompanyMaster.Name, Country.CountryName, City.CityName, State.StateName " +
                        "FROM  Customer INNER JOIN "+
                         " CompanyMaster ON Customer.CompanyID = CompanyMaster.CompanyID INNER JOIN "+
                         " City ON Customer.CityID = City.CityID INNER JOIN "+
                          "Country ON Customer.CountryID = Country.CountryID INNER JOIN "+
                          "State ON Customer.StateID = State.StateID AND City.StateID = State.StateID AND Country.CountryID = State.CountryID ";
            da.SelectCommand = cmd ;
            da.Fill(ds);
            grvCusto.DataSource = ds;
            grvCusto.DataBind();
           
        }
    
    
    
    
    
    
    
    
    
     protected void grvCusto_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            grdstate.PageIndex = e.NewPageIndex;
            bingdrid();
        }
    
    
    there is problem in this..
    paging of grid is not working properly.


    thanks in advance.


    jack
     

Share This Page