Questions on UI for ASP.NET AJAX Forum

4 answers

128 views

Hello Telerik,

Currently I'm implementing a HtmlChart in asp.net. I'm translating a couple of excel sheets into asp.net.
please find attached two files. one of the excel example. one of the current barseries i've made up so far.

my question is: how can I bind grouped data? i want the Y axis to be displayed by year, and then by month. Now only the month is displayed.
could you assist me in defining the correct barseries?

<div class="LeftMonitorDiv">

<telerik:RadPivotGrid ID="CAK_A1_PivotGrid" runat="server"

AggregatesLevel="0" AllowPaging="True" Culture="nl-NL"

DataSourceID="CAK_A1_UniekeClienten_Datasource"

UseQueryableDataProvider="True"

ExportSettings-FileName="CAK_A1_UniekeClienten"

ExportSettings-IgnorePaging="True" ExportSettings-OpenInNewWindow="True"

Skin="Metro" PageSize="20" AllowFiltering="False" TotalsSettings-RowsSubTotalsPosition="None"

TotalsSettings-ColumnsSubTotalsPosition="None" TotalsSettings-RowGrandTotalsPosition="None" TotalsSettings-ColumnGrandTotalsPosition="None"

ShowDataHeaderZone="false" ShowFilterHeaderZone="false" ShowColumnHeaderZone="false" GroupTotalsVisibility="None">

<PagerStyle ChangePageSizeButtonToolTip="Change Page Size" PageSizeControlType="RadComboBox"></PagerStyle>

<Fields>

<telerik:PivotGridRowField DataField="Jaar" UniqueName="JaarColumn" Caption="Jaar">

</telerik:PivotGridRowField>

<telerik:PivotGridRowField DataField="Periode" UniqueName="PeriodeColumn" Caption="Periode">

</telerik:PivotGridRowField>

<telerik:PivotGridRowField DataField="ClientenUniek" UniqueName="ClientenUniek" Caption="Unieke Clienten">

</telerik:PivotGridRowField>

</Fields>

<ClientSettings EnableFieldsDragDrop="false">

</ClientSettings>

<ExportSettings OpenInNewWindow="True" FileName="CAK_A1_UniekeClienten" IgnorePaging="True" />

</telerik:RadPivotGrid>

</div>

<div class="RightMonitorDiv">

<telerik:RadHtmlChart runat="server" Height="338px" Width="563px" Skin="Metro" CssClass="CIZJeugdVervoerPieChart"

ID="CAK_A1_UniekeClienten_PieChart" Transitions="true" DataSourceID="CAK_A1_UniekeClienten_Datasource">

<Appearance>

<FillStyle BackgroundColor="White"></FillStyle>

</Appearance>

<ChartTitle Text="Unieke cliënten per periode">

<Appearance Align="Center" BackgroundColor="White" Position="Top" Visible="True">

</Appearance>

</ChartTitle>

<Legend>

<Appearance BackgroundColor="White" Position="Bottom" Visible="true">

</Appearance>

</Legend>

<PlotArea>

<Appearance>

<FillStyle BackgroundColor="White"></FillStyle>

</Appearance>

<Series>

<telerik:BarSeries Name="Periode" Stacked="false" DataFieldY="ClientenUniek">

<Appearance>

<FillStyle BackgroundColor="Red" />

</Appearance>

<TooltipsAppearance BackgroundColor="White" DataFormatString="${0}" />

<LabelsAppearance Position="Center" DataField="Periode"/>

</telerik:BarSeries>

</Series>

<XAxis DataLabelsField="Periode">

</XAxis>

<YAxis>

<LabelsAppearance DataFormatString="{0}" />

</YAxis>

</PlotArea>

</telerik:RadHtmlChart>

</div>

Chart (HTML5)

answered on 04 Jul 2014

1 answer

124 views

BatchEdit with MouseOver

One of the supported OpenEditingEvent in BatchEdit is "MouseOver".

1. May I ask you to add it into online demo http://demos.telerik.com/aspnet-ajax/grid/examples/data-editing/batch-editing/defaultcs.aspx

2. Could you double check the edit behaviour which seems to be incorrect (or at least inconvenient)
Steps:
   a) set <BatchEditingSettings EditType="Row" OpenEditingEvent="MouseOver" />
   b) Set mouse over a row to enable editing
   c) enter any value in textbox
   d) move mouse to another row - this value has disappeared. The only way to set a new value in text bow is to focus another textbox in the same row by clicking TAB or selecting by mouse.

Grid

answered on 04 Jul 2014

1 answer

119 views

How to do multiple X axis on bar chart?

Hi all,

As described by topic, is it possible to have multiple X axis on bar chart? I'm trying to mimic this excel document (see attachment), can it be done by grouping or categorising? Please advise.

Much appreciated.

Chart (HTML5)

answered on 04 Jul 2014

1 answer

110 views

Site demo Server Error in '/aspnet-ajax'

