Right now the only way to do data-binding in the markup is to use NameField, DataFieldY, ColorField within the PieSeries tag. This requires a per record model. My current need requires a per field model such as with some of your other controls.
You include an Items tag where each telerik:SeriesItem can be manually defined. If I could data-bind them, then I could do something such as:
<
Items
>
<
telerik:SeriesItem
NameField
=
"A1"
DataFieldY
=
"B1"
ColorField
=
"C1"
/>
<
telerik:SeriesItem
NameField
=
"A2"
DataFieldY
=
"B2"
ColorField
=
"C2"
/>
<
telerik:SeriesItem
NameField
=
"A3"
DataFieldY
=
"B3"
ColorField
=
"C3"
/>
</
Items
>
To give some context my current usage is:
RadPanelBar
ItemTemplate
Panel
RadHtmlChart + asp:Table
So you see I need to be able to do the data within the chart all as one record. This works as I know I have a static amount of items for the PieSeries. Currently I've been doing this all in my codebehind as I can do a local pivot of a subset of each record and treat it as three separate records:
DataTable chartData = GetChartData();
radHtmlChart.DataSource = chartData;
radHtmlChart.DataBind();
PieSeries pieChartSeries =
new
PieSeries();
pieChartSeries.NameField =
"Name"
;
pieChartSeries.DataFieldY =
"Percentage"
;
pieChartSeries.ColorField =
"Color"
;
radHtmlChart.PlotArea.Series.Add(pieChartSeries);
Now I know it's possible to bind my chart to a separate datasource, but I'd rather not do a whole new query. If there were a way to have a source use another source and pivot the data such as an adapter, then I'd be open to that as well. I'm still new to all of this on the markup side of things and haven't learned enough of the differences between a asp:SqlDataSource and telerik:RadClientDataSource for example.
Thanks!
Please see my grid HTML below. It used <telerik:GridTemplateColumn> and also <ItemTemplate> which may not support Virtualization.
What to changes to make for enabling Virtualization here?
001.
<
telerik:GridBoundColumn
UniqueName
=
"CourseID"
DataField
=
"CourseID"
Visible
=
"false"
/>
002.
003.
<
HeaderStyle
HorizontalAlign
=
"Center"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"8pt"
>
004.
</
HeaderStyle
>
005.
<
ItemStyle
HorizontalAlign
=
"Center"
VerticalAlign
=
"Middle"
Font-Size
=
"8pt"
Width
=
"5%"
>
006.
</
ItemStyle
>
007.
</
telerik:GridBoundColumn
>
008.
<
telerik:GridBoundColumn
UniqueName
=
"ChoiceName"
DataField
=
"ChoiceName"
HeaderText
=
"Choice"
009.
HeaderStyle-HorizontalAlign
=
"Center"
ItemStyle-Width
=
"5%"
HeaderStyle-Font-Bold
=
"true"
010.
HeaderStyle-Font-Size
=
"8"
HeaderStyle-Font-Names
=
"Arial"
ItemStyle-Font-Size
=
"8"
011.
ItemStyle-HorizontalAlign
=
"Center"
ItemStyle-VerticalAlign
=
"Middle"
FooterText
=
""
012.
Visible
=
"true"
>
013.
<
HeaderStyle
HorizontalAlign
=
"Center"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"8pt"
>
014.
</
HeaderStyle
>
015.
<
ItemStyle
HorizontalAlign
=
"Center"
VerticalAlign
=
"Middle"
Font-Size
=
"8pt"
Width
=
"5%"
>
016.
</
ItemStyle
>
017.
</
telerik:GridBoundColumn
>
018.
<
telerik:GridBoundColumn
UniqueName
=
"ChoiceNo"
DataField
=
"ChoiceNo"
HeaderText
=
"Choice No"
019.
Visible
=
"false"
HeaderStyle-Font-Bold
=
"true"
HeaderStyle-Font-Size
=
"8"
HeaderStyle-Font-Names
=
"Arial"
020.
ItemStyle-Font-Size
=
"8"
ItemStyle-HorizontalAlign
=
"Center"
ItemStyle-VerticalAlign
=
"Middle"
>
021.
<
HeaderStyle
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"8pt"
></
HeaderStyle
>
022.
<
ItemStyle
HorizontalAlign
=
"Center"
VerticalAlign
=
"Middle"
Font-Size
=
"8pt"
></
ItemStyle
>
023.
</
telerik:GridBoundColumn
>
024.
<
telerik:GridBoundColumn
UniqueName
=
"RatioPercent"
DataField
=
"RatioPercent"
HeaderText
=
"Ratio Percent"
025.
HeaderStyle-HorizontalAlign
=
"Center"
ItemStyle-Width
=
"5%"
HeaderStyle-Font-Bold
=
"true"
026.
HeaderStyle-Font-Size
=
"8"
HeaderStyle-Font-Names
=
"Arial"
ItemStyle-Font-Size
=
"8"
027.
ItemStyle-HorizontalAlign
=
"Center"
ItemStyle-VerticalAlign
=
"Middle"
FooterText
=
""
028.
Visible
=
"true"
>
029.
<
HeaderStyle
HorizontalAlign
=
"Center"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"8pt"
>
030.
</
HeaderStyle
>
031.
<
ItemStyle
HorizontalAlign
=
"Center"
VerticalAlign
=
"Middle"
Font-Size
=
"8pt"
Width
=
"5%"
>
032.
</
ItemStyle
>
033.
</
telerik:GridBoundColumn
>
034.
<
telerik:GridBoundColumn
UniqueName
=
"Equipment"
DataField
=
"Equipment"
HeaderText
=
"Equipment"
035.
HeaderStyle-HorizontalAlign
=
"Center"
ItemStyle-Width
=
"5%"
HeaderStyle-Font-Bold
=
"true"
036.
HeaderStyle-Font-Size
=
"8"
HeaderStyle-Font-Names
=
"Arial"
ItemStyle-Font-Size
=
"8"
037.
ItemStyle-HorizontalAlign
=
"Center"
ItemStyle-VerticalAlign
=
"Middle"
FooterText
=
""
038.
Visible
=
"true"
>
039.
<
HeaderStyle
HorizontalAlign
=
"Center"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"8pt"
>
040.
</
HeaderStyle
>
041.
<
ItemStyle
HorizontalAlign
=
"Center"
VerticalAlign
=
"Middle"
Font-Size
=
"8pt"
Width
=
"5%"
>
042.
</
ItemStyle
>
043.
</
telerik:GridBoundColumn
>
044.
<
telerik:GridBoundColumn
UniqueName
=
"Temperature"
DataField
=
"Temperature"
HeaderText
=
"Temperature"
045.
HeaderStyle-HorizontalAlign
=
"Center"
ItemStyle-Width
=
"5%"
HeaderStyle-Font-Bold
=
"true"
046.
HeaderStyle-Font-Size
=
"8"
HeaderStyle-Font-Names
=
"Arial"
ItemStyle-Font-Size
=
"8"
047.
ItemStyle-HorizontalAlign
=
"Center"
ItemStyle-VerticalAlign
=
"Middle"
FooterText
=
""
048.
Visible
=
"true"
>
049.
<
HeaderStyle
HorizontalAlign
=
"Center"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"8pt"
>
050.
</
HeaderStyle
>
051.
<
ItemStyle
HorizontalAlign
=
"Center"
VerticalAlign
=
"Middle"
Font-Size
=
"8pt"
Width
=
"5%"
>
052.
</
ItemStyle
>
053.
</
telerik:GridBoundColumn
>
054.
<%--Cycle1 Starts--%>
055.
<
telerik:GridTemplateColumn
UniqueName
=
"Cy1"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Cycle 1"
HeaderStyle-Font-Bold
=
"true"
056.
HeaderStyle-Font-Size
=
"8pt"
ColumnGroupName
=
"C1"
HeaderStyle-Font-Names
=
"Arial"
ItemStyle-Font-Size
=
"8"
ItemStyle-VerticalAlign
=
"Top"
FooterText
=
""
>
057.
<
ItemTemplate
>
058.
<
telerik:RadGrid
ID
=
"Cycle1Grid"
runat
=
"server"
ShowGroupPanel
=
"false"
AllowSorting
=
"false"
GridLines
=
"Both"
ShowFooter
=
"false"
059.
AllowPaging
=
"false"
AutoGenerateColumns
=
"false"
060.
HeaderStyle-CssClass
=
"tableHeading br"
EnableViewState
=
"false"
>
061.
<
ClientSettings
>
062.
<
ClientEvents
OnRowDataBound
=
"gridRowBound"
/>
063.
</
ClientSettings
>
064.
<
MasterTableView
Name
=
"tblCycle1"
ShowGroupFooter
=
"true"
GridLines
=
"Both"
TableLayout
=
"Fixed"
065.
DataKeyNames
=
"PK_Dish_id"
>
066.
<
Columns
>
067.
<
telerik:GridBoundColumn
UniqueName
=
"PK_Dish_id"
DataField
=
"PK_Dish_id"
Visible
=
"false"
/>
068.
<
telerik:GridBoundColumn
UniqueName
=
"FK_Choice_Cycle_ID"
DataField
=
"FK_Choice_Cycle_ID"
069.
Visible
=
"false"
/>
070.
<
telerik:GridBoundColumn
UniqueName
=
"QMOS_DISH_ID"
DataField
=
"QMOS_DISH_ID"
Visible
=
"false"
/>
071.
<
telerik:GridBoundColumn
UniqueName
=
"FOOD_ARCHV"
DataField
=
"FOOD_ARCHV"
Visible
=
"false"
/>
072.
<
telerik:GridBoundColumn
UniqueName
=
"IsActive"
DataField
=
"IsActive"
Visible
=
"false"
/>
073.
<
telerik:GridBoundColumn
UniqueName
=
"EDUOM"
DataField
=
"UOM"
Visible
=
"false"
/>
074.
<
telerik:GridBoundColumn
UniqueName
=
"choiceNum"
DataField
=
"choiceNum"
Visible
=
"false"
/>
075.
<
telerik:GridBoundColumn
UniqueName
=
"Flow"
DataField
=
"Flow"
Visible
=
"false"
/>
076.
<
telerik:GridBoundColumn
UniqueName
=
"cycleNum"
DataField
=
"cycleNum"
Visible
=
"false"
/>
077.
<
telerik:GridBoundColumn
UniqueName
=
"ChoiceNo"
DataField
=
"ChoiceNo"
Visible
=
"false"
/>
078.
<
telerik:GridBoundColumn
UniqueName
=
"EdCourseId"
DataField
=
"EdCourseId"
Visible
=
"false"
/>
079.
<
telerik:GridBoundColumn
UniqueName
=
"EdChoiceId"
DataField
=
"EdChoiceId"
Visible
=
"false"
/>
080.
<
telerik:GridBoundColumn
UniqueName
=
"FoodItem"
DataField
=
"FoodItem"
HeaderText
=
"Description"
HeaderStyle-Font-Bold
=
"true"
081.
HeaderStyle-Font-Size
=
"8"
HeaderStyle-Font-Names
=
"Arial"
ItemStyle-Font-Size
=
"8"
ItemStyle-HorizontalAlign
=
"Left"
ItemStyle-VerticalAlign
=
"Middle"
>
082.
<
HeaderStyle
HorizontalAlign
=
"Left"
Width
=
"180px"
CssClass
=
"sampleTest"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"8pt"
></
HeaderStyle
>
083.
<
ItemStyle
HorizontalAlign
=
"Left"
VerticalAlign
=
"Middle"
></
ItemStyle
>
084.
</
telerik:GridBoundColumn
>
085.
<
telerik:GridBoundColumn
UniqueName
=
"Qty"
DataField
=
"Qty"
HeaderText
=
"Qty"
HeaderStyle-Font-Bold
=
"true"
HeaderStyle-Font-Size
=
"8"
HeaderStyle-Font-Names
=
"Arial"
086.
ItemStyle-Font-Size
=
"8"
ItemStyle-HorizontalAlign
=
"Right"
ItemStyle-VerticalAlign
=
"Middle"
>
087.
<
HeaderStyle
HorizontalAlign
=
"Center"
Width
=
"40px"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"8pt"
></
HeaderStyle
>
088.
<
ItemStyle
HorizontalAlign
=
"Right"
VerticalAlign
=
"Middle"
></
ItemStyle
>
089.
</
telerik:GridBoundColumn
>
090.
<
telerik:GridBoundColumn
UniqueName
=
"Measure"
DataField
=
"Measure"
HeaderText
=
"Measure"
HeaderStyle-Font-Bold
=
"true"
HeaderStyle-Font-Size
=
"8"
091.
HeaderStyle-Font-Names
=
"Arial"
ItemStyle-Font-Size
=
"8"
ItemStyle-HorizontalAlign
=
"Right"
ItemStyle-VerticalAlign
=
"Middle"
>
092.
<
HeaderStyle
HorizontalAlign
=
"Center"
Width
=
"50px"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"8pt"
></
HeaderStyle
>
093.
<
ItemStyle
HorizontalAlign
=
"Right"
VerticalAlign
=
"Middle"
></
ItemStyle
>
094.
</
telerik:GridBoundColumn
>
095.
<
telerik:GridBoundColumn
UniqueName
=
"UOM"
DataField
=
"UOM"
HeaderText
=
"UOM"
HeaderStyle-Font-Bold
=
"true"
HeaderStyle-Font-Size
=
"8"
HeaderStyle-Font-Names
=
"Arial"
096.
ItemStyle-Font-Size
=
"8"
ItemStyle-HorizontalAlign
=
"Right"
ItemStyle-VerticalAlign
=
"Middle"
>
097.
<
HeaderStyle
HorizontalAlign
=
"Center"
Width
=
"40px"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"8pt"
></
HeaderStyle
>
098.
<
ItemStyle
HorizontalAlign
=
"Right"
VerticalAlign
=
"Middle"
></
ItemStyle
>
099.
</
telerik:GridBoundColumn
>
100.
<
telerik:GridBoundColumn
UniqueName
=
"EditItem"
>
101.
<
HeaderStyle
Width
=
"50px"
/>
102.
</
telerik:GridBoundColumn
>
103.
104.
</
Columns
>
105.
</
MasterTableView
>
106.
</
telerik:RadGrid
>
107.
<
asp:Button
runat
=
"server"
ID
=
"btncycle1"
style
=
'float:right;'
Text
=
"Add New Ingredient"
OnClientClick
=
"addNewItem(this); return false;"
/>
108.
</
ItemTemplate
>
109.
<
HeaderStyle
HorizontalAlign
=
"Center"
Font-Bold
=
"True"
Font-Names
=
"Arial"
Font-Size
=
"8pt"
></
HeaderStyle
>
110.
</
telerik:GridTemplateColumn
>
111.
<%--Cycle1 End--%>
112.
113.
<%--Cycle2 Starts--%>
114.
<
telerik:GridTemplateColumn
UniqueName
=
"Cy2"
HeaderStyle-HorizontalAlign
=
"Center"
HeaderText
=
"Cycle 2"
HeaderStyle-Font-Bold
=
"true"
115.
HeaderStyle-Font-Size
=
"8"
ColumnGroupName
=
"C2"
HeaderStyle-Font-Names
=
"Arial"
ItemStyle-Font-Size
=
"8"
ItemStyle-HorizontalAlign
=
"Right"
ItemStyle-VerticalAlign
=
"Top"
FooterText
=
""
>
116.
<
ItemTemplate
>
117.
<
telerik:RadGrid
ID
=
"Cycle2Grid"
runat
=
"server"
ShowGroupPanel
=
"false"
AllowSorting
=
"false"
GridLines
=
"Both"
ShowFooter
=
"false"
118.
AllowPaging
=
"false"
AutoGenerateColumns
=
"false"
119.
HeaderStyle-CssClass
=
"tableHeading br"
EnableViewState
=
"false"
>
We are trying to pass customdata in the connection string in order to implement dynamic security. Can you tell us if the customdata attribute is passed to the msmdpump.dll by the pivotgrid control as we are not seeing a value when we call the customdata function in our cube?
Thanks
Richard
Please I need to create a custom Appointment class but I don't know how, I'm creating a scheduler with RadScheduler, the provider it's a DataBase I'm using a Web Service... I want to change and add properties in the Insert and Edit form and save it in the DataBase. I read some post from here and the documentation but I'm still knowless about what I want to do... I hope you can help me.
Nota: Sorry about my english I'm a spanish speaker.
Protected
Sub
ExportGrid_ExcelMLExportRowCreated(sender
As
Object
, e
As
GridExportExcelMLRowCreatedArgs)
Handles
ExportGrid.ExcelMLExportRowCreated
If
e.RowType = GridExportExcelMLRowType.HeaderRow
Then
For
Each
col
As
GridColumn
In
ExportGrid.MasterTableView.Columns
Dim
xlCell
As
CellElement = e.Row.Cells.GetCellByName(col.UniqueName)
xlCell.StyleValue =
"myStyle"
'xlCell.Attributes.Add("ss:Width", col.HeaderText.Length.ToString())
Next
End
If
End
Sub
Protected
Sub
ExportGrid_ExcelMLExportStylesCreated(sender
As
Object
, e
As
GridExportExcelMLStyleCreatedArgs)
Handles
ExportGrid.ExcelMLExportStylesCreated
Dim
style =
New
StyleElement(
"myStyle"
)
style.AlignmentElement.Attributes.Add(
"ss:WrapText"
,
"1"
)
e.Styles.Add(style)
End
Sub
Hi,
My scenario in my radgrid column level applying filter in Descending order at column name CompanyId, double click it's redirect to another page, and again come back to applied grid column filter in page there is no applied filters in radgrid.
can you suggest me.
Thanks,
Rajashekhar M