or
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
head
runat
=
"server"
>
<
title
></
title
>
<
telerik:RadStyleSheetManager
id
=
"RadStyleSheetManager1"
runat
=
"server"
/>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
runat
=
"server"
>
<
Scripts
>
<%--Needed for JavaScript IntelliSense in VS2010--%>
<%--For VS2008 replace RadScriptManager with ScriptManager--%>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.Core.js"
/>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQuery.js"
/>
<
asp:ScriptReference
Assembly
=
"Telerik.Web.UI"
Name
=
"Telerik.Web.UI.Common.jQueryInclude.js"
/>
</
Scripts
>
</
telerik:RadScriptManager
>
<
script
type
=
"text/javascript"
>
//Put your JavaScript code here.
</
script
>
<
telerik:RadAjaxManager
ID
=
"RadAjaxManager1"
runat
=
"server"
>
<
AjaxSettings
>
<
telerik:AjaxSetting
AjaxControlID
=
"radGrid1"
>
<
UpdatedControls
>
<
telerik:AjaxUpdatedControl
ControlID
=
"radGrid1"
/>
<
telerik:AjaxUpdatedControl
ControlID
=
"rtsMainTab"
/>
</
UpdatedControls
>
</
telerik:AjaxSetting
>
</
AjaxSettings
>
</
telerik:RadAjaxManager
>
<
div
>
<
telerik:RadTabStrip
ID
=
"rtsMainTab"
runat
=
"server"
AutoPostBack
=
"true"
OnTabClick
=
"rtsMainTab_TabClick"
>
<
tabs
>
<
telerik:RadTab
runat
=
"server"
>
<
TabTemplate
>
<
span
class
=
"rtsTxt"
>My Groups</
span
> (<
asp:Label
ID
=
"lblMyGroupsCountOpen"
runat
=
"server"
/>/<
asp:Label
ID
=
"lblMyGroupsCountStat"
runat
=
"server"
style
=
"color:Red;"
/>)
</
TabTemplate
>
</
telerik:RadTab
>
<
telerik:RadTab
runat
=
"server"
>
<
TabTemplate
>
<
span
class
=
"rtsTxt"
>My Assignments</
span
> (<
asp:Label
ID
=
"lblMyAssignmentsCountOpen"
runat
=
"server"
/>/<
asp:Label
ID
=
"lblMyAssignmentsCountStat"
runat
=
"server"
style
=
"color:Red;"
/>)
</
TabTemplate
>
</
telerik:RadTab
>
</
tabs
>
</
telerik:RadTabStrip
>
<
telerik:RadGrid
runat
=
"server"
ID
=
"radGrid1"
Skin
=
"Outlook"
BorderStyle
=
"None"
AllowPaging
=
"false"
AllowMultiRowSelection
=
"true"
AutoGenerateColumns
=
"false"
PageSize
=
"30"
>
<
MasterTableView
TableLayout
=
"Fixed"
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"AssignmentGroup"
HeaderText
=
"Assg Group"
HeaderStyle-Width
=
"95px"
ItemStyle-Width
=
"95px"
/>
<
telerik:GridTemplateColumn
HeaderText
=
"Stat"
HeaderStyle-Width
=
"70px"
ItemStyle-Width
=
"70px"
SortExpression
=
"IsStat"
>
<
ItemTemplate
>
<
asp:DropDownList
ID
=
"ddlReferralAssignmentsIsStat"
runat
=
"server"
CssClass
=
"DropDownList"
AutoPostBack
=
"true"
OnSelectedIndexChanged
=
"ddlReferralAssignmentsIsStat_SelectedIndexChanged"
>
<
asp:ListItem
Text
=
"Yes"
Value
=
"Yes"
/>
<
asp:ListItem
Text
=
"No"
Value
=
"No"
/>
</
asp:DropDownList
>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
</
Columns
>
</
MasterTableView
>
<
ClientSettings
AllowColumnsReorder
=
"false"
ReorderColumnsOnClient
=
"false"
>
<
Selecting
AllowRowSelect
=
"True"
EnableDragToSelectRows
=
"false"
/>
<
Scrolling
AllowScroll
=
"true"
UseStaticHeaders
=
"true"
ScrollHeight
=
"600px"
/>
</
ClientSettings
>
<
PagerStyle
Mode
=
"NumericPages"
PageButtonCount
=
"4"
/>
</
telerik:RadGrid
>
</
div
>
</
form
>
</
body
>
</
html
>
using
System;
using
System.Web;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Data;
using
System.Configuration;
using
System.Web.Security;
using
System.Web.UI.WebControls.WebParts;
using
System.Web.UI.HtmlControls;
using
Telerik.Web.UI;
public
partial
class
Default : System.Web.UI.Page
{
protected
void
Page_Init(
object
sender, EventArgs e)
{
//if this is commented in, the tabs will do Full Postbacks initially, until an asynch postback is done from the grid
//if its not commented in, then the tabs always postback asynch
//RadScriptManager.GetCurrent(this.Page).RegisterPostBackControl(rtsMainTab);
}
protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(!
this
.IsPostBack)
{
string
[] data = {
"test1"
,
"test2"
};
radGrid1.DataSource = data;
radGrid1.DataBind();
}
}
protected
void
rtsMainTab_TabClick(
object
sender, RadTabStripEventArgs e)
{
bool
isAsynch = RadScriptManager.GetCurrent(
this
.Page).IsInAsyncPostBack;
System.Diagnostics.Trace.WriteLine(
"tab click is asynch: "
+ isAsynch);
}
protected
void
ddlReferralAssignmentsIsStat_SelectedIndexChanged(Object sender, EventArgs e)
{
bool
isAsynch = RadScriptManager.GetCurrent(
this
.Page).IsInAsyncPostBack;
System.Diagnostics.Trace.WriteLine(
"grid action is asynch: "
+ isAsynch);
}
}
I'm trying to use the MonthYearPicker as my control for filtering datetime. However, when I try the code below, I get:
String was not recognized as a valid DateTime.
I've tried formatting several ways with no luck. I was trying to
look at the event in the code behind, but I see no arguments at all that
contains my filter values themselves. Just the column name and
expression. Any help would be appreciated. Thank you!
<
FilterTemplate
>
<
telerik:RadMonthYearPicker
ID
=
"RadMonthYearPicker1"
runat
=
"server"
ClientEvents-OnPopupClosing
=
"MeasurementDateChanged"
/>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock3"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function MeasurementDateChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
var year = args._picker.FocusedDate[0];
var month = args._picker.FocusedDate[1];
var fromDate = new Date(year, month-1, 1);
var toDate = new Date(year, month, 0);
tableView.filter("MeasurementDate", fromDate.toISOString() + " " + toDate.toISOString(), "Between");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="MainGrid_Box.ascx.cs" Inherits="_Default_MainGrid_Box" %>
<
telerik:RadGrid
ID
=
"RadGrid_r2bweb_Box"
GridLines
=
"None"
runat
=
"server"
AllowSorting
=
"true"
AllowPaging
=
"false"
DataSourceID
=
"SqlDataSource_r2bweb_Box"
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
AlwaysVisible
=
"true"
/>
<
MasterTableView
Width
=
"100%"
CommandItemDisplay
=
"Top"
DataKeyNames
=
"url_id"
DataSourceID
=
"SqlDataSource_r2bweb_Box"
HorizontalAlign
=
"NotSet"
AutoGenerateColumns
=
"true"
GroupLoadMode
=
"Client"
GroupsDefaultExpanded
=
"true"
TableLayout
=
"Fixed"
>
<
GroupHeaderTemplate
>
<
asp:CheckBox
ID
=
"CheckBox_Main_Box"
runat
=
"server"
onclick
=
"CheckAll(this);"
/>
<
asp:Label
runat
=
"server"
ID
=
"r2b_GroupingHeader_Main_Box"
Text='<%# " lst_name(s): "+Eval("lst_name") %>'
Visible='<%# ((((GridGroupHeaderItem)Container).AggregatesValues["lst_name"]) != null)%>'></
asp:Label
>
</
GroupHeaderTemplate
>
<
GroupByExpressions
>
<
telerik:GridGroupByExpression
>
<
SelectFields
>
<
telerik:GridGroupByField
FieldAlias
=
"lst_name"
FieldName
=
"lst_name"
></
telerik:GridGroupByField
>
</
SelectFields
>
<
GroupByFields
>
<
telerik:GridGroupByField
FieldName
=
"lst_name"
SortOrder
=
"Descending"
></
telerik:GridGroupByField
>
</
GroupByFields
>
</
telerik:GridGroupByExpression
>
</
GroupByExpressions
>
<
ItemTemplate
>
<%# (((GridItem)Container).ItemIndex != 0)? "</
td
></
tr
></
table
>" : "" %>
<
asp:Panel
ID
=
"r2bweb_panel"
CssClass='<%# (((GridItem)Container).ItemType == GridItemType.Item)? "item" : "alternatingItem" %>' HorizontalAlign="Center" runat="server">
<
asp:Image
ID
=
"r2bweb_mySites"
Style
=
"float: left; text-align:center;"
Width
=
"50px"
Height
=
"50px"
ImageUrl
=
"~/Images/mySites.png"
runat
=
"server"
AlternateText
=
"My Site"
/>
<
br
/>
<%# Eval("url_name")%>
</
asp:Panel
>
</
ItemTemplate
>
</
MasterTableView
>
<
ClientSettings
AllowDragToGroup
=
"false"
AllowColumnsReorder
=
"false"
AllowRowsDragDrop
=
"True"
AllowGroupExpandCollapse
=
"True"
>
<
Selecting
AllowRowSelect
=
"true"
EnableDragToSelectRows
=
"true"
/>
<
Resizing
AllowRowResize
=
"True"
EnableRealTimeResize
=
"false"
ResizeGridOnColumnResize
=
"false"
AllowColumnResize
=
"True"
AllowResizeToFit
=
"true"
ShowRowIndicatorColumn
=
"false"
ClipCellContentOnResize
=
"false"
/>
<
Scrolling
AllowScroll
=
"false"
UseStaticHeaders
=
"True"
SaveScrollPosition
=
"true"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
<
asp:SqlDataSource
ID
=
"SqlDataSource_r2bweb_Box"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:r2bweb_ConnectionString %>"
SelectCommand="SELECT a.[lst_id], b.[lst_name], a.[url_id], a.[urp_id], a.[usr_id], a.[cat_id], a.[url_isOpen], a.[url_type], a.[url_name], a.[url_address], a.[url_isLoginOrOpen], a.[url_username], a.[url_isSaveUsername], a.[url_isEnableUsername], a.[url_password], a.[url_isSavePassword], a.[url_isEnablePassword], a.[url_desc], a.[url_isSave] FROM [t_url] a INNER JOIN [t_myList] b ON a.[lst_id] = b.[lst_id]">
</
asp:SqlDataSource
>
protected void btnExportToCSV_Click(object sender, EventArgs e)
{
radgridSentiment.ExportSettings.IgnorePaging = true;
radgridSentiment.MasterTableView.ExportToCSV();
radgridSentiment.MasterTableView.GetColumn("columnTweetID").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnBusinessAreas").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnLocation").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnAuthorLocationContinentCode").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnAuthorLocationStateCode").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnAuthorLocationRegionCode").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnAuthorLocationCountryCode").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnDataSourceIndustry").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnDataSourceCoverageArea").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnDataSourceBusinessArea").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnLifeStyle").Visible = true;
radgridSentiment.MasterTableView.GetColumn("DataURL").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnUserID").Visible = true;
radgridSentiment.MasterTableView.GetColumn("UserID").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnSelect").Visible = false;
radgridSentiment.MasterTableView.GetColumn("columnAction").Visible = false;
radgridSentiment.MasterTableView.GetColumn("columnTweetDataExport").Visible = true;
radgridSentiment.MasterTableView.GetColumn("columnTweetData").Visible = false;
}