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