I am trying to Implement Sorting & Filtering properties on Gird . I am able to do Sorting but not Filtering.
For this I wrote the code as follows
.aspx:-
<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<!-- content start -->
<telerik:RadAjaxManager ID="RadAjaxManager2" DefaultLoadingPanelID="RadAjaxLoadingPanel1"
runat="server">
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="RadGrid1">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RadGrid1" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Height="75px"
Width="75px" Transparency="5">
<img style="margin-top: 150px;" alt="Loading..." src='<%= RadAjaxLoadingPanel.GetWebResourceUrl(Page, "Telerik.Web.UI.Skins.Default.Ajax.loading4.gif") %>' />
</telerik:RadAjaxLoadingPanel>
<telerik:RadGrid ID="RadGrid1" ShowGroupPanel="True" AllowFilteringByColumn="True"
Skin="Mac" runat="server" AllowPaging="True" AllowCustomPaging="True" PageSize="5"
VirtualItemCount="100" ForeColor="White" OnGroupsChanging="RadGrid1_GroupsChanging"
OnNeedDataSource="RadGrid1_NeedDataSource" AllowSorting="True" GridLines="None">
<%--<MasterTableView VirtualItemCount="25" />--%>
<FooterStyle ForeColor="#FF3300" />
<PagerStyle Mode="Slider"></PagerStyle>
</telerik:RadGrid>
</div>
Aspx.cs:-
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=Pubs;trusted_connection=true");
SqlDataAdapter dap = new SqlDataAdapter("select * from authors", con);
DataSet ds = new DataSet();
dap.Fill(ds, "authors");
this.RadGrid1.DataSource = ds.Tables[0];
this.RadGrid1.DataBind();
}
protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
MyBusinessObjectCollection MyBusinessObjectCollection1 = new MyBusinessObjectCollection();
int startRowIndex = (ShouldApplySortFilterOrGroup()) ? 0 : RadGrid1.CurrentPageIndex * RadGrid1.PageSize;
int maximumRows = (ShouldApplySortFilterOrGroup()) ?
MyBusinessObjectCollection1.SelectCount() : RadGrid1.PageSize;
RadGrid1.AllowCustomPaging = !ShouldApplySortFilterOrGroup();
RadGrid1.DataSource = MyBusinessObjectCollection1.Select(startRowIndex, maximumRows);
}
bool isGrouping = false;
public bool ShouldApplySortFilterOrGroup()
{
return RadGrid1.MasterTableView.FilterExpression != "" ||
(RadGrid1.MasterTableView.GroupByExpressions.Count > 0 || isGrouping) ||
RadGrid1.MasterTableView.SortExpressions.Count > 0;
}
protected void RadGrid1_GroupsChanging(object source, GridGroupsChangingEventArgs e)
{
isGrouping = true;
if (e.Action == GridGroupsChangingAction.Ungroup && RadGrid1.CurrentPageIndex > 0)
{
isGrouping = false;
}
}
In above manner I tried,but no use.
Any one can guide me with simple steps to implement Filtering operations
Thanks,
SRRAO.
<
Columns>
<telerik:GridBoundColumn DataField="DEPARTMENT_CODE_ID" HeaderText="Department" UniqueName="column1">
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn DataField="MODULE_ID" HeaderText="Module" UniqueName="column3">
<EditItemTemplate>
<asp:TextBox ID="MODULE_IDTextBox" runat="server" Text='<%# Bind("MODULE_ID") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<telerik:RadComboBox ID="RadComboBox1" runat="server" Enabled="False" SelectedValue='<%# Eval("MODULE_ID") %>'>
<Items>

| <telerik:AjaxUpdatedControl ControlID="optionsTree" LoadingPanelID="AjaxLoadingPanel1"></telerik:AjaxUpdatedControl> |
function onClientSelectedIndexChanged(sender, eventArgs)
{
var combo = $find("ddlStoreID");
var text = eventArgs.get_item().get_text();
var item = combo.findItemByvalue(text);
I have a simple page where I am dynamically generating columns on the page load event and seting datasource during the need data source event. The initial load works correctly, but after any postback the columns still exist but the header text and datafield properties are empty.
Below is the simpliest example I can make. Any thoughts on why the columns are losing their information?
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
public class DataClass
{
private string _a = "";
private string _b = "";
public string A { get { return this._a; } }
public string B { get { return this._b; } }
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
System.Reflection.PropertyInfo[] fields = typeof(DataClass).GetProperties();
foreach (System.Reflection.PropertyInfo field in fields)
{
GridBoundColumn c = new GridBoundColumn();
c.DataField = field.Name;
c.HeaderText = field.Name;
this.RadGrid1.MasterTableView.Columns.Add(c);
}
}
}
protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
System.Collections.Generic.List<DataClass> results = new System.Collections.Generic.List<DataClass>();
this.RadGrid1.DataSource = results;
}
protected void Button1_Click(object sender, EventArgs e)
{
// Column exist but header text and data field properties are ""
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Test Page</title>
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server" />
<asp:Button ID="Button1" runat="server" Text="Force Postback" onclick="Button1_Click" />
<telerik:RadGrid ID="RadGrid1" runat="server" onneeddatasource="RadGrid1_NeedDataSource" AutoGenerateColumns="false" />
</form>
</body>
</html>