or
I was using gridview of Q3 2009 release, which was providing me the filterExpression like we use to filter in datatable.
Now i have upgraded to Q1 2011 release , and now the GridView is returning FilterExpression in some other format.
This broke my code. Can anyone tell me , how to resolve this?
e.g. this i am getting as filterExpression :
(it[\"fieldName\"].ToString().Contains(\"H\"))
It should be as following :
fieldName LIKE '%H%'
protected void rgRequest_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e) { if (e.Item is GridDataItem && e.Item.IsInEditMode) { GridDataItem item = (GridDataItem)e.Item; ImageButton image = (ImageButton)e.Item.FindControl("UpdateButton"); image.CausesValidation = false; image.Click += new ImageClickEventHandler(image_Click); } } <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="Test.ascx.cs" Inherits="WebApplication4.Test" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><h4> Scenario Lab Management</h4><asp:Label ID="lblId" runat="server"></asp:Label>:<asp:Label ID="lblValue" runat="server"></asp:Label><telerik:RadGrid ID="radSIFMAHypotheticalMaintenance" runat="server" AutoGenerateColumns="False" PageSize="25" AllowAutomaticUpdates="True"> <MasterTableView Width="100%" PageSize="25" AutoGenerateColumns="False"> <Columns> <telerik:GridButtonColumn ButtonType="LinkButton" UniqueName="EditCommandColumn" CommandName="Edit" Text="Edit" /> <telerik:GridBoundColumn DataField="MaturityType" HeaderText="Maturity" SortExpression="" ReadOnly="true" /> <telerik:GridBoundColumn DataField="Sequence" HeaderText="Sequence" SortExpression="" ReadOnly="true" /> <telerik:GridNumericColumn UniqueName="SIFMA" SortExpression="SIFMA" HeaderText="SIFMA" DataType="System.Decimal" DataField="Rate" ColumnEditorID="GridNumericColumnEditor1"> </telerik:GridNumericColumn> </Columns> </MasterTableView> <ClientSettings> <Selecting AllowRowSelect="true" /> </ClientSettings></telerik:RadGrid><telerik:GridNumericColumnEditor ID="GridNumericColumnEditor1" runat="server"> <NumericTextBox MaxLength="25" EmptyMessage="Percentage."> <NumberFormat GroupSeparator="" DecimalDigits="2" /> </NumericTextBox></telerik:GridNumericColumnEditor><telerik:RadGrid ID="radLIBOR" runat="server" AutoGenerateColumns="False" PageSize="25"> <MasterTableView Width="100%" CommandItemDisplay="None" PageSize="25" AutoGenerateColumns="False" EditMode="EditForms"> <Columns> <telerik:GridButtonColumn ButtonType="LinkButton" UniqueName="EditCommandColumn" CommandName="Edit" Text="Edit" /> <telerik:GridBoundColumn DataField="maturityType" HeaderText="Maturity" SortExpression="" ReadOnly="true" /> <telerik:GridBoundColumn HeaderText="Sequence" DataField="sequence" SortExpression="" ReadOnly="true" /> <telerik:GridNumericColumn UniqueName="LIBOR" SortExpression="LIBOR" HeaderText="LIBOR" DataType="System.Decimal" DataField="rate" ColumnEditorID="GridNumericColumnEditor2"> </telerik:GridNumericColumn> </Columns> </MasterTableView> <ClientSettings> <Selecting AllowRowSelect="true" /> </ClientSettings></telerik:RadGrid><telerik:GridNumericColumnEditor ID="GridNumericColumnEditor2" runat="server"> <NumericTextBox MaxLength="25" EmptyMessage="Percentage."> <NumberFormat GroupSeparator="" DecimalDigits="2" /> </NumericTextBox></telerik:GridNumericColumnEditor>using System;namespace WebApplication4{ public partial class Test : System.Web.UI.UserControl { protected void Page_Load(object sender, EventArgs e) { } public void LoadData(TestData td) { lblId.Text = td.id.ToString(); lblValue.Text = td.var1.ToString(); radSIFMAHypotheticalMaintenance.DataSource = td.sifmaList; radLIBOR.DataSource = td.liborList; radSIFMAHypotheticalMaintenance.DataBind(); radLIBOR.DataBind(); } }}Default.aspx:
<%@ Page Title="Home Page" Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication4._Default" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><html xmlns="http://www.w3.org/1999/xhtml"><head id="Head1" runat="server"> <title></title></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <telerik:RadTabStrip ID="RadTabStrip1" Width="100%" runat="server" MultiPageID="RadMultiPage1" SelectedIndex="0"> </telerik:RadTabStrip> <telerik:RadMultiPage ID="RadMultiPage1" runat="server" SelectedIndex="0"> </telerik:RadMultiPage> </form></body></html>using System;using System.Collections.Generic;using Telerik.Web.UI;namespace WebApplication4{ public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!this.IsPostBack) { List<TestData> lst = DataSetUp(); foreach (var item in lst) { RadTab tab = new RadTab(); tab.Text = item.tabName; tab.PageViewID = item.id.ToString(); RadTabStrip1.Tabs.Add(tab); RadPageView pageView = new RadPageView(); pageView.ID = item.id.ToString(); Test userControl = this.LoadControl("~/Test.ascx") as Test; userControl.LoadData(item as TestData); pageView.Controls.Add(userControl); RadMultiPage1.PageViews.Add(pageView); } } } private static List<TestData> DataSetUp() { List<TestData> lst = new List<TestData>(); List<LIBOR> liborLst = new List<LIBOR>(); liborLst.Add(new LIBOR { maturityType = "Weekly", rate = 25.5, sequence = 100 }); liborLst.Add(new LIBOR { maturityType = "Monthly", rate = 35.5, sequence = 1001324 }); List<SIFMA> sifmaLst = new List<SIFMA>(); sifmaLst.Add(new SIFMA { maturityType = "Weekly", rate = 45.5, sequence = 1000 }); sifmaLst.Add(new SIFMA { maturityType = "Monthly", rate = 55.5, sequence = 10013240 }); var test = new TestData { id = 1, tabName = "10 Year Average", var1 = "string1", var2 = "string11", liborList = liborLst, sifmaList = sifmaLst }; lst.Add(test); List<LIBOR> liborLst2 = new List<LIBOR>(); liborLst2.Add(new LIBOR { maturityType = "Quarterly", rate = 65.5, sequence = 10 }); liborLst2.Add(new LIBOR { maturityType = "Yearly", rate = 75.5, sequence = 10013 }); List<SIFMA> sifmaLst2 = new List<SIFMA>(); sifmaLst2.Add(new SIFMA { maturityType = "Quarterly", rate = 85.5, sequence = 1 }); sifmaLst2.Add(new SIFMA { maturityType = "Yearly", rate = 95.5, sequence = 100 }); var test2 = new TestData { id = 2, tabName = "1987 Crash", var1 = "string2", var2 = "string22", liborList = liborLst2, sifmaList = sifmaLst2 }; lst.Add(test2); return lst; } } public class TestData { public int id; public string tabName; public string var1; public string var2; public List<LIBOR> liborList; public List<SIFMA> sifmaList; } public class LIBOR { public string maturityType; public double rate; public int sequence; public string MaturityType { get { return maturityType; } } public double Rate { get { return rate; } } public int Sequence { get { return sequence; } } } public class SIFMA { public string maturityType; public double rate; public int sequence; public string MaturityType { get { return maturityType; } } public double Rate { get { return rate; } } public int Sequence { get { return sequence; } } }}.RadListBox
.rlbGroup .rlbActive
{
border: 1px dotted #555;
padding: 1px 4px;
}