How to do sorting and paging on gridview in .net 4.0 using linq datasource?

[EDN Admin]

I am not able to do paging and sorting on normal gridview just because im passing linq var as datasource to gridview . It gives error
<h1> http://stackoverflow.com/questions/1661292/the-data-source-does-not-support-server-side-data-paging <span style="color:#000000 The data source does not support server-side data paging. </h1>
<div style="background-color:white; color:black
<pre><span style="color:blue protected <span style="color:blue void Page_Load(<span style="color:blue object sender, EventArgs e)
{
<span style="color:blue if (!IsPostBack)
{
bindGrid();
}
}


<span style="color:blue public <span style="color:blue void bindGrid()
{
RecommendationCategoryController _recCatController = <span style="color:blue new RecommendationCategoryController();

<span style="color:blue var recQuery = <span style="color:blue from d <span style="color:blue in _recCatController.GetRecomCatagory()
<span style="color:blue orderby d.RecomCategory_Id
<span style="color:blue select <span style="color:blue new { d.RecomCategory_Id, d.RecomCategory_Code, d.RecomCategory_Desc, d.RecomCategory_IsActive };

grdRecCategory.DataSource = recQuery;
grdRecCategory.DataBind();
}


<span style="color:blue protected <span style="color:blue void btnSearch_Click(<span style="color:blue object sender, EventArgs e)
{

RecommendationCategoryController _recCatController = <span style="color:blue new RecommendationCategoryController();
<span style="color:blue var recommendationQuery = <span style="color:blue from d <span style="color:blue in _recCatController.GetRecomCatagory()

<span style="color:blue orderby d.RecomCategory_Id



<span style="color:blue where ((d.RecomCategory_Code.ToLower().Contains(txtCode.Text.ToLower())) || (txtCode.Text.ToString() == <span style="color:#a31515 ""))
&&
((d.RecomCategory_Desc.ToLower().Contains(txtCategory.Text.ToLower())) || (txtCategory.Text == <span style="color:#a31515 ""))
&&
((rdoStatus.SelectedItem.Value == <span style="color:blue null) || (rdoStatus.SelectedItem.Value == <span style="color:#a31515 "2") || (d.RecomCategory_IsActive == Convert.ToBoolean(rdoStatus.SelectedItem.Value)))

<span style="color:blue select <span style="color:blue new { d.RecomCategory_Id, d.RecomCategory_Code, d.RecomCategory_Desc, d.RecomCategory_IsActive }

;
<span style="color:blue this.grdRecCategory.DataSource = recommendationQuery;
<span style="color:blue this.grdRecCategory.DataBind();
}


<span style="color:blue protected <span style="color:blue void grdRecCategory_Sorting(<span style="color:blue object sender, GridViewSortEventArgs e)
{
Response.Write(grdRecCategory.DataSource.GetType());
<span style="color:blue var var1 = grdRecCategory.DataSource;
DataTable data = var1 <span style="color:blue as DataTable;

<span style="color:blue if (data != <span style="color:blue null)
{
DataView dataView = <span style="color:blue new DataView(data);
dataView.Sort = e.SortExpression + <span style="color:#a31515 " " + ConvertSortDirectionToSql(e.SortDirection);

grdRecCategory.DataSource = dataView;
grdRecCategory.DataBind();
}


}

<span style="color:blue private <span style="color:blue string ConvertSortDirectionToSql(SortDirection sortDirection)
{
<span style="color:blue string newSortDirection = String.Empty;

<span style="color:blue switch (sortDirection)
{
<span style="color:blue case SortDirection.Ascending:
newSortDirection = <span style="color:#a31515 "ASC";
<span style="color:blue break;

<span style="color:blue case SortDirection.Descending:
newSortDirection = <span style="color:#a31515 "DESC";
<span style="color:blue break;
}
<span style="color:blue return newSortDirection;
}


<span style="color:blue protected <span style="color:blue void grdRecCategory_PageIndexChanging(<span style="color:blue object sender, GridViewPageEventArgs e)
{
grdRecCategory.PageIndex = e.NewPageIndex;
bindGrid();

}
[/code]




View the full article