Today I have a simple requirement, to achieve filtering and sorting on a simple grid.
Asp.Net GridView do not have an option to filter by default but where as SPGridView provides as part of the control.
I have simple method, that will form the data into DataTable which will be set as datasource to SPGridView as shown in below code.
<SharePoint:SPGridView runat="server" ID="reportsList" AutoGenerateColumns="false"PageSize="1" AllowPaging="false"
AllowSorting="true" AllowFiltering="false" FilterDataFields="Col1,Col2,Col3,Col4" >
<Columns>
<asp:TemplateField HeaderText="Col1" SortExpression="Col1">
<ItemTemplate>
<asp:HyperLink ID="Col1Link" runat="server" Text='<%# Eval("Col1") %>'NavigateUrl= '<%# Eval("Col5") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Col2" SortExpression="Col2">
<ItemTemplate>
<asp:HyperLink ID="TabLink" runat="server" Text='<%# Eval("Col2") %>'NavigateUrl= '<%# Eval("Col6") %>' />
</ItemTemplate>
</asp:TemplateField>
<SharePoint:SPBoundField HeaderText="Col3" SortExpression="Col3" DataField="Col3" />
<SharePoint:SPBoundField HeaderText="Col4" SortExpression="Col4" DataField="Col4" />
</Columns>
<EmptyDataTemplate> No data.</EmptyDataTemplate>
</SharePoint:SPGridView>
above markup is also an example for binding hyperlink fields in spgridview.
protected override void CreateChildControls()
{
base.CreateChildControls();
using (SPSite site = new SPSite(SPContext.Current.Site.Url))
{
using (SPWeb web = site.OpenWeb())
{
// bind the datasource to grid
reportsList.DataSource = GetMyDataTable();
reportsList.DataBind();
}
}
}
So easy and simple to see the grid populated with data on the page, but when I choose to sort a column I get the below error .
The GridView 'GridViewID' fired event Sorting which wasn't handled
Googling around I found that property, DataSourceID need to set instead of setting DataSource. Not sure why.
So now I have to rewrite the code and bind some type of datasource(objectdatasource/SPdatasources/…/).
As we know, ObjectDataSource is simple and easy I started with it and then lately realized that I have to create objects, I mean new type that will be used by ObjectDataSource as suggested by all other blogs.
But I do not want to write extra code but directly bind the existing datatable as objectdatasource for which blogs suggest to create type and write a method that will convert it to datatable which seem to be round way for me.
So I tried the below code and able to achieve sorting without a new Type/object definition. Still i could not get filtering work..at least it did not throw any error in log or on page.
//populate the datasource
ObjectDataSource reportsDataSource = new ObjectDataSource();
reportsDataSource.ID = "reportsDataSource";
reportsDataSource.SelectMethod = "GetMyDataTable";
reportsDataSource.TypeName = this.GetType().AssemblyQualifiedName;
this.Controls.Add(reportsDataSource);
// bind the datasource to grid
reportsList.DataSourceID = "MyDataSource";// =
reportsList.DataBind();
