div.RadMenu_Default ul.rmRootGroup
{
background:#344A7C url(App_Themes/Default/images/menu_bg.jpg) top left repeat-x;
border: 0;
}
div.RadMenu_Default .rmHorizontal .rmSeparator
{
width:0px;
border:0px;
}
div.RadMenu_Default .rmRootGroup .rmLink
{
font-weight: bold;
line-height:30px;
font-size: 12pt;
color: #fff;
}
div.RadMenu_Default .rmItem .rmLink:hover,
div.RadMenu_Default .rmItem .rmFocused,
div.RadMenu_Default .rmItem .rmSelected,
div.RadMenu_Default .rmItem .rmExpanded {
background:#344A7C url(App_Themes/Default/images/menu_bg.jpg) top left repeat-x;
border: 0;
color: yellow;
}
/*for subitems */
div.RadMenu_Default ul.rmGroup
{
background:#344A7C url(App_Themes/Default/images/menu_hover.jpg) top left repeat-x;
}
div.RadMenu_Default .rmGroup .rmLink
{
font-weight:normal;
line-height:24px;
font-size: 10pt;
color: red;
}
div.RadMenu_Default .rmGroup .rmItem .rmLink:hover,
div.RadMenu_Default .rmGroup .rmItem .rmFocused,
div.RadMenu_Default .rmGroup .rmItem .rmSelected,
div.RadMenu_Default .rmGroup .rmItem .rmExpanded {
background:#344A7C url(App_Themes/Default/images/menu_bg.jpg) top left repeat-x;
border: 0;
color: yellow;
}
<telerik:RadGrid ID="rgChartOfAccts" runat="server" Skin="Metro" CellSpacing="-1" GridLines="Both" Width="98%" AllowPaging="True"><ClientSettings> <Scrolling AllowScroll="True" SaveScrollPosition="True" UseStaticHeaders="True"></Scrolling></ClientSettings><MasterTableView AutoGenerateColumns="False" DataKeyNames="COA_ID,COA_GL_ACCOUNT" CommandItemDisplay="Top" InsertItemPageIndexAction="ShowItemOnCurrentPage" EditMode="PopUp" Name="ChartOfAccts"> <CommandItemSettings ShowExportToExcelButton="true" ShowRefreshButton="False" AddNewRecordText="Add new Account" /> <RowIndicatorColumn Visible="False"> </RowIndicatorColumn> <ExpandCollapseColumn Created="True"> </ExpandCollapseColumn> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" Exportable="False" HeaderStyle-Width="30px" ColumnGroupName="grpCOA" /> <telerik:GridTemplateColumn HeaderText="Account" UniqueName="COA_GL_ACCOUNT" ColumnGroupName="grpCOA"> <EditItemTemplate> <telerik:RadTextBox ID="txtCOA_Acct" runat="server" Text='<%# Bind("COA_GL_ACCOUNT")%>' Width="490px" MaxLength="150"></telerik:RadTextBox> <asp:RequiredFieldValidator ID="rfvCOA_Acct" runat="server" ErrorMessage="RequiredFieldValidator" ControlToValidate="txtCOA_Acct" Text="*" Font-Size="Small" SetFocusOnError="True"></asp:RequiredFieldValidator> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblCOA_Acct" runat="server" Text='<%# Eval("COA_GL_ACCOUNT")%>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Description" UniqueName="COA_DESCRIPTION" ColumnGroupName="grpCOA"> <EditItemTemplate> <telerik:RadTextBox ID="txtCOA_Desc" runat="server" Text='<%# Bind("COA_DESCRIPTION")%>' Width="490px" MaxLength="150"></telerik:RadTextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblCOA_Desc" runat="server" Text='<%# Eval("COA_DESCRIPTION")%>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Category" UniqueName="COA_CATEGORY" ColumnGroupName="grpCOA"> <EditItemTemplate> <telerik:RadTextBox ID="txtCOA_Cat" runat="server" Text='<%# Bind("COA_CATEGORY")%>' Width="490px" MaxLength="150"></telerik:RadTextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblCOA_Cat" runat="server" Text='<%# Eval("COA_CATEGORY")%>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Contra Account" UniqueName="COA_CONTRA_ACCOUNT" ColumnGroupName="grpCOA"> <EditItemTemplate> <telerik:RadTextBox ID="txtCOA_Contra" runat="server" Text='<%# Bind("COA_CONTRA_ACCOUNT")%>' Width="490px" MaxLength="150"></telerik:RadTextBox> <asp:RequiredFieldValidator ID="rfvCOA_Contra" runat="server" ErrorMessage="RequiredFieldValidator" ControlToValidate="txtCOA_Contra" Text="*" Font-Size="Small" SetFocusOnError="True"></asp:RequiredFieldValidator> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblCOA_Contra" runat="server" Text='<%# Eval("COA_CONTRA_ACCOUNT")%>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridButtonColumn ConfirmText="Delete this Account?" ConfirmDialogType="RadWindow" ColumnGroupName="grpCOA" ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Exportable="False" HeaderStyle-Width="30px" /> </Columns> <DetailTables> <telerik:GridTableView Name="RateTypeAss" CommandItemDisplay="Top" DataSourceID="" EditMode="PopUp" DataKeyNames="RTA_ID" runat="server" Width="100%" BackColor="#FFCC66" AlternatingItemStyle-BackColor="#FFCC66" HeaderStyle-BackColor="#FFCC66" ClientDataKeyNames="RTA_ID,COA_GL_ACCOUNT" AutoGenerateColumns="False" ShowHeadersWhenNoRecords="True" EnableNoRecordsTemplate="True" NoDetailRecordsText="No Associated records to display."> <CommandItemSettings ShowAddNewRecordButton="True" ShowRefreshButton="False" ShowExportToExcelButton="True" AddNewRecordText="Add new Association" /> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="COA_GL_ACCOUNT" MasterKeyField="COA_GL_ACCOUNT" /> </ParentTableRelation> <NoRecordsTemplate>No records to display.</NoRecordsTemplate> <RowIndicatorColumn Visible="False"> </RowIndicatorColumn> <EditFormSettings PopUpSettings-Width="600px" InsertCaption="New Association" PopUpSettings-Modal="True"> <EditColumn ButtonType="ImageButton" /> </EditFormSettings> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" Exportable="False" HeaderStyle-Width="30px" /> <telerik:GridTemplateColumn HeaderText="Account" UniqueName="COA_GL_ACCOUNT"> <EditItemTemplate> <asp:Label ID="lblAcctA" runat="server" Text='<%# Bind("COA_GL_ACCOUNT")%>'></asp:Label> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblAcctB" runat="server" Text='<%# Eval("COA_GL_ACCOUNT")%>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="List Code" UniqueName="RATE_TYPE_LIST_CODE"> <EditItemTemplate> <telerik:RadComboBox ID="cbRTL" runat="server" DataSourceID="linqDS_RTL" DataTextField="RATE_TYPE_LIST_CD" DataValueField="RATE_TYPE_LIST_CD" OnItemDataBound="cbRTL_ItemDataBound" OnSelectedIndexChanged="cbRTL_SelectedIndexChanged" Skin="Metro" SelectedValue='<%#Bind("RATE_TYPE_LIST_CODE")%>' DropDownWidth="520px" Width="100px" HighlightTemplatedItems="True" AutoPostBack="True" BorderStyle="Solid" BorderWidth="1px" BorderColor="Gray" Height="200px" AppendDataBoundItems="True"> <HeaderTemplate> <table cellpadding="1" cellspacing="0" class="Main" width="485px"> <tr> <td class="ComboHeader2" width="85px" style="text-align: left; visibility: visible;">Code</td> <td class="ComboHeader2" width="350px" style="text-align: left; visibility: visible;">Description</td> <td class="ComboHeader2" width="50px" style="text-align: left; visibility: visible;">Type</td> </tr> </table> </HeaderTemplate> <ItemTemplate> <table cellpadding="1" cellspacing="0" class="Main" width="485px"> <tr> <td width="85px" style="text-align: left; visibility: visible;"> <%#DataBinder.Eval(Container.DataItem, "RATE_TYPE_LIST_CD")%> </td> <td width="350px" style="text-align: left; visibility: visible;"> <%#DataBinder.Eval(Container.DataItem, "RATE_TYPE_LIST_DESC")%> </td> <td width="50px" style="text-align: left; visibility: visible;"> <%#DataBinder.Eval(Container.DataItem, "RATE_TYPE_LIST_TYPE")%> </td> </tr> </table> </ItemTemplate> <Items> <telerik:RadComboBoxItem ID="RadComboBoxItem2" runat="server" /> </Items> </telerik:RadComboBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblRTL_Code" runat="server" Text='<%# Eval("RATE_TYPE_LIST_CODE")%>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="List Description" UniqueName="RATE_TYPE_LIST_DESC"> <EditItemTemplate> <telerik:RadTextBox ID="txtRTL_Desc" runat="server" Text='<%# Bind("RATE_TYPE_LIST_DESC")%>' Width="490px" MaxLength="150"></telerik:RadTextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblRTL_Desc" runat="server" Text='<%# Eval("RATE_TYPE_LIST_DESC")%>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Service Category" UniqueName="SCAT_CODE" HeaderStyle-Width="105px"> <EditItemTemplate> <telerik:RadComboBox ID="cbSCAT" runat="server" DataSourceID="linqDS_SCAT" DataTextField="SCAT_TYPE" DataValueField="SCAT_TYPE" Skin="Metro" SelectedValue='<%#Bind("SCAT_CODE")%>' DropDownWidth="520px" Width="100px" HighlightTemplatedItems="True" BorderStyle="Solid" BorderWidth="1px" BorderColor="Gray" Height="200px" AppendDataBoundItems="True" OnDataBound="cbSCAT_DataBound"> <HeaderTemplate> <table cellpadding="1" cellspacing="0" class="Main" width="485px"> <tr> <td class="ComboHeader2" width="85px" style="text-align: left; visibility: visible;">Code</td> <td class="ComboHeader2" width="350px" style="text-align: left; visibility: visible;">Description</td> </tr> </table> </HeaderTemplate> <ItemTemplate> <table cellpadding="1" cellspacing="0" class="Main" width="485px"> <tr> <td width="85px" style="text-align: left; visibility: visible;"> <%# If(Container.DataItem IsNot Nothing, DataBinder.Eval(Container.DataItem, "SCAT_TYPE"), DataBinder.Eval(Container, "Value"))%> </td> <td width="350px" style="text-align: left; visibility: visible;"> <%# If(Container.DataItem IsNot Nothing, DataBinder.Eval(Container.DataItem, "SCAT_DESC"), DataBinder.Eval(Container, "Text"))%> </td> </tr> </table> </ItemTemplate> </telerik:RadComboBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblSCAT" runat="server" Text='<%# Eval("SCAT_CODE")%>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Jurisdiction" UniqueName="JURISDICTION" HeaderStyle-Width="105px"> <EditItemTemplate> <telerik:RadComboBox ID="cbJuris" runat="server" Skin="Metro" SelectedValue='<%#Bind("JURISDICTION")%>' DropDownWidth="50px" Width="50px" HighlightTemplatedItems="True" BorderStyle="Solid" BorderWidth="1px" BorderColor="Gray"> <Items> <telerik:RadComboBoxItem Value="" Text="" Selected="true" /> <telerik:RadComboBoxItem Value="B" Text="B" /> <telerik:RadComboBoxItem Value="L" Text="L" /> <telerik:RadComboBoxItem Value="N" Text="N" /> </Items> </telerik:RadComboBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblRTL_Juris" runat="server" Text='<%# Eval("JURISDICTION")%>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="List Type" UniqueName="RATE_TYPE_LIST_TYPE" HeaderStyle-Width="105px"> <EditItemTemplate> <telerik:RadComboBox ID="cbRTL_Type" runat="server" Skin="Metro" SelectedValue='<%#Bind("RATE_TYPE_LIST_TYPE")%>' DropDownWidth="50px" Width="50px" HighlightTemplatedItems="True" BorderStyle="Solid" BorderWidth="1px" BorderColor="Gray"> <Items> <telerik:RadComboBoxItem Value="" Text="" Selected="true" /> <telerik:RadComboBoxItem Value="D" Text="D" /> <telerik:RadComboBoxItem Value="N" Text="N" /> <telerik:RadComboBoxItem Value="R" Text="R" /> <telerik:RadComboBoxItem Value="S" Text="S" /> <telerik:RadComboBoxItem Value="T" Text="T" /> <telerik:RadComboBoxItem Value="X" Text="X" /> </Items> </telerik:RadComboBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="lblRTL_Type" runat="server" Text='<%# Eval("RATE_TYPE_LIST_TYPE")%>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn Visible="False" EditFormHeaderTextFormat=""> <EditItemTemplate> <asp:Label ID="lblErr" runat="server" Text= Font-Bold="True" ForeColor="Red"></asp:Label> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ConfirmDialogType="RadWindow" ConfirmText="Delete this Association?" ConfirmTitle="Delete" Exportable="False" HeaderStyle-Width="30px" /> </Columns> <AlternatingItemStyle BackColor="#FFCC66" /> <HeaderStyle BackColor="#FFCC66" /> </telerik:GridTableView> </DetailTables> <EditFormSettings PopUpSettings-Width="600px" PopUpSettings-Modal="True" InsertCaption="New Account" PopUpSettings-ShowCaptionInEditForm="False"> <EditColumn ButtonType="ImageButton" /> </EditFormSettings></MasterTableView><ClientSettings> <ClientEvents OnPopUpShowing="PopUpShowing2" /></ClientSettings></telerik:RadGrid>Protected Sub cbSCAT_DataBound(sender As Object, e As EventArgs) Dim combo As RadComboBox = DirectCast(sender, RadComboBox) Dim item As RadComboBoxItem = New RadComboBoxItem("ALL", "XX") combo.Items.Insert(0, item) item.DataBind()End SubHi,
i want to apply client side filtering in rad grid . i am following the below link to achive it.
http://demos.telerik.com/aspnet-ajax/grid/examples/data-binding/client-side/programmatic/defaultcs.aspx
till now what i have done
i have written the java script through webmethod iam calling the servr event
var pageSize; var sortExpressions; var filterExpressions;var currentPageIndex;
function RadGrid3_OnCommand(sender, args)
{
args.set_cancel(true);
pageSize = sender.get_masterTableView().get_pageSize();
sortExpressions = sender.get_masterTableView().get_sortExpressions();
filterExpressions = sender.get_masterTableView().get_filterExpressions();
currentPageIndex = sender.get_masterTableView().get_currentPageIndex();
if (args.get_commandName() === "Filter") {
currentPageIndex = 0;
var sortExpressionsAsSQL = sortExpressions.toString();
}
var tableView = $find("<%= RadGrid3.ClientID %>").get_masterTableView();
pageSize = tableView.get_pageSize();
sortExpressions = tableView.get_sortExpressions();
filterExpressions = tableView.get_filterExpressions();
currentPageIndex = tableView.get_currentPageIndex();
var startIndex = pageSize * currentPageIndex;
PageMethods.GetData(startIndex, pageSize, ahi_event, ahi_state, ahi_userid,filterExpressions.toList(), updateGrid);
}
my c# code is
[WebMethod]
public static List<sku_list> GetData(int startIndex, int pageSize, string ahi_event, string ahi_state, string ahi_userid, List<GridFilterExpression> filterExpressions)
{
List<sku_list> list = new List<sku_list>();
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.AppendLine("DECLARE @startRow int ");
sqlBuilder.AppendLine("SET ROWCOUNT @maximumRows");
sqlBuilder.AppendLine("WITH OrderedEmployees As");
sqlBuilder.AppendLine("(");
string sortExpressions = "";
//List<DbParameter> parameters = new List<DbParameter>();
var conString = System.Configuration.ConfigurationManager.ConnectionStrings["Amscan-ProdConnectionString"];
// string commandString = "SELECT * FROM Artwork_sku where ahi_event_name='" + startIndex + "' and state='" + maximumRows + "'";
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Amscan-ProdConnectionString"].ConnectionString))
{
SqlCommand command = new SqlCommand("SP_AHI_SKULIST", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@USERID", SqlDbType.VarChar).Value = ahi_userid;
command.Parameters.Add("@EVENAME", SqlDbType.VarChar).Value = ahi_event;
command.Parameters.Add("@STATE", SqlDbType.VarChar).Value = ahi_state;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
try
{
while (reader.Read())
{
sku_list newObject = new sku_list();
newObject.userid = reader[0].ToString();
newObject.Item = reader[1].ToString();
Topvalue = newObject.Item;
newObject.event_name = reader[2].ToString();
newObject.Description = reader[3].ToString();
newObject.Is_New = reader[4].ToString();
newObject.State = reader[5].ToString();
list.Add(newObject);
}
int counter = 0;
List<DbParameter> parameters = new List<DbParameter>();
if (filterExpressions.Count > 0)
sqlBuilder.Append(" WHERE ");
foreach (GridFilterExpression expression in filterExpressions)
{
counter++;
Pair parameter = BuildParameter(expression);
parameters.Add((DbParameter)parameter.Second);
sqlBuilder.AppendFormat((string)parameter.First);
if (counter < filterExpressions.Count)
{
sqlBuilder.AppendFormat(" And ");
}
}
parameters.ForEach(
delegate(DbParameter parameter)
{
if (parameter != null)
command.Parameters.Add(parameter);
}
);
}
finally
{
reader.Close();
}
}
return list;
}
the method for filttering in c#
#region filter
private static Pair BuildParameter(GridFilterExpression expression)
{
string fieldName = expression.FieldName.Trim().Split(' ')[0];
GridKnownFunction filterFunction =
(GridKnownFunction)Enum.Parse(typeof(GridKnownFunction), expression.FilterFunction);
SqlParameter sqlParameter = null;
string filterExpression = string.Empty;
switch (filterFunction)
{
case GridKnownFunction.NoFilter:
filterExpression = "1 = 1";
break;
case GridKnownFunction.Contains:
filterExpression = string.Format("[{0}] LIKE @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
string.Format("%{0}%", Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName))));
break;
case GridKnownFunction.DoesNotContain:
filterExpression = string.Format("[{0}] NOT LIKE @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
string.Format("%{0}%", Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName))));
break;
case GridKnownFunction.StartsWith:
filterExpression = string.Format("[{0}] LIKE @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
string.Format("{0}%", Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName))));
break;
case GridKnownFunction.EndsWith:
filterExpression = string.Format("[{0}] LIKE @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
string.Format("%{0}", Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName))));
break;
case GridKnownFunction.EqualTo:
filterExpression = string.Format("[{0}] = @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
break;
case GridKnownFunction.NotEqualTo:
filterExpression = string.Format("[{0}] <> @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
break;
case GridKnownFunction.GreaterThan:
filterExpression = string.Format("[{0}] > @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
break;
case GridKnownFunction.LessThan:
filterExpression = string.Format("[{0}] < @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
break;
case GridKnownFunction.GreaterThanOrEqualTo:
filterExpression = string.Format("[{0}] >= @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
break;
case GridKnownFunction.LessThanOrEqualTo:
filterExpression = string.Format("[{0}] <= @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
break;
case GridKnownFunction.Between:
filterExpression = string.Format(" ([{0}] >= @{0}) AND ([{0}] <= @{0})", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
break;
case GridKnownFunction.NotBetween:
filterExpression = string.Format(" ([{0}] < @{0}) OR ([{0}] > @{0})", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
Convert.ChangeType(expression.FieldValue, Type.GetType(expression.DataTypeName)));
break;
case GridKnownFunction.IsEmpty:
filterExpression = string.Format(" [{0}] = @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
string.Empty);
break;
case GridKnownFunction.NotIsEmpty:
filterExpression = string.Format(" [{0}] <> @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
string.Empty);
break;
case GridKnownFunction.IsNull:
filterExpression = string.Format(" [{0}] = @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
DBNull.Value);
break;
case GridKnownFunction.NotIsNull:
filterExpression = string.Format(" [{0}] <> @{0}", fieldName);
sqlParameter =
new SqlParameter(string.Format("@{0}", fieldName),
DBNull.Value);
break;
}
return new Pair(filterExpression,
sqlParameter);
}
#endregion
now i dont know what to do to make filter working , the example link which i am following is doing lot of thing i am using a view in my sql command so iam confused also .
if any simple client side filtering example is there then plz let me know
