Bind, Sort & Paging a GridView from Class

Question

Im working on a class to databind my GridView's in C#...

I've made it so my pager works, but not sure how i would go about making my sorting work... So far my code looks like this:

public static class Binder
{
public class gridView {
    public static void Bind(GridView grid, IList source, bool pager, bool sorting) {
        grid.DataSource = source;
        if (pager) {
            grid.PageIndexChanging += new GridViewPageEventHandler(PageIndexChanging);
        }
        if (sorting) {
            grid.Sorting += new GridViewSortEventHandler(Sorting);
        }
        grid.DataBind();
    }

    public static void PageIndexChanging(object sender, GridViewPageEventArgs e) {
        if (sender != null) {
            GridView GridView1 = sender as GridView;
            GridView1.PageIndex = e.NewPageIndex;
            GridView1.DataBind();
        }
    }
    public static void Sorting(object sender, GridViewSortEventArgs e) {
        if (sender != null) {
            GridView GridView1 = sender as GridView;
            //What to do?
            GridView1.DataBind();
        }
    }
}
}

And i would bind a gridview like this: Binder.gridView.Bind(MyGridView, MyDataSource, true, true);

But im kinda lost on how to make the sorting work?

Just thought that would be a nice way? But any suggestions are welcome :) — Christian Bekker, Mar 14 '13 at 12:03
Basically you need to sort your data source and rebind. This probably points you to your solution: http://stackoverflow.com/questions/3966835/sorting-gridview?rq=1 — Tim Hobbs, Mar 14 '13 at 12:05
But the idea was later to have Repeater class inside.. so i could call Binder.Repeater.Bind(); — Christian Bekker, Mar 14 '13 at 12:07

J.Starkl · Accepted Answer · 2013-03-14T12:09:45.643

0

You need to enable Sorting in your aspx - AllowSorting="True"

<asp:GridView ID="grid" runat="server" DataKeyNames="id" AutoGenerateColumns="False"
                AllowPaging="True" AllowSorting="True" PageSize="25" CellPadding="4" BorderStyle="None"
                OnRowDataBound="gvProfileSearch_RowDataBound" Width="100%" Translate="true">

For the IList you can use the OrderBy-Function

IList<T> tmp = new IList<T>();
tmp.OrderByDescending...
tmp.OrderBy...

edited Mar 14 '13 at 12:09

answered Mar 14 '13 at 12:01

J.Starkl

2,183
1
13
15

Well clearly :) but its the code to do the sorting where i need help. – Christian Bekker Mar 14 '13 at 12:04
OrderBy return a Enumerable list, and then i get error that i doesnt support serverside paging... – Christian Bekker Mar 14 '13 at 12:56

score 0 · Answer 2 · answered Apr 16 '13 at 09:38

This code for binding,paging and sorting........

 protected void RadgvData_SortCommand(object sender, GridSortCommandEventArgs e)
        {
            GridTableView tableView = e.Item.OwnerTableView;
            e.Canceled = true;
            GridSortExpression expression = new GridSortExpression();
            expression.FieldName = e.SortExpression;
            if (tableView.SortExpressions.Count == 0 || tableView.SortExpressions[0].FieldName != e.SortExpression)
            {
                expression.SortOrder = GridSortOrder.Descending;
            }
            else if (tableView.SortExpressions[0].SortOrder == GridSortOrder.Descending)
            {
                expression.SortOrder = GridSortOrder.Ascending;
            }
            else if (tableView.SortExpressions[0].SortOrder == GridSortOrder.Ascending)
            {
                expression.SortOrder = GridSortOrder.Descending;
            }

            tableView.SortExpressions.AddSortExpression(expression);
            RadgvData.Rebind();

        }

        protected void RadgvData_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
        {
            try
            {
                DataTable dtData = objCutTypeBAL.getCutTypeDetail(string.Empty);
                if (dtData.Rows.Count > 0)
                {
                    RadgvData.DataSource = dtData;
                }
                else
                {
                    RadgvData.DataSource = String.Empty;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        protected void RadgvData_ItemDataBound(object sender, GridItemEventArgs e)
        {
            if (e.Item is GridPagerItem)
            {
                RadgvData.PagerStyle.AlwaysVisible = true;
            }
            if (e.Item is GridDataItem && e.Item.OwnerTableView.DataMember != "ChildCutType")
            {
                GridDataItem dataitem = (GridDataItem)e.Item;

                ImageButton imgDel = (ImageButton)dataitem["Delete"].Controls[0];
                string strCutType;
                strCutType = dataitem.GetDataKeyValue("CutType").ToString();
                DataTable dtData = objCutTypeBAL.getCutTypeDetail(strCutType);
                if (dtData.Rows.Count > 0)
                {
                    imgDel.Visible = false;
                }
            }
        }

        protected void RadgvData_PageIndexChanged(object sender, GridPageChangedEventArgs e)
        {
            RadgvData.CurrentPageIndex = e.NewPageIndex;
            popGrid();
        }

Bind, Sort & Paging a GridView from Class

2 Answers2