or
Markup:
<%@ Page Language="vb" AutoEventWireup="false" Inherits="acctrpt.acctrpt._Default2" validateRequest="false" Codebehind="Default2.aspx.vb" Trace="false" %><html xmlns="http://www.w3.org/1999/xhtml"><head id="Head1" runat="server"> <title></title></head> <body> <form runat="server"> <telerik:RadScriptManager ID="ScriptManager1" runat="server" /> <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"> <script type="text/javascript"> function RequestStart(sender, args) { if (args.get_eventTarget().indexOf("ExportToCsvButton") >= 0) args.set_enableAjax(false); } </script> </telerik:RadCodeBlock> <telerik:RadCodeBlock ID="RadCodeBlock2" runat="server"> <style type="text/css"> a:hover {color: #444444; text-decoration: overline underline; background-color: #E1DDC9 !important;} </style> </telerik:RadCodeBlock> <telerik:RadAjaxManager ID="AjaxManager1" runat="server" > <ClientEvents OnRequestStart="RequestStart" ></ClientEvents> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="rgValidate"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="rgValidate" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <table id="tblGrids" width="96%" align="center" runat="server" > <tr><td> <telerik:RadGrid ID="rgValidate" runat="server" AutoGenerateColumns="true" Width="100%" ItemStyle-Wrap="false" FilterItemStyle-Width="100%" AllowSorting="true" AllowPaging="true" AllowFilteringByColumn="true" Skin="Outlook" > <GroupingSettings CaseSensitive="false" /> <PagerStyle AlwaysVisible="true" /> <ExportSettings HideStructureColumns="true" OpenInNewWindow="false" IgnorePaging="true" ExportOnlyData="true" /> <MasterTableView CommandItemDisplay="Top" HierarchyLoadMode="Client" GroupLoadMode="Server" > <CommandItemSettings ShowExportToCsvButton="true" ShowAddNewRecordButton="false" ExportToCsvText="grid" /> </MasterTableView> </telerik:RadGrid> </td></tr> </table> <asp:Button runat="server" ID="btn1" Text="Data Source 1" UseSubmitBehavior="false" /> <asp:Button runat="server" ID="btn2" Text="Data Source 2" UseSubmitBehavior="false" /> </form> </body></html>Option Strict OnImports Microsoft.VisualBasicImports SystemImports System.DataImports System.Data.SqlClientImports System.WebImports System.Web.HttpContextImports System.Web.UIImports System.Web.UI.HTMLControlsImports System.Web.UI.WebControlsImports System.Text.RegularExpressionsImports System.IOImports Telerik.Web.UINamespace acctrpt Partial Class _Default2 : Inherits page Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If Not IsPostBack Then Dim dt1 As New DataTable dt1.Columns.Add("Column1", GetType(Integer)) dt1.Columns.Add("Column2", GetType(Integer)) dt1.Columns.Add("Column3", GetType(Integer)) Dim dt2 As New DataTable dt2.Columns.Add("Field1", GetType(Integer)) dt2.Columns.Add("Field2", GetType(Integer)) dt2.Columns.Add("Field3", GetType(Integer)) For i As Integer = 1 to 20 Dim dr1 As DataRow = dt1.NewRow Dim dr2 As DataRow = dt2.NewRow dr1("Column1") = i dr1("Column2") = i + 100 dr1("Column3") = i + 1000 dr2("Field1") = i dr2("Field2") = i + 200 dr2("Field3") = i + 2000 dt1.Rows.Add(dr1) dt2.Rows.Add(dr2) Next Session("DS1") = dt1.DefaultView Session("DS2") = dt2.DefaultView Session("ActiveDataSource") = "1" End If End Sub Private Sub rgValidate_NeedDataSource(sender As Object, e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles rgValidate.NeedDataSource Select Case Session("ActiveDataSource").ToString() Case "1" rgValidate.DataSource = Session("DS1") Case "2" rgValidate.DataSource = Session("DS2") Case Else rgValidate.DataSource = Nothing End Select rgValidate.ExportSettings.FileName = "Export" & Session("ActiveDataSource").ToString() End Sub Private Sub btn1_Click(sender As Object, e As System.EventArgs) Handles btn1.Click Session("ActiveDataSource") = "1" If rgValidate.MasterTableView isnot Nothing then rgValidate.MasterTableView.SortExpressions.Clear() rgValidate.MasterTableView.FilterExpression = "" rgValidate.MasterTableView.GroupByExpressions.Clear() End If rgValidate.Rebind() End Sub Private Sub btn2_Click(sender As Object, e As System.EventArgs) Handles btn2.Click Session("ActiveDataSource") = "2" If rgValidate.MasterTableView isnot Nothing then rgValidate.MasterTableView.SortExpressions.Clear() rgValidate.MasterTableView.FilterExpression = "" rgValidate.MasterTableView.GroupByExpressions.Clear() End If rgValidate.Rebind() End Sub Private Sub rgValidate_ColumnCreated(sender As Object, e As Telerik.Web.UI.GridColumnCreatedEventArgs) Handles rgValidate.ColumnCreated If TypeOf e.Column is GridBoundColumn Then Dim col As GridBoundColumn = DirectCast(e.Column, GridBoundColumn) Select Case True Case col.UniqueName.ToLower.Contains("1") col.AllowFiltering = False Case col.UniqueName.ToLower.Contains("2") col.CurrentFilterFunction = GridKnownFunction.Contains col.ShowFilterIcon = False col.AutoPostBackOnFilter = True col.FilterControlWidth = New Unit (110, UnitType.Pixel) col.FilterControlToolTip = "Filter Data" Case col.UniqueName.ToLower.Contains("3") col.CurrentFilterFunction = GridKnownFunction.Contains col.ShowFilterIcon = False col.FilterControlToolTip = "Filter Data" col.AutoPostBackOnFilter = True col.ItemStyle.Width = New Unit(110) col.FilterControlWidth = New Unit(85, UnitType.Percentage) End Select End If End Sub End ClassEnd Namespace<telerik:RadGrid ID="grid1" runat="server" AutoGenerateColumns="true" Style="min-height: 50px;" OnNeedDataSource="grid1_NeedDataSource" Skin="Office2007" ShowFooter="true"> <MasterTableView CommandItemDisplay="Top" Width="885px"> <CommandItemTemplate> <table class="rcCommandTable" width="100%"> <td> <asp:LinkButton ID="btnExpandAll" runat="server" OnClientClick="ExpandAll(true); return false;" style="display: block;"> <img style="border:0px" alt="" src="../images/SinglePlus.gif" /> Expand All </asp:LinkButton> <asp:LinkButton ID="btnCollapseAll" runat="server" OnClientClick="ExpandAll(false); return false;" style="display: none;"> <img style="border:0px" alt="" src="../images/SingleMinus.gif" /> Collapse All </asp:LinkButton> </td> <td style="float: right"> <asp:Button ID="Button1" runat="server" Text=" " CssClass="rgExpXLS" CommandName="ExportToExcel" ToolTip="Export to Excel" /> <asp:Button ID="Button2" runat="server" Text=" " CssClass="rgExpPDF" CommandName="ExportToPdf" ToolTip="Export to PDF" /> </td> </table> </CommandItemTemplate> <CommandItemSettings ShowExportToExcelButton="true" ShowExportToPdfButton="true" ShowAddNewRecordButton="true" AddNewRecordText="Expand All" ShowRefreshButton="false"></CommandItemSettings> </MasterTableView> <ClientSettings EnableRowHoverStyle="true"> <ClientEvents OnRowSelected="RowSelected"></ClientEvents> <Scrolling AllowScroll="true" SaveScrollPosition="true" FrozenColumnsCount="5" UseStaticHeaders="true" /> <Resizing AllowColumnResize="false" /> <Selecting AllowRowSelect="true" /> </ClientSettings> <ExportSettings IgnorePaging="true" OpenInNewWindow="true" ExportOnlyData="true" FileName="Grid-Export"> <Pdf PageTitle="Risk Assessment" PageWidth="297mm" PageHeight="210mm" PageTopMargin="10mm" PageBottomMargin="10mm" PageLeftMargin="10mm" PageRightMargin="10mm" /> <Excel Format="ExcelML" FileExtension="xls" /> </ExportSettings> <HeaderStyle Width="150px" /></telerik:RadGrid>$.ajax({ type: 'POST', url: '../WebServices/GlobalEntityHelper.svc/GetEntityData', data: JSON.stringify({ request: JSON.stringify(dataToSend) }), contentType: 'application/json; charset=utf-8', dataType: 'json', success: function (result, status) { srcWindow.GlobalEntityRadCombobox.set_visible(result.d.Visible); if (srcWindow.GlobalEntityRadCombobox.get_visible()) { var entityItems = srcWindow.GlobalEntityRadCombobox.get_items(); entityItems.clear(); srcWindow.GlobalEntityRadCombobox.trackChanges(); for (var i = 0; i < result.d.DataSource.length; i++) { var entityItem = new Telerik.Web.UI.RadComboBoxItem(); entityItem.set_text(result.d.DataSource[i].Key); entityItem.set_value(result.d.DataSource[i].Value); entityItems.add(entityItem); } srcWindow.GlobalEntityRadCombobox.commitChanges(); ddlHilightOption(srcWindow.GlobalEntityRadCombobox, '', result.d.EntityValue); jQuery.data(srcWindow.GlobalEntityRadCombobox, 'filter-datamember', result.d.EntityFilterDataMember); srcWindow.GlobalEntityRadCombobox.prop('entityTypeConst', result.d.EntityTypeConst); } }, error: function (jqXHR, textStatus, errorThrown) { }protected void btnSubmitForm2_Click(object sender, System.EventArgs e) { if (ValidUserInfo()) { // Code to turn off RadAjaxManager ajax request for this call lblErrorMsg.Text = "Valid"; //Updated via full postback } else { lblErrorMsg.Text = "Invalid"; //Updated via RadAjaxManager } }<telerik:RadComboBox ID="rcbLanguages" runat="server" CheckBoxes="True" ClientIDMode="Static" EmptyMessage="Select Languages" Height="200px" Width="306px" EnableCheckAllItemsCheckBox="true"> <Items> <telerik:RadComboBoxItem Value="en" Text="English" /> <telerik:RadComboBoxItem Value="zh" Text="Chinese" /> <telerik:RadComboBoxItem Value="da" Text="Danish" /> <telerik:RadComboBoxItem Value="nl" Text="Dutch" /> <telerik:RadComboBoxItem Value="fr" Text="French" /> <telerik:RadComboBoxItem Value="de" Text="German" /> <telerik:RadComboBoxItem Value="el" Text="Greek" /> <telerik:RadComboBoxItem Value="he" Text="Hebrew" /> <telerik:RadComboBoxItem Value="hi" Text="Hindi" /> <telerik:RadComboBoxItem Value="it" Text="Italian" /> <telerik:RadComboBoxItem Value="ja" Text="Japanese" /> <telerik:RadComboBoxItem Value="la" Text="Latin" /> <telerik:RadComboBoxItem Value="pl" Text="Polish" /> <telerik:RadComboBoxItem Value="pt" Text="Portuguese" /> <telerik:RadComboBoxItem Value="ru" Text="Russian" /> <telerik:RadComboBoxItem Value="es" Text="Spanish" /> <telerik:RadComboBoxItem Value="th" Text="Thai" /> <telerik:RadComboBoxItem Value="vi" Text="Vietnamese" /> </Items></telerik:RadComboBox>Grid: /* Telerik RadGrid Telerik / embedded skin */ .RadGrid_MLightning { background: #F9F9F9; } .RadGrid_MLightning, .RadGrid_MLightning table, .GridFilterMenu_MLightning table { font: normal 9pt Tahoma; } .MasterTable_MLightning { border: 0px !important; border-collapse: separate !important; color: #000; /*-moz-user-select: none;*/ /*disables text selecting in Firefox to combat unpleasant visual appearance*/ } .MasterTable_MLightning td { padding:0px 0px 7px 0px; border-right :0px; } .MasterTable_MLightning th { background:#ffffff; text-align: left; } .RadGrid_MLightning td, .RadGrid_MLightning td a { color: #000; } th.GridHeader_MLightning, th.ResizeHeader_MLightning { background: #003e7e repeat-x 0 100%; border-right: solid 1px #FFFFFF; border-bottom: solid 1px #003e7e; border-top: solid 1px #003e7e; height: 16px; color: #ffffff; font-family:Tahoma; } th.GridHeader_MLightning, th.ResizeHeader_MLightning { padding:3px; } .GridHeader_MLightning a { color: #ffffff; text-decoration: none; } td.GridHeader_MLightning input { float: left; border: solid 1px #666; background: #fafafa; font: bold 11px Verdana, Arial, Sans-serif; color: #989cb0; height: 20px; vertical-align:middle; } .GridFilterRow_MLightning td { border-left: 1px solid #f9f9f9; background-color: #8FBCD1; empty-cells: hide; text-align:center; height: 16px; padding:0px 0px 0px 0px; } .GridRow_MLightning td, .GridAltRow_MLightning td, .SelectedRow_MLightning td, .ActiveRow_MLightning td, .GridEditRow_MLightning td { padding-top:2px; padding-bottom:2px; } .GridRow_MLightning { background: #ffffff; } .GridRow_MLightning td { white-space: normal; text-align: center; color: #898a8c; font-family: Tahoma; font-size: 8pt; padding: 10px 0px 10px 0px; border: solid 1px #C4C4C4; } .GridRow_MLightning td div { text-align: left; padding-left: 5px; } .GridRow_MLightning td a { color: #73abc9; font-family:Tahoma; font-size:8pt; } .GridAltRow_MLightning { background: #ffffff; } .GridAltRow_MLightning td { white-space:normal; text-align: center; color:#898a8c; font-family:Tahoma; font-size:8pt; padding: 10px 0px 10px 0px; border: solid 1px #C4C4C4; } .GridAltRow_MLightning td a { color: #73abc9; font-family:Tahoma; font-size:8pt; } .GridAltRow_MLightning td div { text-align: left; padding-left: 6px; } .SelectedRow_MLightning { background: #707070 url( '../../App_Themes/UTC/Grid/selectedRow.gif' ) repeat-x 50% bottom; } .SelectedRow_MLightning td { border-top: solid 1px #eaeaea; border-left: none; border-bottom: solid 1px #83c60b; padding-left:4px; } .GridEditRow_MLightning { background-color: #ffffe1; } .GridEditRow_MLightning input { font-size: 11px; } .ActiveRow_MLightning { background: #edf2d9; } .ActiveRow_MLightning td, .GridEditRow_MLightning td { border-top: solid 1px #eaeaea; border-left: solid 1px #eaeaea; border-bottom: solid 1px #fefefe; } .GridRowOver_MLightning { background:none #fff; } .GridPager_MLightning { background: #898a8c; color: #ffffff; } .GridPager_MLightning td { /*border: solid 1px #fff;*/ border: 1px solid #c7c7c7; border-right: 0; color: #999; height: 14px; padding-top: 1px; padding-bottom: 1px; font-family: Tahoma; font-size: 8pt; background: #898a8c; } .GridPager_MLightning td div { padding-left:0px; color: #ffffff; } .GridPager_MLightning td a { padding-left:1px; color: #ffffff; } .GridPager_MLightning td a:hover, .GridFooter_MLightning td a:hover { color: #333; } .PagerLeft_MLightning *, .PagerRight_MLightning *, .PagerCenter_MLightning * { vertical-align:middle; } .PagerLeft_MLightning, .PagerRight_MLightning, .sliderPagerLabel_MLightning { line-height:17px; padding-top:2px; } .PagerLeft_MLightning { float:left; } .PagerRight_MLightning, .sliderPagerLabel_MLightning { float:right; padding-right:4px; } .GridPager_MLightning .radslider { float:left; } .GridPager_MLightning img { border:0; } .GridPager_MLightning .radInput_MLightning { vertical-align:middle; } .PagerCenter_MLightning { display:block; text-align:center; } .GridFooter_MLightning { background: #6dabaa; height: 16px; color: #666; line-height: 10px; } .GridFooter_MLightning td { border: solid 2px #6dabaa; border-top: 1px solid #6dabaa; border-left: 7px solid #6dabaa; border-right: 7px solid #6dabaa; } .GridFooter_MLightning td a { color: #666; } tr.GroupHeader_MLightning { height: 22px; } tr.GroupHeader_MLightning td { border-left:0px solid #fff; border-right:0; border-bottom: solid 1px #c2c2c2; padding: 7px; } .GroupHeader_MLightning td div div{top:-0.5em;} * html .GroupHeader_MLightning td div div{top:0.4em;} *+html .GroupHeader_MLightning td div div{top:0.4em;} .GroupHeader_MLightning td div div div{top:0;} .GroupPanel_MLightning { background-color: #e8e8e8; width: 100%; border-collapse: collapse; border-bottom: 1px solid #b1b1b1; } .GroupPanel_MLightning td { padding: 2px 4px; } .GroupPanelItems_MLightning { background: #efefef; color: #999999; border: solid 1px white; border-right: solid 1px #c6c6c6; border-bottom: solid 1px #c6c6c6; white-space: nowrap; font-size: 10px; } .TopReorderIndicator_MLightning { background: url('../../App_Themes/UTC/Grid/MoveDown.gif') no-repeat; } .BottomReorderIndicator_MLightning { background: url('../../App_Themes/UTC/Grid/MoveUp.gif') no-repeat; } .GridFilterMenu_MLightning { cursor:default; } .GridFilterMenu_MLightning .GridFilterMenuSelectColumn_MLightning, .GridFilterMenu_MLightning .GridFilterMenuTextColumn_MLightning { padding:3px 4px; } .GridFilterMenu_MLightning .GridFilterMenuSelectColumn_MLightning { background:#f9f9f9; text-align:center; } .GridFilterMenu_MLightning .GridFilterMenuTextColumn_MLightning { background: #FFFFFF; color: #333; } .GridFilterMenu_MLightning .GridFilterMenuHover_MLightning { background:#c1f320; } /*AJAX Loading*/ .GridLoadingTemplate_MLightning { background:#fff !important; font:normal 24px/54px arial,sans-serif; color:#b5ea0e; } /*loading*/ .LoadingPanel_MLightning { background: url( 'Grid/loading.gif' ) center center no-repeat #fff; } /* rtl support */ .RadGridRTL_MLightning th, .RadGridRTL_MLightning td { text-align:center; } .RadGridRTL_MLightning .PagerLeft_MLightning, .RadGridRTL_MLightning .GridPager_MLightning .radslider { float:left; } .RadGridRTL_MLightning .PagerRight_MLightning, .RadGridRTL_MLightning .sliderPagerLabel_MLightning { float:left; } .GridCommandRow_MLightning { background: #a7a7a9; color: #ffffff; } .GridCommandRow_MLightning td { background: #a7a7a9; /*border: solid 1px #c7c7c7;*/ color: #ffffff; height: 16px; padding-top: 1px; padding-bottom: 1px; font-family: Tahoma; font-size: 9pt; text-align:right; } .GridCommandRow_MLightning td a { /*color: #73abc9;*/ text-align:right; } Input: /*Telerik RadInput M Lightning Skin*/ .datePicker { background-color: #F6F6F6; border: 1px solid #CCCCCC; font-family: Tahoma,verdana,sans-serif; font-size: 12px; padding: 3px; padding-right:0px; } /*global*/ .radInput_MLightning { font-family: tahoma; font-size: 9pt; vertical-align: middle; color:#898a8c; } .radInput_MLightning table, .radInput_MLightning table td { border: 0; } .radInput_MLightning table { vertical-align: bottom; } .radInput_MLightning td { padding: 0; vertical-align: middle; overflow: visible; /*RadGrid*/ } .radInput_MLightning td.inputCell { padding-right: 2px; } .radInput_MLightning textarea { vertical-align: middle; overflow: auto; display: block; } /*textbox states*/ .radEnabledCss_MLightning, .radEmptyMessageCss_MLightning, .radHoverCss_MLightning, .radFocusedCss_MLightning, .radReadOnlyCss_MLightning, .radDisabledCss_MLightning, .radNegativeCss_MLightning, .radInvalidCss_MLightning { font-family: Tahoma,verdana,sans-serif; border: 1px solid #666666; background-color: #FFFFFF; padding: 3px; font-size: 9pt; color:#898a8c; } .radEnabledCss_MLightning { } .radEmptyMessageCss_MLightning { } .radHoverCss_MLightning { } .radFocusedCss_MLightning { } .radReadOnlyCss_MLightning, .radDisabledCss_MLightning { color: gray; background: #eee; } .radNegativeCss_MLightning { } .radInvalidCss_MLightning { background: url('Input/sprite.gif') 99% -183px no-repeat; color: #f32800; } /*buttons*/ .radInput_MLightning a { display: block; text-indent: -4444px; overflow: hidden; position: relative; /*FF*/ outline: none; /*FF*/ z-index: 2; /*Opera*/ background: url('Input/sprite.gif') no-repeat; } * html .radInput_MLightning a { position: static; } /*IE6*/ * + html .radInput_MLightning a { position: static; } /*IE7*/ /*go*/ .radInput_MLightning a.gobutton { width: 20px; height: 17px; line-height: 17px; background-position: 3px 4px; } /*spin*/ .radInput_MLightning a.spinbutton { width: 13px; height: 7px; line-height: 7px; margin: 0 1px; } .radInput_MLightning a.up { background-position: 3px -36px; } .radInput_MLightning a.down { background-position: 3px -64px; margin-top: 2px; } /*label*/ .radLabelCss_MLightning { margin: 0 4px 0 0; color: #000; white-space: nowrap; }