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;}