or
//... <script type="text/javascript"> function pageLoad() { var dataPane = $find('<%= this.SplitterPlaceholder.FindControl("LeftContentPane").ClientID %>'); dataPane.setVarSize($(window).width()); } </script> //... <telerik:RadSplitter ID="RadSplitter1" Height="100%" runat="server" ClientIDMode="AutoID"> <telerik:RadPane ID="ContentPane" runat="server"> <telerik:RadSplitter ID="Radsplitter2" runat="server" Orientation="Vertical"> <telerik:RadPane ID="RadPane1" runat="server" ContentUrl="Data.aspx" /> <asp:ContentPlaceholder ID="SplitterPlaceholder" runat="server" /> <telerik:RadSplitBar ID="ContentSplitBar" runat="server" /> <telerik:RadPane ID="RightContentPane" ContentUrl="Map.aspx" runat="server"> </telerik:RadPane> </telerik:RadSplitter> </telerik:RadPane> <telerik:RadSplitBar ID="RadSplitBar2" runat="server" /> <telerik:RadPane ID="BottomPane" runat="server"> </telerik:RadPane> </telerik:RadSplitter> //..<%@ Page Language="C#" MasterPageFile="~/Default.Master" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="UIProject.Default" %> <asp:Content id="Pane" ContentPlaceholderID="SplitterPlaceholder" runat="server"> <telerik:RadPane ID="LeftContentPane" runat="server" ContentUrl="Data.aspx" /> </asp:Content><telerik:GridTemplateColumn HeaderText="Product ID" HeaderStyle-Font-Bold="true" AllowFiltering="true" DataField="ProductID"> <EditItemTemplate> <telerik:RadComboBox ID="RadCbProductIDEdit" Skin="Office2007" runat="server" MarkFirstMatch="true" AllowCustomText="true" DataValueField="ProductID" EmptyMessage="Please select a ProductID " DataTextField="ProductID" DataSourceID="LinqDataSource1" Height="100px"> </telerik:RadComboBox> </EditItemTemplate> <InsertItemTemplate> <telerik:RadComboBox ID="RadcbProductIDInsert" runat="server" Skin="Office2007" MarkFirstMatch="true" AllowCustomText="true" DataValueField="ProductID" EmptyMessage="Please select a ProductID " DataTextField="ProductID" DataSourceID="LinqDataSource1" Height="100px"> </telerik:RadComboBox> </InsertItemTemplate> <ItemTemplate> <asp:Label ID="lblProductID" runat="server" Text='<%# Bind("ProductID") %>'></asp:Label> </ItemTemplate> <HeaderStyle Font-Bold="True" /> </telerik:GridTemplateColumn><asp:LinqDataSource ID="LinqDataSource1" runat="server" ContextTypeName="LPSFPrototypeScreens.tblProduct" EntityTypeName="" Select="new (ProductID)" TableName="tblProductFeatures" >Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click Dim radgrid2 As New RadGrid radgrid2.AutoGenerateColumns = True radgrid2.ID = "RadGrid2" Me.PlaceHolder1.Controls.Add(radgrid2) connSql.ConnectionString = sqlConn.ToString() Dim poSqlCom As New SqlCommand("dbo.getCurrQtrAll", connSql) poSqlCom.CommandType = CommandType.StoredProcedure poSqlCom.Parameters.AddWithValue("@UID", "SomeoneElse") Dim adapter As New SqlDataAdapter(poSqlCom) Dim links As New DataTable() Try adapter.Fill(links) Catch ex As Exception 'lblResult.Text = ex.Message If connSql.State = ConnectionState.Open Then connSql.Close() End If End Try radgrid2.DataSource = links radgrid2.Rebind() radgrid2.ExportSettings.Excel.FileExtension = "xls" radgrid2.ExportSettings.FileName = "Cur_Qtr_Rpt" radgrid2.ExportSettings.ExportOnlyData = True radgrid2.ExportSettings.IgnorePaging = True radgrid2.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML radgrid2.MasterTableView.ExportToExcel()End Sub <telerik:RadGrid ID="timesheetGrid" runat="server" GridLines="None" Skin="Windows7" AllowSorting="True" ShowGroupPanel="True" AutoGenerateColumns="False" AllowPaging="True" PageSize="15" ShowStatusBar="True" AllowFilteringByColumn="True" AllowMultiRowSelection="True" OnNeedDataSource="timesheetGrid_NeedDataSource" OnPreRender="timesheetGrid_PreRender" ViewStateMode="Enabled" HeaderStyle-HorizontalAlign="Center" OnEditCommand="timesheetGrid_EditCommand"> <ClientSettings EnableRowHoverStyle="true" AllowColumnsReorder="True" ReorderColumnsOnClient="True" AllowDragToGroup="True"> <Selecting AllowRowSelect="True" /> <ClientEvents OnRowDblClick="RowDblClick" /> </ClientSettings> <MasterTableView DataKeyNames="ID" EditMode="EditForms"> <RowIndicatorColumn> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings> <Columns> <telerik:GridClientSelectColumn UniqueName="ClientSelectColumn" /> <telerik:GridBoundColumn DataField="ID" HeaderText="ID" UniqueName="ID" Visible="True" ReadOnly="true" FilterControlWidth="30px" HeaderStyle-Width="50px"><HeaderStyle Width="50px"></HeaderStyle> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn DataField="Date" DataType="System.DateTime" HeaderText="Date" UniqueName="DateFrom" ReadOnly="true" DataFormatString="{0:dd/MM/yyyy}" AllowFiltering="false" HeaderStyle-Width="75px"> <HeaderStyle Width="75px"></HeaderStyle> </telerik:GridDateTimeColumn> <telerik:GridBoundColumn DataField="User.UserName" HeaderText="User" UniqueName="User" ReadOnly="true"> </telerik:GridBoundColumn> <telerik:GridNumericColumn UniqueName="Duration" HeaderText="Duration (Hrs)" DataType="System.Double" DataField="Duration" FilterControlWidth="50px"> <HeaderStyle Width="80px"></HeaderStyle> <ItemStyle HorizontalAlign="Right" /> </telerik:GridNumericColumn> <telerik:GridBoundColumn DataField="ShortDescription" HeaderText="Description" UniqueName="Description"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="DocketNo" HeaderText="Docket No" UniqueName="DocketNo" ReadOnly="true" FilterControlWidth="50px" HeaderStyle-Width="70px"><HeaderStyle Width="70px"></HeaderStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="FileCode" HeaderText="FileCode Name" UniqueName="FileCode" HeaderStyle-Width="100px" FilterControlWidth="60px"><HeaderStyle Width="100px"></HeaderStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="FileCodeID" HeaderText="FileCode ID" UniqueName="FileCodeID" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CostCenter" HeaderText="Cost Center" UniqueName="CostCenter" HeaderStyle-Width="70px" FilterControlWidth="40px"><HeaderStyle Width="70px"></HeaderStyle> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CostCenterID" HeaderText="Cost Center ID" UniqueName="CostCenterID" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CompanyID" HeaderText="Company ID" UniqueName="CompanyID" Visible="false"> </telerik:GridBoundColumn> <telerik:GridCheckBoxColumn DataField="IsOvertime" DataType="System.Boolean" HeaderText="Overtime" UniqueName="Overtime" ReadOnly="true"> </telerik:GridCheckBoxColumn> </Columns> <EditFormSettings UserControlName="UserControls/TimesheetEdit.ascx" EditFormType="WebUserControl"> <EditColumn FilterControlAltText="Filter EditCommandColumn column"> </EditColumn> </EditFormSettings> </MasterTableView> <HeaderStyle HorizontalAlign="Center"></HeaderStyle> <PagerStyle Mode="NumericPages" VerticalAlign="Bottom" /> <FilterMenu EnableImageSprites="False"> </FilterMenu> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Windows7"> </HeaderContextMenu> </telerik:RadGrid>