Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

GridView Sorting Issue without using a datasource

  • 05-04-2007 12:43PM
    #1
    Registered Users, Registered Users 2 Posts: 546 ✭✭✭


    Hi Folks,

    I have a gridview that doesn't use a datasource so have to write my own paging and sorting methods. I got the paging working but having no luck with the sorting. Any feedback would be great on what to put in this method to get it working
    protected void CompaniesGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {   
        CompaniesGridView.PageIndex = e.NewPageIndex;
        CompaniesGridView.DataSource = GetDataSource();
    }
    
    private DataSet GetDataSource()
    {
        string _connString = ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString;
        ICompanyCollection coll = (ICompanyCollection)new CompanyCollection(_connString);
        // TODO: Pass a proper usrId to this method
        CompanySearchDataSet ds = coll.Find(0, CompanyNameTextBox.Text);
        CompaniesGridView.DataSource = ds;
        CompaniesGridView.DataBind();
        return ds;
    }
    
    protected void CompaniesGridView_Sorting(object sender, GridViewSortEventArgs e)
    {
        GridViewSortExpression = e.SortExpression;
        int pageIndex = CompaniesGridView.PageIndex;
        CompaniesGridView.DataSource = GetDataSource();        
        CompaniesGridView.PageIndex = pageIndex;
    }
    


Advertisement