GridView Sorting Issue without using a datasource

gaillimhabu

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;
}