Hi,
I have a requirement for DateTime column to provide two dates (like From and To date) and filter the records which falls between these dates.I went through following link
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/filtertemplate/defaultcs.aspx
and applied it properly.
but with this feature I also want the normal DateTime filter (with date Picker and filter text box) for the filtering the datetime column with following options-
GreaterThan (the provided date in textbox)
LessThan
Equals
NotEquals
similar to follink link for Shipped Date column-
http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/filtering/defaultcs.aspx
How to get both type of filter controls in single filter template column.
could you tell me how to apply both functionalities for single DateTime column in filter section.
Regards,
Mamta
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
script
type
=
"text/javascript"
>
var zones;
function OnClientInitialize(dock, args) {
zones = Telerik.Web.UI.RadDockZonesGlobalArray;
}
function OnDockChangedPosition(dock, args) {
var zone;
zone = dock.get_dockZone();
var sDockJustMoved;
sDockJustMoved = "";
sDockJustMoved = dock.get_element().TestDock + "~" + zone.get_element().TestZone;
alert(sDockJustMoved);
}
</
script
>
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
<
title
>Untitled Page</
title
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
asp:scriptmanager
ID
=
"Scriptmanager1"
runat
=
"server"
></
asp:scriptmanager
>
<
div
>
<
telerik:RadDockLayout
ID
=
"RadDockLayout1"
runat
=
"server"
>
<
telerik:RadDockZone
ID
=
"RadDockZone1"
runat
=
"server"
Height
=
"300px"
Width
=
"300px"
>
<
telerik:RadDock
ID
=
"RadDock1"
runat
=
"server"
Width
=
"300px"
OnClientDockPositionChanged
=
"OnDockChangedPosition"
>
</
telerik:RadDock
>
</
telerik:RadDockZone
>
<
telerik:RadDockZone
ID
=
"RadDockZone2"
runat
=
"server"
Height
=
"300px"
Width
=
"300px"
>
</
telerik:RadDockZone
>
</
telerik:RadDockLayout
>
</
div
>
</
form
>
</
body
>
</
html
>
Partial
Class
_Default
Inherits
System.Web.UI.Page
Protected
Sub
Page_Load(
ByVal
sender
As
Object
,
ByVal
e
As
System.EventArgs)
Handles
Me
.Load
RadDock1.Attributes.Add(
"TestDock"
,
"Dock Attribute"
)
RadDockZone1.Attributes.Add(
"TestZone"
,
"Zone1 Attribute"
)
RadDockZone2.Attributes.Add(
"TestZone"
,
"Zone2 Attribute"
)
End
Sub
End
Class
public
partial
class
PageSearch : System.Web.UI.Page
{
public
ACHPagingDLL.dl dl =
new
ACHPagingDLL.dl();
protected
void
Page_Load(
object
sender, EventArgs e)
{
LoadGrid();
}
public
void
LoadGrid()
{
DataSet dsPatients = dl.c_FN_Paging_getAllEmployees();
rgEmployees.DataSource = dsPatients;
rgEmployees.DataBind();
}
protected
void
btnSearch_Click(
object
sender, EventArgs e)
{
if
(txtSearch.Text.Length < 2)
{
litResult.Visible =
true
;
litResult.Text =
"<FONT color=#cc0000 size=3>Search for 2 or more characters!</FONT>"
;
LoadGrid();
return
;
}
else
{
DataSet dsSearch = dl.c_FN_seachEmployees(txtSearch.Text);
rgEmployees.DataSource = dsSearch;
rgEmployees.DataBind();
}
}
}
<
telerik:RadAjaxPanel
ID
=
"RadAjaxPanel1"
runat
=
"server"
>
<
table
class
=
"style4"
>
<
tr
>
<
td
class
=
"style5"
>
Search for employee by name:</
td
>
<
td
class
=
"style6"
>
<
telerik:RadTextBox
ID
=
"txtSearch"
Runat
=
"server"
Width
=
"160px"
>
</
telerik:RadTextBox
>
<
telerik:RadButton
ID
=
"btnSearch"
runat
=
"server"
onclick
=
"btnSearch_Click"
Text
=
"Search"
>
</
telerik:RadButton
>
</
td
>
<
td
>
<
asp:Literal
ID
=
"litResult"
runat
=
"server"
></
asp:Literal
>
</
td
>
</
tr
>
<
tr
>
<
td
colspan
=
"3"
>
<
telerik:RadGrid
ID
=
"rgEmployees"
runat
=
"server"
AllowPaging
=
"True"
AutoGenerateColumns
=
"False"
GridLines
=
"None"
Skin
=
"WebBlue"
>
<
MasterTableView
pagesize
=
"20"
>
<
CommandItemSettings
ExportToPdfText
=
"Export to Pdf"
>
</
CommandItemSettings
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"EmployeeNo"
UniqueName
=
"EmployeeNo"
Visible
=
"False"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"EmployeeName"
HeaderText
=
"Employee"
UniqueName
=
"EmployeeName"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Pager"
HeaderText
=
"Pager"
UniqueName
=
"Pager"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Office"
HeaderText
=
"Office#"
UniqueName
=
"Office"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Cell"
HeaderText
=
"Cell Phone"
UniqueName
=
"Cell"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Email"
HeaderText
=
"Email"
UniqueName
=
"Email"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
<
HeaderContextMenu
EnableImageSprites
=
"True"
CssClass
=
"GridContextMenu GridContextMenu_Default"
>
</
HeaderContextMenu
>
</
telerik:RadGrid
>
</
td
>
</
tr
>
<
tr
>
<
td
colspan
=
"3"
>
</
td
>
</
tr
>
</
table
>
</
telerik:RadAjaxPanel
>