http://demos.telerik.com/aspnet-ajax/scheduler/examples/overview/defaultcs.aspx

Documentation and Tutorials

answered on 04 Jul 2014

1 answer

81 views

Working offline with OrgChart

Hello,

It seems every operation needs to be saved in database as it happens, eg: node delete/add/edit. Is there a way to do these on client side and submit at the end when user is done with all editing. Please suggest how this can be achieved?

Regrds,
Vijay Garg

OrgChart

answered on 04 Jul 2014

3 answers

146 views

[Solved] Lock down FileExplorer to Explorer view

I have a need to lock the fileExplorer down to jus the fileView, I do not want the to see the toolbar or the location of the directory that they are pulling from. Is there a way to do this. The only thing they should see is the files that belong to them.

<tr>

<td><telerik:RadFileExplorer ID="radExplorer" runat="server" Width="400px" Height="200px" EnableOpenFile="true" DisplayUpFolderItem="false"

EnableCreateNewFolder="false" AvailableFileListControls="Grid" ExplorerMode="Default">

<Configuration ViewPaths="~/PriorSvcUploads" />

</telerik:RadFileExplorer>

</td>

</tr>

FileExplorer

answered on 04 Jul 2014

3 answers

97 views

Error with first line in Chrome

I have noticed an oddity in the RadEditor in Chrome. If the new line mode is set to div, and there is no content in the editor, and that means completely empty even in html view, the first line of content gets wrapped in a paragraph tag instead of a div tag. Any subsequent lines are correct, it is just the first line that is wrong. I have tried a bunch of things, and can't seem to get rid of the paragraph tag by any means other then editing the html. I was able to produce this error in the online demo as well as my own project.

Is there some way to fix this, or is there anything I can do?

Thank you for the help,
Josh

Editor

answered on 04 Jul 2014

1 answer

376 views

Stop Parent Page Refreshing

Hi ,

I have a parent page RequestsBrowse.aspx . The page containing a gridview as per attached Document . The gridview contains one column with a image button which will call a javascript method and which opens a radwindow named Actioncreate.aspx .The parent page will refresh every 60 seconds .

Issue : While clicking on Image button , Radwindow(Actioncreate.aspx) opened . But after 60 seconds , the parent page refreshed and the child radwindow automatically closed . I want to make the Parent window stop refreshing and dont want to close the radwindow.

Code :
----------
<a class="HyperlinkValue" href='Javascript: AddAction("<%# DataBinder.Eval(Container.DataItem, "RequestNumber") %>$<%# DataBinder.Eval(Container.DataItem, "RQSPrimaryId") %>$<%# DataBinder.Eval(Container.DataItem, "openflag") %>$0","<%# DataBinder.Eval(Container.DataItem, "Urgency") %>","<%# DataBinder.Eval(Container.DataItem, "Worker") %>","<%# DataBinder.Eval(Container.DataItem, "WorkOrder") %>");'>
<img border="0" alt='Add Action' title='Add Action' src='images/addaction.gif'>

Refreshing Parent page code :
----------------------------------------
if ((rsi.dispatchesRefresh != 0)&&(hdnStopAutoRefresh.Value=="0"))
Response.AddHeader("Refresh", rsi.dispatchesRefresh.ToString());

Please reply back .

Thanks and Regards
Ganga

General Discussions

answered on 04 Jul 2014

3 answers

178 views

Get RadEditor content in a RadGrid

Hello,

I'm new using Telerik and I'm trying to get the RadEditor content in a RadGrid and is always empty.

I tried many things and doesn't work.

Can anyone help me?Your quote goes here

Thanks!

My code is simple:

User Control:

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="New_Manager_Meeting_u.ascx.cs" Inherits="FHPACS.Modules.PACS_Manager.Meetings.New_Manager_Meeting_u" %>

<asp:UpdatePanel ID="UpdPanelStudies" runat="server">

<ContentTemplate>

<telerik:RadAjaxPanel runat="server" ID="RadAjaxPanel" LoadingPanelID="LoadingPanel1" Width="100%">

<telerik:RadGrid ID="dgrTeamMembers" runat="server" GridLines="None" AllowFilteringByColumn="false" allo AllowSorting="false"

ShowGroupPanel="false" OnGroupsChanging="dgrTeamMembers_GroupsChanging" OnLoad="dgrTeamMembers_Load">

<MasterTableView AutoGenerateColumns="false" DataKeyNames="OPID" EnableHeaderContextMenu="false">

<Columns>

<telerik:GridTemplateColumn HeaderText="" UniqueName="Assist" AllowFiltering="false" HeaderStyle-Width="30px">

<ItemTemplate>

<asp:CheckBox ID="cbxAssist" runat="server" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="ID" DefaultInsertValue="" HeaderText="ID" ReadOnly="true" SortExpression="ID" UniqueName="ID"

