<
telerik:RadGrid
runat
=
"server"
AllowPaging
=
"True"
PageSize
=
"3"
ShowFooter
=
"True"
DataSourceID
=
"SqlDataSource1"
Skin
=
"Office2007"
CellSpacing
=
"0"
GridLines
=
"None"
Height
=
"350px"
Width
=
"260px"
ID
=
"RadGrid1"
ViewStateMode
=
"Enabled"
>
<
ClientSettings
AllowColumnsReorder
=
"True"
EnablePostBackOnRowClick
=
"True"
ReorderColumnsOnClient
=
"True"
>
<
Selecting
AllowRowSelect
=
"True"
/>
</
ClientSettings
>
<
MasterTableView
DataKeyNames
=
"ID"
DataSourceID
=
"SqlDataSource1"
AutoGenerateColumns
=
"False"
ShowHeader
=
"False"
>
<
CommandItemSettings
ExportToPdfText
=
"Export to PDF"
></
CommandItemSettings
>
<
RowIndicatorColumn
Visible
=
"False"
FilterControlAltText
=
"Filter RowIndicator column"
></
RowIndicatorColumn
>
<
ExpandCollapseColumn
Visible
=
"False"
FilterControlAltText
=
"Filter ExpandColumn column"
></
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"url"
HeaderText
=
"url"
SortExpression
=
"url"
Visible
=
"False"
UniqueName
=
"url"
FilterControlAltText
=
"Filter url column"
></
telerik:GridBoundColumn
>
<
telerik:GridImageColumn
DataImageUrlFields
=
"urlImage"
ImageWidth
=
""
ImageHeight
=
""
HeaderText
=
"urlImage"
SortExpression
=
"urlImage"
UniqueName
=
"urlImage"
FilterControlAltText
=
"Filter urlImage column"
></
telerik:GridImageColumn
>
<
telerik:GridBoundColumn
DataField
=
"description"
HeaderText
=
"description"
SortExpression
=
"description"
UniqueName
=
"description"
FilterControlAltText
=
"Filter description column"
>
<
ItemStyle
Font-Size
=
"11pt"
></
ItemStyle
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"ID"
ReadOnly
=
"True"
HeaderText
=
"ID"
SortExpression
=
"ID"
Visible
=
"False"
UniqueName
=
"ID"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter ID column"
></
telerik:GridBoundColumn
>
</
Columns
>
<
EditFormSettings
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
></
EditColumn
>
</
EditFormSettings
>
<
PagerStyle
Mode
=
"NumericPages"
AlwaysVisible
=
"True"
></
PagerStyle
>
</
MasterTableView
>
<
FilterMenu
EnableImageSprites
=
"False"
></
FilterMenu
>
</
telerik:RadGrid
>
Private
Sub
RadGrid1_SelectedIndexChanged(sender
As
Object
, e
As
EventArgs)
Handles
RadGrid1.SelectedIndexChanged
Dim
newwindow
As
New
Telerik.Web.UI.RadWindow()
newwindow.ID =
"RadWindow1"
newwindow.NavigateUrl =
"http://www.google.com"
newwindow.VisibleOnPageLoad =
True
RadWindowManager1.Windows.Add(newwindow)
End
Sub
Telerik.Web.UI.GridExcelBuilder.
RowElement row = new Telerik.Web.UI.GridExcelBuilder.RowElement();
Telerik.Web.UI.GridExcelBuilder.
CellElement cell = new Telerik.Web.UI.GridExcelBuilder.CellElement();
cell.Data.DataItem =
"NYC";
cell.StyleValue =
"MyHeaderStyle";
cell.MergeAcross = e.Row.Cells.Count - 1;
row.Cells.Add(cell);
e.Worksheet.Table.Rows.Insert(0, row);
And then I style this header:
Telerik.Web.UI.GridExcelBuilder.
StyleElement myStyleH = new Telerik.Web.UI.GridExcelBuilder.StyleElement("MyHeaderStyle");
myStyleH.FontStyle.Size = 25;
myStyleH.FontStyle.Bold =
true;
System.Drawing.
Color col = System.Drawing.ColorTranslator.FromHtml("#2C78FF");
myStyleH.FontStyle.Color = col;
myStyleH.AlignmentElement.HorizontalAlignment = Telerik.Web.UI.GridExcelBuilder.
HorizontalAlignmentType.Center;
e.Styles.Add(myStyleH);
My question is:I need colored "NYC" header like this:
"N" - with the green color
"Y" - with the orange color
"C" - with the blue color.
How can I do that?
Thanks so much for your help.
protected
void
myDatePicker_SelectedDateChanged(
object
sender, Telerik.Web.UI.Calendar.SelectedDateChangedEventArgs e)
{
RadListViewDataItem r =
new
RadListViewDataItem(myRadListView, 0);
r.FireCommandEvent(
"InitInsert"
, String.Empty);
}