Hi all,
1)the Between option for Filtering is Showing Wrong data for dates when we use Telerik grid bound column i also used Datatype as system.datatime for that column if we use Telerik Datetime column as shown in examples
it is not showing Between option.I want Between option
ex:If iam giving dates as 02/24/1984 03/20/1986 in the Filter textbox and using BETWEEN for those two dates it is showing wrong data.Iam attaching the screen shot.
..................................Code for Filtering...........................................
| Hi all, |
| <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1"> |
| <asp:UpdatePanel ID="UpdatePanel1" runat="server"> |
| <ContentTemplate> |
| <telerik:RadGrid ID="gviewResource" runat="server" AutoGenerateColumns="False" OnRowEditing="gviewResource_RowEditing" |
| OnRowDeleting="gviewResource_RowDeleting" AllowPaging="True" AllowSorting="True" |
| OnDataBound="gviewResource_DataBound" CellPadding="0" |
| GridLines="None" Width="100%" OnPageIndexChanging="gviewResource_PageIndexChanging" |
| OnRowCreated="gviewResource_RowCreated" OnSorting="gviewResource_Sorting" |
| BorderColor="#66CCFF" BorderStyle="Solid" BorderWidth="1px" |
| onrowdatabound="gviewResource_RowDataBound" |
| onitemcommand="gviewResource_ItemCommand" Skin="Vista" |
| AllowFilteringByColumn="True" onitemcreated="gviewResource_ItemCreated" |
| EnableLinqExpressions="False" |
| onitemdatabound="gviewResource_ItemDataBound"> |
| <MasterTableView> |
| <Columns> |
| <telerik:GridBoundColumn DataField="ResourceID" HeaderText="ID" > |
| <HeaderStyle CssClass="textCenter" Width="6%" Wrap="True" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Name" HeaderText="Name" SortExpression="Name" HeaderStyle-Width="75px"> |
| <HeaderStyle Width="75px" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Designation" HeaderText="Designation" SortExpression="Designation" HeaderStyle-Width="75px"> |
| <HeaderStyle Width="75px" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Date Of Joining" HeaderText="Date Of Joining" SortExpression="Date Of Joining" HeaderStyle-Width="75px"> |
| <HeaderStyle Width="75px" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Date Of Birth" HeaderText="Date Of Birth" SortExpression="Date Of Birth" HeaderStyle-Width="75px"> |
| <HeaderStyle Width="75px" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Exp. In Yrs" HeaderText="Exp. In Years" SortExpression="Exp. In Yrs" HeaderStyle-Width="75px"> |
| <HeaderStyle Width="75px" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Exp. In Mon" HeaderText="Exp. In Mon" SortExpression="Exp. In Mon" HeaderStyle-Width="75px"> |
| <HeaderStyle Width="75px" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Email" HeaderText="Email ID" SortExpression="Email" HeaderStyle-Width="75px"> |
| <HeaderStyle Width="75px" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Resource Status" HeaderText="Status" SortExpression="Resource Status" HeaderStyle-Width="75px"> |
| <HeaderStyle Width="75px" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridTemplateColumn HeaderText="Edit" AllowFiltering="false" > |
| <ItemTemplate> |
| <asp:ImageButton ID="Image" runat="server" ImageUrl="images/edit.gif" CommandName="Edit" ></asp:ImageButton> |
| </ItemTemplate> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="Reject/Delete" AllowFiltering="false"> |
| <ItemTemplate> |
| <asp:ImageButton ID="imgbtnDeActivate" runat="server" ToolTip="Delete Resource" ImageUrl="~/images/delete-icon.gif" |
| CommandName="Delete" OnClientClick="return confirm('Are you sure you want to reject/delete this resource?');" /> |
| </ItemTemplate> |
| </telerik:GridTemplateColumn> |
| </Columns> |
| </MasterTableView> |
| <ClientSettings EnableRowHoverStyle="true"> |
| <Selecting AllowRowSelect="true" /> |
| <Scrolling EnableVirtualScrollPaging="True" UseStaticHeaders="False" /> |
| <Resizing AllowColumnResize="True" /> |
| </ClientSettings> |
| <FooterStyle ForeColor="White" /> |
| <HeaderStyle CssClass="heading" Font-Bold="True" Font-Strikeout="False" Font-Underline="False" |
| Height="30px" /> |
| </telerik:RadGrid> |
| </ContentTemplate> |
| </asp:UpdatePanel> |
| </telerik:RadAjaxPanel> |
| <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Height="75px" |
| Width="75px" Skin="Sunset"> |
| </telerik:RadAjaxLoadingPanel> |
| RadToolBar1.Items[6].Enabled = false; |
| Telerik.Web.UI.RadToolBarItem Properties = RadToolBar1.FindItemByText("Properties"); |
| Properties.Enabled = false; |
| <Columns> |
| <telerik:GridHyperLinkColumn NavigateUrl="mylink.aspx" |
| ItemStyle-Width="20px" HeaderText="Button Column" Text="Link" > |
| </telerik:GridHyperLinkColumn> |
| <telerik:GridButtonColumn FooterText="ImageButtonColumn<br/>footer" DataTextFormatString="Select {0}" |
| ButtonType="ImageButton" UniqueName="column" HeaderText="Teachers" ItemStyle-Width="20px" |
| ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center" CommandName="Select" |
| DataTextField="CustomerID" ImageUrl="App_Themes/NewTheme/images/Teachers.gif"> |
| <HeaderStyle HorizontalAlign="Center"></HeaderStyle> |
| <ItemStyle HorizontalAlign="Center" Width="20px"></ItemStyle> |
| </telerik:GridButtonColumn> |
| <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1"> |
| <asp:UpdatePanel ID="UpdatePanel2" runat="server"> |
| <ContentTemplate> |
| <telerik:RadGrid ID="gviewProjectwisetask" runat="server" Width="100%" AutoGenerateColumns="False" |
| GridLines="None" CellPadding="2" |
| onrowcommand="gviewProjectwisetask_RowCommand" |
| onpageindexchanging="gviewProjectwisetask_PageIndexChanging" |
| BackImageUrl="~/images/grad_l2.gif" BorderColor="#66CCFF" |
| BorderStyle="Solid" BorderWidth="1px" |
| onrowdatabound="gviewProjectwisetask_RowDataBound" |
| onrowediting="gviewProjectwisetask_RowEditing" |
| onrowdeleting="gviewProjectwisetask_RowDeleting" Skin="Vista" |
| onitemcommand="gviewProjectwisetask_ItemCommand" |
| onitemdatabound="gviewProjectwisetask_ItemDataBound"> |
| <MasterTableView> |
| <Columns> |
| <telerik:GridTemplateColumn HeaderText="Resource Name"> |
| <ItemTemplate> |
| <asp:LinkButton ID="ResourceName" runat="server" CommandName="Select" Text='<%#DataBinder.Eval(Container.DataItem,"Resource Name") %>'></asp:LinkButton> |
| </ItemTemplate> |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" |
| Wrap="True" /> |
| </telerik:GridTemplateColumn> |
| <telerik:GridBoundColumn DataField="Resource ID" HeaderText="ResourceId" |
| ItemStyle-CssClass="columnHidden" HeaderStyle-CssClass="columnHidden" > |
| <HeaderStyle CssClass="columnHidden" /> |
| <ItemStyle CssClass="columnHidden" Font-Bold="False" Font-Italic="False" |
| Font-Overline="False" Font-Strikeout="False" Font-Underline="False" |
| HorizontalAlign="Left" Wrap="True" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridTemplateColumn HeaderText="Task/Module Name"> |
| <ItemTemplate> |
| <asp:Label ID="lblTaskmane" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Task Name") %>'></asp:Label> |
| </ItemTemplate> |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" |
| Wrap="True" /> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="Task Description"> |
| <ItemTemplate> |
| <asp:Label ID="lblDesc" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Description") %>'></asp:Label> |
| </ItemTemplate> |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" |
| Wrap="True" /> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="Assigned By"> |
| <ItemTemplate> |
| <asp:Label ID="lblAssignedBy" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Assigned By") %>'></asp:Label> |
| </ItemTemplate> |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" |
| Wrap="True" /> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="ModifiedBy"> |
| <ItemTemplate> |
| <asp:Label ID="lblModifiedBy" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Modified By") %>'></asp:Label> |
| </ItemTemplate> |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" |
| Wrap="True" /> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="Phase"> |
| <ItemTemplate> |
| <asp:Label ID="lblphase" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"phase") %>'></asp:Label> |
| </ItemTemplate> |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" |
| Wrap="True" /> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="ETA(Hrs)"> |
| <ItemTemplate> |
| <asp:Label ID="lblETA" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Estimated Hours") %>'></asp:Label> |
| </ItemTemplate> |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" |
| Wrap="True" /> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="Date"> |
| <ItemTemplate> |
| <asp:Label ID="lblDate" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"Date") %>'></asp:Label> |
| </ItemTemplate> |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" |
| Wrap="True" /> |
| </telerik:GridTemplateColumn> |
| <telerik:GridBoundColumn DataField="Task ID" HeaderText="TaskID" |
| > |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" |
| Wrap="True" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="Document ID" HeaderText="DocumentID" |
| > |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" |
| Wrap="True" /> |
| </telerik:GridBoundColumn> |
| <telerik:GridTemplateColumn HeaderText="Document"> |
| <ItemTemplate> |
| <asp:LinkButton ID="lnkDocument" runat="server" CommandName="Select2" Text='<%#DataBinder.Eval(Container.DataItem,"File Name") %>'></asp:LinkButton> |
| </ItemTemplate> |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" |
| Wrap="True" /> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="Remove Att. File"> |
| <ItemTemplate> |
| <asp:ImageButton ID="imgbtnRemoveDocument" runat="server" ToolTip="Remove Attached File" |
| ImageUrl="~/images/delete-file-icon.gif" CommandName="Select3" OnClientClick="return confirm('Are you sure you want to remove att. file?');"/> |
| </ItemTemplate> |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center" |
| Wrap="True" /> |
| </telerik:GridTemplateColumn> |
| <telerik:GridTemplateColumn HeaderText="Add More"> |
| <ItemTemplate> |
| <asp:ImageButton ID="imgbtnAddmore" runat="server" ToolTip="Add More Tasks" |
| ImageUrl="~/images/AddMore.gif" CommandName="Select4"/> |
| </ItemTemplate> |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center" |
| Wrap="True" /> |
| </telerik:GridTemplateColumn> |
| <telerik:GridBoundColumn DataField="status" HeaderText="Status" |
| > |
| <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" |
| Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" |
| Wrap="True" /> |
| </telerik:GridBoundColumn> |
| </Columns> |
| </MasterTableView> |
| <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> |
| <PagerStyle |
| ForeColor="Black" HorizontalAlign="Center" Height="30px" Font-Bold="True" Font-Names="Arial" |
| Font-Size="Smaller" CssClass="footerbg" /> |
| </telerik:RadGrid> |
| </ContentTemplate> |
| </asp:UpdatePanel> |
| </telerik:RadAjaxPanel> |
| <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Height="75px" |
| Width="75px" Skin="Sunset"> |
| </telerik:RadAjaxLoadingPanel> |
..................................Code for Filtering...........................................
<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1">
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<telerik:RadGrid ID="gviewResource" runat="server" AutoGenerateColumns="False" OnRowEditing="gviewResource_RowEditing"
OnRowDeleting="gviewResource_RowDeleting" AllowPaging="True" AllowSorting="True"
OnDataBound="gviewResource_DataBound" CellPadding="0"
GridLines="None" Width="100%" OnPageIndexChanging="gviewResource_PageIndexChanging"
OnRowCreated="gviewResource_RowCreated" OnSorting="gviewResource_Sorting"
BorderColor="#66CCFF" BorderStyle="Solid" BorderWidth="1px"
onrowdatabound="gviewResource_RowDataBound"
onitemcommand="gviewResource_ItemCommand" Skin="Vista"
AllowFilteringByColumn="True" onitemcreated="gviewResource_ItemCreated"
EnableLinqExpressions="False"
onitemdatabound="gviewResource_ItemDataBound">
<MasterTableView>
<Columns>
<telerik:GridBoundColumn DataField="ResourceID" HeaderText="ID" >
<HeaderStyle CssClass="textCenter" Width="6%" Wrap="True" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Name" HeaderText="Name" SortExpression="Name" HeaderStyle-Width="75px">
<HeaderStyle Width="75px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Designation" HeaderText="Designation" SortExpression="Designation" HeaderStyle-Width="75px">
<HeaderStyle Width="75px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Date Of Joining" HeaderText="Date Of Joining" SortExpression="Date Of Joining" HeaderStyle-Width="75px">
<HeaderStyle Width="75px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Date Of Birth" HeaderText="Date Of Birth" SortExpression="Date Of Birth" HeaderStyle-Width="75px">
<HeaderStyle Width="75px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Exp. In Yrs" HeaderText="Exp. In Years" SortExpression="Exp. In Yrs" HeaderStyle-Width="75px">
<HeaderStyle Width="75px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Exp. In Mon" HeaderText="Exp. In Mon" SortExpression="Exp. In Mon" HeaderStyle-Width="75px">
<HeaderStyle Width="75px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Email" HeaderText="Email ID" SortExpression="Email" HeaderStyle-Width="75px">
<HeaderStyle Width="75px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Resource Status" HeaderText="Status" SortExpression="Resource Status" HeaderStyle-Width="75px">
<HeaderStyle Width="75px" />
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn HeaderText="Edit" AllowFiltering="false" >
<ItemTemplate>
<asp:ImageButton ID="Image" runat="server" ImageUrl="images/edit.gif" CommandName="Edit" ></asp:ImageButton>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn HeaderText="Reject/Delete" AllowFiltering="false">
<ItemTemplate>
<asp:ImageButton ID="imgbtnDeActivate" runat="server" ToolTip="Delete Resource" ImageUrl="~/images/delete-icon.gif"
CommandName="Delete" OnClientClick="return confirm('Are you sure you want to reject/delete this resource?');" />
</ItemTemplate>
</telerik:GridTemplateColumn>
</Columns>
</MasterTableView>
<ClientSettings EnableRowHoverStyle="true">
<Selecting AllowRowSelect="true" />
<Scrolling EnableVirtualScrollPaging="True" UseStaticHeaders="False" />
<Resizing AllowColumnResize="True" />
</ClientSettings>
<FooterStyle ForeColor="White" />
<HeaderStyle CssClass="heading" Font-Bold="True" Font-Strikeout="False" Font-Underline="False"
Height="30px" />
</telerik:RadGrid>
</ContentTemplate>
</asp:UpdatePanel>
</telerik:RadAjaxPanel>
<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Height="75px"
Width="75px" Skin="Sunset">
</telerik:RadAjaxLoadingPanel>