HeaderStyle-Width="70px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FIRST_NAME" DefaultInsertValue="" HeaderText="FIRST NAME" ReadOnly="true"

SortExpression="FIRST_NAME" UniqueName="FIRST_NAME" HeaderStyle-Width="90px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="LAST_NAME" DefaultInsertValue="" HeaderText="LAST NAME" ReadOnly="true" SortExpression="LAST_NAME" UniqueName="LAST_NAME" HeaderStyle-Width="120px">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn HeaderText="COMMENTS" UniqueName="COMMENTS" AllowFiltering="false" HeaderStyle-Width="100%"

ItemStyle-Height="120px">

<ItemTemplate>

<telerik:RadEditor ID="edtComment" runat="server" MaxTextLength="700" Width="577px" Height="120px" EditModes="Design"

EnableTextareaMode="True">

<Languages>

<telerik:SpellCheckerLanguage Code="en-US" Title="English" />

</Languages>

<Tools>

<telerik:EditorToolGroup>

<telerik:EditorTool Name="Bold" />

<telerik:EditorTool Name="Italic" />

<telerik:EditorTool Name="Underline" />

<telerik:EditorSeparator />

<telerik:EditorTool Name="JustifyLeft" />

<telerik:EditorTool Name="JustifyCenter" />

<telerik:EditorTool Name="JustifyRight" />

<telerik:EditorTool Name="JustifyFull" />

<telerik:EditorTool Name="JustifyNone" />

<telerik:EditorTool Name="InsertTable" />

<telerik:EditorSeparator />

<telerik:EditorTool Name="Undo" />

<telerik:EditorTool Name="Redo" />

<telerik:EditorTool Name="ForeColor" />

<telerik:EditorSeparator />

<telerik:EditorTool Name="InsertTime" />

<telerik:EditorTool Name="InsertDate" />

<telerik:EditorSeparator />

<telerik:EditorTool Name="FontName" />

<telerik:EditorTool Name="RealFontSize" />

</telerik:EditorToolGroup>

</Tools>

</telerik:RadEditor>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

<ClientSettings AllowDragToGroup="false" AllowColumnsReorder="true" Selecting-AllowRowSelect="true">

<Resizing AllowColumnResize="true" />

</ClientSettings>

</telerik:RadGrid>

</telerik:RadAjaxPanel>

<br />

<asp:Button ID="btnSaveMeeting" runat="server" Text="Save Meeting" OnClick="btnSaveMeeting_Click"/>

</ContentTemplate>

</asp:UpdatePanel>

Code Behind (c#):

using System;

using System.IO;

using System.Web;

using System.Linq;

using System.Web.UI;

using Telerik.Web.UI;

using System.Drawing;

using System.Configuration;

using System.Web.UI.WebControls;

using System.Collections.Generic;

using Telerik.Web.UI.GridExcelBuilder;

public partial class New_Meeting_u : System.Web.UI.UserControl

{

protected void btnSaveMeeting_Click(object sender, EventArgs e)

{

string comment = "";

for (int i = 0; i < dgrTeamMembers.Items.Count; i++)

{

CheckBox cbxonmeeting = dgrTeamMembers.Items[i].FindControl("cbxAssist") asCheckBox;

if (cbxonmeeting.Checked)

{

comment = ((RadEditor)dgrTeamMembers.Items[i].Cells[6].Controls[1]).Content;

}

I tried this:

protected void btnSaveMeeting_Click(object sender, EventArgs e)

{

   string comment = "";

   for (int i = 0; i < dgrTeamMembers.Items.Count; i++)

   {



      CheckBox cbxonmeeting = dgrTeamMembers.Items[i].FindControl("cbxAssist") as CheckBox;

      if (cbxonmeeting.Checked)

      {

         RadEditor membereditor = dgrTeamMembers.Items[i].FindControl("edtComment") as RadEditor;

           comment = membereditor.Content;

        }

   }

}

And this:

protected void btnSaveMeeting_Click(object sender, EventArgs e)

{

string comment = "";

for (int i = 0; i < dgrTeamMembers.Items.Count; i++)

{

CheckBox cbxonmeeting = dgrTeamMembers.Items[i].FindControl("cbxAssist") as CheckBox;

if (cbxonmeeting.Checked)

{

Button GetContent = (Button)sender;

GridEditFormItem item = (GridEditFormItem)GetContent.NamingContainer;

RadEditor radEditor = ((RadEditor)item["COMMENTS"].FindControl("edtComment"));

comment = radEditor.Content;

}

And always is empty!

Grid

answered on 04 Jul 2014

1 answer

194 views

Export Excel - Grid - repeat group rows of data

Hi there:

I need to export to Excel with no grouping but I would like to repeat a group data for each row.  For example

My on screen report
Group A: 12345
      Data1    Data2   Data3
      Data4     Data   Data 6

I would like the output in excel as follows
12345 Data1 Data2 Data2
12345  Data4 Data5 Data6

Grid

answered on 04 Jul 2014