RadGrid_DetailsView.MasterTableView.ExportToExcel();
I want to set the header on each page that says
"This is the DRAFT Data".
How can I accomplish that.
Thanks.
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>
<!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
>
</
head
>
<
body
>
<
form
id
=
"form1"
runat
=
"server"
>
<
telerik:RadScriptManager
ID
=
"RadScriptManager1"
Runat
=
"server"
>
</
telerik:RadScriptManager
>
<
div
>
<
asp:SqlDataSource
ID
=
"SqlDataSource1"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:Processos8ConnectionString %>"
SelectCommand="SELECT [Sinistrado], [Sinistrado_ID] FROM [Sinistrados]">
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"SqlDataSource2"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:Processos8ConnectionString %>"
SelectCommand="SELECT [Sinistrado_ID], [Sinistro_ID], [Tomador_ID], [Boletim_id] FROM [Boletins]">
</
asp:SqlDataSource
>
</
div
>
<
telerik:RadComboBox
ID
=
"RadComboBox1"
Runat
=
"server"
DataSourceID
=
"SqlDataSource1"
DataTextField
=
"Sinistrado"
DataValueField
=
"Sinistrado_ID"
AllowCustomText
=
"True"
AutoCompleteSeparator
=
"|"
AutoPostBack
=
"True"
ItemsPerRequest
=
"20"
MarkFirstMatch
=
"True"
ShowMoreResultsBox
=
"True"
EnableAutomaticLoadOnDemand
=
"True"
>
</
telerik:RadComboBox
>
<
telerik:RadTextBox
ID
=
"RadTextBox1"
Runat
=
"server"
>
</
telerik:RadTextBox
>
<
telerik:RadTextBox
ID
=
"RadTextBox2"
Runat
=
"server"
>
</
telerik:RadTextBox
>
<
telerik:RadComboBox
ID
=
"RadComboBox2"
Runat
=
"server"
DataSourceID
=
"SqlDataSource1"
DataTextField
=
"Sinistrado"
DataValueField
=
"Sinistrado_ID"
AllowCustomText
=
"True"
AutoCompleteSeparator
=
"|"
AutoPostBack
=
"True"
ItemsPerRequest
=
"20"
MarkFirstMatch
=
"True"
ShowMoreResultsBox
=
"True"
EnableAutomaticLoadOnDemand
=
"True"
>
</
telerik:RadComboBox
>
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
CellSpacing
=
"0"
DataSourceID
=
"SqlDataSource2"
GridLines
=
"None"
AutoGenerateColumns
=
"False"
>
<
HeaderContextMenu
CssClass
=
"GridContextMenu GridContextMenu_Default"
></
HeaderContextMenu
>
<
MasterTableView
datakeynames
=
"Boletim_id"
datasourceid
=
"SqlDataSource2"
>
<
CommandItemSettings
ExportToPdfText
=
"Export to PDF"
></
CommandItemSettings
>
<
RowIndicatorColumn
FilterControlAltText
=
"Filter RowIndicator column"
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
FilterControlAltText
=
"Filter ExpandColumn column"
>
<
HeaderStyle
Width
=
"20px"
></
HeaderStyle
>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridButtonColumn
Text
=
"Select"
CommandName
=
"Select"
ButtonType
=
"ImageButton"
ImageUrl
=
"~/images/select_16_mouse.png"
>
</
telerik:GridButtonColumn
>
<
telerik:GridBoundColumn
DataField
=
"Sinistrado_ID"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter Sinistrado_ID column"
HeaderText
=
"Sinistrado_ID"
SortExpression
=
"Sinistrado_ID"
UniqueName
=
"Sinistrado_ID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Sinistro_ID"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter Sinistro_ID column"
HeaderText
=
"Sinistro_ID"
SortExpression
=
"Sinistro_ID"
UniqueName
=
"Sinistro_ID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Tomador_ID"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter Tomador_ID column"
HeaderText
=
"Tomador_ID"
SortExpression
=
"Tomador_ID"
UniqueName
=
"Tomador_ID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"Boletim_id"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter Boletim_id column"
HeaderText
=
"Boletim_id"
ReadOnly
=
"True"
SortExpression
=
"Boletim_id"
UniqueName
=
"Boletim_id"
>
</
telerik:GridBoundColumn
>
</
Columns
>
<
EditFormSettings
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
></
EditColumn
>
</
EditFormSettings
>
</
MasterTableView
>
<
ClientSettings
>
<
Selecting
AllowRowSelect
=
"True"
/>
</
ClientSettings
>
<
FilterMenu
EnableImageSprites
=
"False"
></
FilterMenu
>
</
telerik:RadGrid
>
</
form
>
</
body
>
</
html
>
Imports
Telerik.Web.UI
Imports
System.IO
Imports
System.Data.SqlClient
Imports
System.Configuration
Imports
System.Data
Imports
System.Net
Partial
Class
_Default
Inherits
System.Web.UI.Page
Protected
Sub
RadComboBox1_SelectedIndexChanged(
ByVal
sender
As
Object
,
ByVal
e
As
Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs)
Handles
RadComboBox1.SelectedIndexChanged
SqlDataSource2.SelectCommand =
"SELECT [Sinistrado_ID], [Sinistro_ID], [Tomador_ID], [Boletim_id] FROM [Boletins] WHERE SINISTRADO_ID = "
& RadComboBox1.SelectedValue
RadGrid1.DataBind()
RadComboBox1.SelectedIndex = RadComboBox1.SelectedIndex
End
Sub
Protected
Sub
RadGrid1_SelectedIndexChanged(
ByVal
sender
As
Object
,
ByVal
e
As
System.EventArgs)
Handles
RadGrid1.SelectedIndexChanged
Dim
boletim_id
As
String
=
DirectCast
(RadGrid1.SelectedItems.Item(0), GridDataItem).Cells(6).Text.ToString
RadTextBox1.Text =
DirectCast
(RadGrid1.SelectedItems.Item(0), GridDataItem).Cells(5).Text.ToString
RadTextBox2.Text =
DirectCast
(RadGrid1.SelectedItems.Item(0), GridDataItem).Cells(4).Text.ToString
Dim
x
As
Integer
= RadComboBox2.FindItemIndexByValue(boletim_id)
'Dim z As Integer = RadComboBox1.SelectedItem.Index
RadComboBox1.Text =
""
RadComboBox1.SelectedValue =
""
RadComboBox2.SelectedIndex = RadComboBox2.FindItemIndexByValue(boletim_id)
RadComboBox2.SelectedIndex = RadComboBox1.SelectedItem.Index
End
Sub
End
Class
RadGrid does not support mixing declarative grid columns with grid columns added dynamically at runtime. You should either create all the columns in the grid programmatically, or else define them all in the ASPX file.
How to further build the Grid?
Thanks
Teldev
Hi,
I am getting the formatting problem in RADGRID. the header columns are not getting aligned with the code.
Kindly, see the below code and suggest a solution:
<rad:radgrid id="rgvCRSummary" runat="server" gridlines="both" height="115px" isdynamic="False"
skin="Master" skinspath="~/App_Themes/MasterTheme/Skins" width="100%">
<HeaderStyle CssClass="Grid_headerHP" />
<ItemStyle CssClass="Grid_ItemHP" />
<AlternatingItemStyle CssClass="Grid_ItemHP" />
<SelectedItemStyle CssClass="Grid_SelectedHP" />
<MasterTableView EnableColumnsViewState="true" TableLayout="Fixed" Width="100%">
<Columns>
<rad:GridBoundColumn DataField="heading" UniqueName="heading" DataFormatString = "<nobr>{0}</nobr>"><HeaderStyle Width="30%" /></rad:GridBoundColumn>
<rad:GridBoundColumn DataField="sales_pos" HeaderText="<nobr>Sales Position</nobr>" UniqueName="sales_pos" DataFormatString = "<nobr>{0}</nobr>"></rad:GridBoundColumn>
<rad:GridBoundColumn DataField="Geo" HeaderText="Geography" UniqueName="Geo" DataFormatString = "<nobr>{0}</nobr>"></rad:GridBoundColumn>
<rad:GridBoundColumn DataField="Acc" HeaderText="Account" UniqueName="Acc" DataFormatString = "<nobr>{0}</nobr>"></rad:GridBoundColumn>
<rad:GridBoundColumn DataField="Presc" HeaderText="Prescriber" UniqueName="Presc" DataFormatString = "<nobr>{0}</nobr>"></rad:GridBoundColumn>
</Columns>
</MasterTableView>
</rad:radgrid>
Please find the attached file as my web page having RadGrid.
I am using the radgrid version 5.1.1.0 and IE8 as my web browser.
Please suggest me how can we resolve with this misalignment of column with this version.
Thanks,
Manoj Singh
Hi ,
My asp.net page contains a radscheduler , whenever I view this page I get the following error.
System.Security.Cryptography.CryptographicException: Padding is invalid and cannot be removed.
at System.Security.Cryptography.RijndaelManagedTransform.DecryptData(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount, Byte[]& outputBuffer, Int32 outputOffset, PaddingMode paddingMode, Boolean fLast)
at System.Security.Cryptography.RijndaelManagedTransform.TransformFinalBlock(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount)
at System.Security.Cryptography.CryptoStream.FlushFinalBlock()
at System.Web.Configuration.MachineKeySection.EncryptOrDecryptData(Boolean fEncrypt, Byte[] buf, Byte[] modifier, Int32 start, Int32 length, IVType ivType, Boolean useValidationSymAlgo)
at System.Web.UI.Page.DecryptStringWithIV(String s, IVType ivType)
at System.Web.Handlers.AssemblyResourceLoader.System.Web.IHttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)