

<telerik:RadGrid ID="RadGrid1" runat="server" Skin="Centive" EnableEmbeddedSkins="False" AutoGenerateColumns="False" CellSpacing="0" GridLines="None" OnNeedDataSource="RadGrid1_NeedDataSource" OnItemDataBound="RadGrid1_ItemDataBound" OnDetailTableDataBind="RadGrid1_DetailTableDataBind"> <MasterTableView DataKeyNames="CompanyId,CentiveId,PlanId" Name="MainMasterTable"> <DetailTables> <telerik:GridTableView DataKeyNames="CompanyId,CentiveId,PlanId,AwardId" Name="AwardDetails"> <NestedViewTemplate> <telerik:RadTabStrip ID="TabStrip1" runat="server" MultiPageID="MultiPage1" Skin="Centive" EnableEmbeddedSkins="false"> <Tabs> <telerik:RadTab runat="server" Text="Transactions" PageViewID="PageView1" Selected="true"> </telerik:RadTab> <telerik:RadTab runat="server" Text="Vestings" PageViewID="PageView2"> </telerik:RadTab> <telerik:RadTab runat="server" Text="Tax" PageViewID="PageView3"> </telerik:RadTab> </Tabs> </telerik:RadTabStrip> <telerik:RadMultiPage runat="server" ID="MultiPage1" SelectedIndex="0" RenderSelectedPageOnly="false" SkinID="Centive" EnableEmbeddedBaseStylesheet="true"> <telerik:RadPageView runat="server" ID="PageView1"> <telerik:RadGrid runat="server" ID="RadGrid2" OnNeedDataSource="RadGrid2_NeedDataSource" AutoGenerateColumns="false" Skin="Centive" EnableEmbeddedSkins="false"> <MasterTableView DataKeyNames="CentiveId, CompanyId, PlanId, AwardId" Name="SecondMainMasterTable"> <Columns> <telerik:GridBoundColumn HeaderText="CentiveId" DataField="CentiveId" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="CompanyId" DataField="CompanyId" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Plan" DataField="PlanId" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Award" DataField="AwardId" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Type" DataField="Type"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Date" DataField="Date" DataFormatString="{0:dd/MM/yyyy}"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Units" HeaderStyle-HorizontalAlign="Right" DataField="Units" DataFormatString="{0:N0}"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Price" DataField="Price" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> </Columns> </MasterTableView> </telerik:RadGrid> </telerik:RadPageView> </telerik:RadMultiPage> </NestedViewTemplate> <Columns> <telerik:GridBoundColumn HeaderText="CentiveId" DataField="CentiveId" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="CompanyId" DataField="CompanyId" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Plan" DataField="PlanId" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Award" DataField="AwardId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Awarded" HeaderStyle-HorizontalAlign="Right" DataField="Awarded" DataFormatString="{0:N0}"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Exercised" DataField="Exercises" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Transfered" DataField="Transfers" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Sold" DataField="Sales" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Lapsed" DataField="Lapses" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Share Splits" DataField="Share Splits" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Rights Issues" DataField="Rights Issues" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Outstanding" DataField="Outstanding" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> </Columns> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridBoundColumn HeaderText="" DataField="Approved" Visible="false"> </telerik:GridBoundColumn> <telerik:GridImageColumn HeaderText="" UniqueName="ApprovedImage"> <ItemStyle HorizontalAlign="Left" Width="1" /> </telerik:GridImageColumn> <telerik:GridBoundColumn HeaderText="CentiveId" DataField="CentiveId" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="CompanyId" DataField="CompanyId" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Plan" DataField="PlanId"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Awarded" HeaderStyle-HorizontalAlign="Right" DataField="Awarded" DataFormatString="{0:N0}"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Exercised" DataField="Exercises" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Transfered" DataField="Transfers" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Sold" DataField="Sales" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Lapsed" DataField="Lapses" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Share Splits" DataField="Share Splits" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Rights Issues" DataField="Rights Issues" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Outstanding" DataField="Outstanding" DataFormatString="{0:N0}" HeaderStyle-HorizontalAlign="Right"> <HeaderStyle HorizontalAlign="Right"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridBoundColumn> </Columns> </MasterTableView></telerik:RadGrid>
<telerik:RadComboBox ID="ddlEmailTo" AutoCompleteSeparator=";" AllowCustomText="True"
runat="server" Width="505" Height="150" CssClass="rfdRoundedCorners" DataSourceID="sqlDsContactEmail"
DataTextField="strEmail" MarkFirstMatch="true" ShowToggleImage="False" Filter="StartsWith"
AccessKey="T">
</telerik:RadComboBox>
I am facing problem in GridDateTimeColumn "Equal To " filter problem .I have one webpage having telerik:RadGrid .
In this page grid I am having
"<telerik:GridDateTimeColumn DataField="DateRefundRequested"
FilterListOptions="VaryByDataType" HeaderText="Date"
UniqueName="DateRefundRequested" HeaderStyle-Width="175px"
AllowFiltering="true" />
Column."
I assigned to datasource to this telerik grid. In this datasource datetime type column value binded to corresponding "telerik:GridDateTimeColumn" in that telerik grid.
When I run this page .the datasource value filled to gird. When I try to filter that grid is “EqualTo”.it was displayed is “No records found.”
But When I apply the filter is “GreaterThan” ,it was return the results.
So can you please suggest how to solve this issue.
This is my code:
<telerik:RadGrid runat="server" ID="ListGrid" ShowStatusBar="True"
AllowPaging="True" GridLines="None" Skin="Office2007"
PageSize="5" BorderStyle="Solid" AllowFilteringByColumn="True" AllowMultiRowSelection="True"
PagerStyle-AlwaysVisible="true" ShowGroupPanel="True"
OnNeedDataSource="ListGrid_NeedDataSource"
OnItemCommand="ListGrid_ItemCommand"
OnItemDataBound="ListGrid_ItemDataBound"
OnItemEvent="ListGrid_ItemEvent"
OnPreRender="ListGrid_PreRender"
Width="100%"
<ClientSettings AllowDragToGroup="false" AllowColumnsReorder="false" ReorderColumnsOnClient="False" >
<Scrolling AllowScroll="false" UseStaticHeaders="false" />
</ClientSettings>
<GroupPanel ID="GridViewLeftGroupPanel" Text="Refund Requests">
<PanelStyle Width="100%" Height="20px" />
</GroupPanel>
<PagerStyle Mode="NextPrevNumericAndAdvanced" />
<ItemStyle HorizontalAlign="Left" />
<mastertableview CommandItemDisplay="Top" AutoGenerateColumns="False" Width="100%"
CssClass="DetailTable_Default" DataKeyNames="PaymentRefundRequestID" NoMasterRecordsText="No records found." EditMode="InPlace" >
<PagerStyle Mode="NextPrevNumericAndAdvanced" />
<CommandItemTemplate>
<div style="text-align: right; padding-top: 3px; padding-bottom: 3px; text-align: right; width: 100%;" >
<asp:LinkButton runat="server" ID="selectAll" Text="Select All"
CommandName="SelectAll" SkinID="GridSelectAllLinkButton"
meta:resourcekey="selectAllResource1" />
<asp:LinkButton runat="server" ID="unselectAll" Text="Deselect All"
CommandName="UnSelectAll" SkinID="GridUnSelectAllLinkButton" Visible="False"
meta:resourcekey="unselectAllResource1" />
<asp:LinkButton runat="server" ID="denyRefunds" Text="Deny Refund"
OnClientClick="return OpenDenyReasonWindow();"
SkinID="GridDenyRefundLinkButton" meta:resourcekey="denyRefundsResource1" />
<asp:LinkButton runat="server" ID="processRefunds" Text="Process Refund"
CommandName="ProcessRefunds" SkinID="GridProcessRefundLinkButton"
meta:resourcekey="processRefundsResource1" />
<asp:LinkButton ID="refreshPaymentsButton" runat="server" CommandName="Rebind"
Text="Refresh" ToolTip="Refresh" SkinID="GridRefreshLinkButton"
meta:resourcekey="refreshPaymentsButtonResource1" />
</div>
</CommandItemTemplate>
<Columns>
<telerik:GridTemplateColumn UniqueName="CheckBoxTemplateColumn"
HeaderText="Select" AllowFiltering="false"
meta:resourcekey="GridTemplateColumnResource1">
<ItemTemplate>
<asp:CheckBox id="chbxSelect" OnCheckedChanged="ToggleRowSelection"
AutoPostBack="True" runat="server" meta:resourcekey="chbxSelectResource1"></asp:CheckBox>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn DataField="IsParentPayment" HeaderText=" "
HeaderStyle-Width="20px" UniqueName="ParentPayment" AllowFiltering="false"
ReadOnly="true">
<HeaderStyle Width="20px"></HeaderStyle>
</telerik:GridBoundColumn>
<telerik:GridDateTimeColumn DataField="DateRefundRequested" HeaderText="Date"
UniqueName="DateRefundRequested" HeaderStyle-Width="175px"
AllowFiltering="true" FilterListOptions="VaryByDataType"
meta:resourcekey="GridBoundColumnResource3" />
<telerik:GridBoundColumn DataField="EntPayID" HeaderText=""
DataType="System.Int32" UniqueName="EntPayID" AllowFiltering="False"
Visible="false" meta:resourcekey="GridBoundColumnResource4" />
<telerik:GridBoundColumn DataField="RefundReason" DataType="System.String"
HeaderText="Reason" UniqueName="RefundReason" AllowFiltering="true"
FilterListOptions="VaryByDataType"
meta:resourcekey="GridBoundColumnResource11" />
</Columns>
</mastertableview>
</telerik:RadGrid>
In this code "DateRefundRequested" GridDateTimeColumn column only i am trying to filter.but it is not working.
~ Thirunavukarasu