Questions on UI for ASP.NET AJAX Forum

1 answer

96 views

Show single detail table based on command

I have a master view with two child views. I would like to have command buttons on the master row which cause an expand to happen to one or the other child tables. When I handle the ItemCommand event, I hide set all detail tables to Visible=False but they are still visible on the output.

I've tried setting the expanded and visibility of the detail tables right within the ItemCommand event like this:

if (e.CommandName == "ExpandSomething")

{

item.Expanded = true;

foreach (var table in MyGrid.MasterTableView.DetailTables)

if (table.Name != "Something")

table.Visible = false;

}

Then I thought maybe the hiding needed to be done later in the event cycle so I tried it like this:

private string _activeChildView = null;

protected void ShowSingleChildTable(string name) //this is called from item command

{

_activeChildView = name;

}

private void Page_PreRender(object sender, EventArgs e)

{

if (_activeChildView != null)

foreach (var table in AdminGrid.MasterTableView.DetailTables)

if (table.Name != _activeChildView)

table.Visible = false;

}

Neither way works - both grids are always visible.

In playing around with different events, I've found that the DataBinding event is the only place that setting the visibility to false works, but unfortunately that fires before the ItemCommand so I can't figure out if a detail button was pressed.

Grid

answered on 19 Aug 2015

1 answer

183 views

Restrict to enter decimal values.

Hi Team,

I have created a Radgrid dynamically which has a "GridNumericColumn" for numeric operation, also I set its properties like "DecimalDigits = 4" ,"DataFormatString = "{0:f4}"" AllowRounding = false and KeepNotRoundedValue = true;

My intention is, the user should not allow to enter more than 4 decimals in edit mode. but It allowing the user to enter more than 4 decimals in edit mode!

Is there any possibility to restrict alow more than 4 decimals ?

Note : My grid has more numeric columns with different decimals.(example 2, 3 and 4 ,like 12.12 , 23.234 and 12.1234)

Regards,

Ramesh.

Grid

answered on 19 Aug 2015

3 answers

555 views

Export Excel 'System.OutOfMemoryException' issue with 160,000

Hello Team,
I am using Radgrid, that is having more then 160,000 records with 46 columns. The version I am using is ASP.NET AJAX Q3 2013 SP2 (version 2013.3.1324). Excel version is 2013. Export to excel is not working and generate 'System.OutOfMemoryException". I believe Excel 2013 worksheet size hold close to a million rows. Is there any workaround ? See snippet of my code below. I created the grid dynamically

Can anyone help me out with this? Is there any limitation exporting excel or csv from Radgrid with this record size?

Thanks

Dan

     private void CreateDetailGrid()
        {
            GridDetailResults.ID = "GridDetailResults";
            GridDetailResults.Columns.Clear();
            GridDetailResults.AutoGenerateColumns = false;
            GridDetailResults.GridLines = GridLines.Both;
            GridDetailResults.AllowSorting = GridDetailResults.AllowPaging = GridDetailResults.AllowSorting = true;
            GridDetailResults.AllowFilteringByColumn = true;
            GridDetailResults.Skin = "Default";
            GridDetailResults.HeaderStyle.Font.Underline = false;
            GridDetailResults.GroupingSettings.CaseSensitive = false;
            GridDetailResults.EnableLinqExpressions = false;
            GridDetailResults.Height = new Unit("400px");

            //Mastertableview settings
            GridDetailResults.MasterTableView.EnableNoRecordsTemplate = true;
            //GridDetailResults.MasterTableView.ShowHeader = true;
            GridDetailResults.MasterTableView.ShowHeadersWhenNoRecords = false;
            GridDetailResults.MasterTableView.CommandItemSettings.ShowExportToExcelButton = true;
            GridDetailResults.MasterTableView.CommandItemSettings.ShowExportToCsvButton = true;
            GridDetailResults.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.Top;
            GridDetailResults.MasterTableView.CommandItemSettings.ShowAddNewRecordButton = false;
            GridDetailResults.MasterTableView.CommandItemSettings.ShowRefreshButton = false;

            // paging style
            GridDetailResults.MasterTableView.PagerStyle.AlwaysVisible = true;
            GridDetailResults.MasterTableView.PagerStyle.PageSizeControlType = PagerDropDownControlType.RadDropDownList;

            // Export setting
            GridDetailResults.ExportSettings.HideStructureColumns = true;
            GridDetailResults.ExportSettings.UseItemStyles = true;
            GridDetailResults.ExportSettings.IgnorePaging = true;
            GridDetailResults.ExportSettings.OpenInNewWindow = true;
            GridDetailResults.ExportSettings.Excel.Format = GridExcelExportFormat.Html;
            GridDetailResults.ExportSettings.ExportOnlyData = true;

            //Events
            GridDetailResults.NeedDataSource += GridDetailResults_OnNeedDataSource;

            GridDetailResults.ItemStyle.BackColor = Color.FromName("#DFDFDF");
            GridDetailResults.HeaderStyle.BackColor = Color.FromName("#FFFFFF");
            GridDetailResults.HeaderStyle.ForeColor = Color.FromName("#767676");
            GridDetailResults.AlternatingItemStyle.BackColor = Color.FromName("#FFFFFF");
            GridDetailResults.HeaderStyle.HorizontalAlign = HorizontalAlign.Left;
            GridDetailResults.FilterItemStyle.HorizontalAlign = HorizontalAlign.Left;

            GridDetailResults.ClientSettings.Scrolling.AllowScroll = true;
            GridDetailResults.ClientSettings.Scrolling.SaveScrollPosition = true;
            GridDetailResults.ClientSettings.Scrolling.UseStaticHeaders = true;
            GridDetailResults.ClientSettings.Scrolling.FrozenColumnsCount = 2;

            if (AllDimTable == null)
                AllDimTable = BusMethods.GetAllDimList();

Grid

answered on 19 Aug 2015

1 answer

323 views

RadGantt does not display correctly

Hi,

I have a problem when I use radTabStrip control with scheduler and gantt. I have three tabs in the first I shows a radgrid control and the second shows a Scheduler control and the last one I show a Gantt Chart.

If I use the property selected of RadTabStrip control in “False”, I can see very well the Scheduler and Gantt (Gantt_w and Scheduler_w). But when I set Selected in “True”, the Scheduler shows well but the Gantt chart does not display correctly.

I do not understand what is the problem?

Here is my code ASP

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="wfGantt.aspx.cs" Inherits="testTelerik.wfGantt" %>

<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI.Gantt" tagprefix="cc1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>

<link href="css/Bootstrap/Ajax.Bootstrap.css" rel="stylesheet" />

<link href="css/Bootstrap/Gantt.Bootstrap.css" rel="stylesheet" />

<link href="css/Bootstrap/TabStrip.Bootstrap.css" rel="stylesheet" />

<link href="css/Bootstrap/Calendar.Bootstrap.css" rel="stylesheet" />

<link href="css/Bootstrap/Scheduler.Bootstrap.css" rel="stylesheet" />

<link href="css/Bootstrap/SchedulerRecurrenceEditor.Bootstrap.css" rel="stylesheet" />

<link href="css/Bootstrap/SchedulerReminderDialog.Bootstrap.css" rel="stylesheet" />

<link href="css/Bootstrap/Window.Bootstrap.css" rel="stylesheet" />

<link href="css/Bootstrap/Menu.Bootstrap.css" rel="stylesheet" />

<title></title>

</head>

<body>

<form id="form1" runat="server">

<div>

<telerik:radscriptmanager runat="server"></telerik:radscriptmanager>

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<ajaxsettings>

<telerik:AjaxSetting AjaxControlID="pvScheduler">

<updatedcontrols>

<telerik:AjaxUpdatedControl ControlID="rschCasos" LoadingPanelID="ralpGantt" UpdatePanelCssClass="" />

</updatedcontrols>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="pvGantt">

<updatedcontrols>

<telerik:AjaxUpdatedControl ControlID="GraficoGantt" LoadingPanelID="ralpGantt" UpdatePanelCssClass="" />

</updatedcontrols>

</telerik:AjaxSetting>

</ajaxsettings>

</telerik:RadAjaxManager>

<telerik:RadAjaxLoadingPanel ID="ralpGantt" runat="server" Skin="Default"></telerik:RadAjaxLoadingPanel>

<telerik:RadTabStrip ID="RadTabStrip1" runat="server" MultiPageID="RadMultiPage1">

<Tabs>

<telerik:RadTab runat="server" PageViewID="pvPlanner" Text="Planeador" Value="Planner"></telerik:RadTab>

<telerik:RadTab runat="server" PageViewID="pvScheduler" Text="Scheduler" Value="Scheduler"></telerik:RadTab>

<telerik:RadTab runat="server" PageViewID="pvGantt" Text="Gantt" Value="Gantt"></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage ID="RadMultiPage1" runat="server" Width="100%">

<telerik:RadPageView ID="pvPlanner" runat="server">

</telerik:RadPageView>

<telerik:RadPageView ID="pvScheduler" runat="server">

<telerik:radscheduler runat="server"

id="rschCasos"

selectedview="MonthView"

EnableEmbeddedSkins="False"

height="100%" width="100%"

ShowViewTabs="true" StartEditingInAdvancedForm="False"

OverflowBehavior="Auto"

MinimumInlineFormWidth="320" MinimumInlineFormHeight="140">

<TimelineView UserSelectable="false" />

<WeekView UserSelectable="false" />

<DayView UserSelectable="false" />

<MultiDayView UserSelectable="false" />

<localization advancednewappointment="Nuevo Evento"

advancedsubject="Asunto"

headerday="Día" headermonth="Mes" headertimeline="Linea de Tiempo"

headertoday="Hoy" headerweek="Semana" save="Guardar"

show24hours="Mostrar 24 horas..."

ConfirmCancel="Cancelar"

ConfirmDeleteText="Se encuentra seguro de eliminar el evento seleccionado?"

ConfirmDeleteTitle="Eliminar Evento"

ConfirmOK="Aceptar"

ContextMenuAddAppointment="Nuevo Evento"

ContextMenuAddRecurringAppointment="Nuevo Evento Periodico"

ContextMenuDelete="Eliminar"

ContextMenuEdit="Editar"

ShowBusinessHours="Mostrar horas de trabajo" AdvancedAllDayEvent="Todo el día" AdvancedCalendarCancel="Cancelar" AdvancedCalendarOK="Aceptar" AdvancedCalendarToday="Hoy" AdvancedClose="Cerrar" AdvancedDaily="Diario" AdvancedDay="Día" AdvancedDays="dia(s)" AdvancedDescription="Descripción" AdvancedDone="Listo" AdvancedEditAppointment="Editar Evento" AdvancedEndDateRequired="Fecha Final es requerido" AdvancedEndTimeRequired="Hora Final es requerido" AdvancedRecurrence="Periodicidad" AdvancedRepeat="Repetir" AdvancedStartDateRequired="Fecha Inicial es requerida" AdvancedStartTimeRequired="Hora Inicial es requerida" AllDay="todo el día" Cancel="Cancelar" ConfirmRecurrenceDeleteOccurrence="Eliminar solo esta ocurrencia" ConfirmRecurrenceDeleteSeries="Eliminar la serie" ContextMenuGoToToday="Ir a fecha actual" Delete="Eliminar" HeaderAddAppointment="Agregar Evento" HeaderAgendaAppointment="Evento" HeaderAgendaDate="Fecha" HeaderNextDay="siguiente día" HeaderPrevDay="día anterior" Reminder="Recordatorio" ReminderDay="día" ReminderDays="dias" ReminderHour="hora" ReminderHours="horas" ReminderMinute="minuto" ReminderMinutes="minutos" ReminderNone="Ninguno" ReminderOpenItem="Abrir Item" Reminders="Recordatorios" ShowAdvancedForm="Opciones" ShowMore="mas..." />

<monthview minimumrowheight="3" />

<TimeSlotContextMenuSettings EnableDefault="true"></TimeSlotContextMenuSettings>

<AppointmentContextMenuSettings EnableDefault="true" >

</AppointmentContextMenuSettings>

</telerik:radscheduler>

</telerik:RadPageView>

<telerik:RadPageView ID="pvGantt" runat="server">

</telerik:RadPageView>

</telerik:RadMultiPage>

</div>

</form>

</body>

</html>

Code C#

protected void Page_Load(object sender, EventArgs e)

{

RadTabStrip1.Skin = "Bootstrap";

DataTable tasks = new DataTable();

tasks.Columns.Add(new DataColumn("ID", typeof(int)));

tasks.Columns.Add(new DataColumn("ParentID", typeof(int)));

tasks.Columns.Add(new DataColumn("Subject", typeof(string)));

tasks.Columns.Add(new DataColumn("Summary", typeof(bool)));

tasks.Columns.Add(new DataColumn("PercentComplete", typeof(decimal)));

tasks.Columns.Add(new DataColumn("Start", typeof(DateTime)));

tasks.Columns.Add(new DataColumn("End", typeof(DateTime)));

tasks.Rows.Add(1, null, "Defining selection", false, 0.1, new DateTime(2015, 8, 2), new DateTime(2015, 9, 4));

tasks.Rows.Add(2, null, "Researching the market for candidates", true, 0, new DateTime(2015, 8, 3), new DateTime(2015, 8, 15));

tasks.Rows.Add(3, 2, "Advertising the position", false, 0.3, new DateTime(2015, 8, 10), new DateTime(2015, 8, 15));

tasks.Rows.Add(4, 2, "Collecting job applications", false, 0.5, new DateTime(2015, 8, 10), new DateTime(2015, 8, 15));

tasks.Rows.Add(5, null, "Categorizing applications", false, 0.5, new DateTime(2015, 8, 17), new DateTime(2015, 8, 22));

tasks.Rows.Add(6, null, "Assessing applicants", true, 0, new DateTime(2015, 8, 19), new DateTime(2015, 8, 31));

tasks.Rows.Add(7, 6, "Interview with Human Resources representatives", false, 0.2, new DateTime(2015, 8, 24), new DateTime(2015, 8, 26));

tasks.Rows.Add(8, 6, "Asigning and reviewing a sample test task", false, 0.2, new DateTime(2015, 8, 24), new DateTime(2015, 8, 27));

tasks.Rows.Add(9, 6, "Interview with Development representatives", false, 0.6, new DateTime(2015, 8, 26), new DateTime(2015, 8, 28));

tasks.Rows.Add(10, null, "Creating and proposing the job offer", false, 0.7, new DateTime(2015, 8, 27), new DateTime(2015, 8, 29));

tasks.Rows.Add(11, null, "Hiring applicant", false, 0.4, new DateTime(2015, 8, 25), new DateTime(2015, 8, 31));

//Scheduler

rschCasos.ReadOnly = true;

rschCasos.DataSource = tasks;

rschCasos.DataKeyField = "ID";

rschCasos.DataSubjectField = "Subject";

rschCasos.DataStartField = "Start";

rschCasos.DataEndField = "End";

rschCasos.Skin = "Bootstrap";

rschCasos.DataBind();

//Gant

CargarGraficoGantt(tasks);

//RadTabStrip1.Tabs[0].Selected = true;

//RadMultiPage1.SelectedIndex = pvPlanner.Index;

}

private void CargarGraficoGantt(DataTable dsGrafico)

{

RadGantt rgGantt = new RadGantt();

rgGantt.ID = "GraficoGantt";

rgGantt.SnapToGrid = false;

rgGantt.ReadOnly = true;

rgGantt.AllowSorting = false;

rgGantt.SelectedView = GanttViewType.MonthView;

rgGantt.AutoGenerateColumns = false;

//rgGantt.Width = Unit.Percentage(100.0);

//rgGantt.Height = Unit.Percentage(100.0);

//Columnas

agregarColumna("ID", "Id", 50, rgGantt);

agregarColumna("Title", "Tareas a Desarrollar", 350, rgGantt);

agregarColumna("PercentComplete", "Porcentaje", 80, rgGantt);

rgGantt.DataBindings.TasksDataBindings.IdField = "ID";

rgGantt.DataBindings.TasksDataBindings.TitleField = "Subject";

rgGantt.DataBindings.TasksDataBindings.StartField = "Start";

rgGantt.DataBindings.TasksDataBindings.EndField = "End";

rgGantt.DataBindings.TasksDataBindings.ParentIdField = "ParentID";

rgGantt.DataBindings.TasksDataBindings.SummaryField = "summary";

rgGantt.DataBindings.TasksDataBindings.PercentCompleteField = "PercentComplete";

rgGantt.DataSource = dsGrafico;

rgGantt.Skin = "Bootstrap";

rgGantt.DataBind();

pvGantt.Controls.Add(rgGantt);

}

private void agregarColumna(string DataField, string Header, int tamano, RadGantt ctrlGantt)

{

GanttBoundColumn gbc = new GanttBoundColumn();

gbc.DataField = DataField;

gbc.HeaderText = Header;

gbc.Width = Unit.Pixel(tamano);

ctrlGantt.Columns.Add(gbc);

}

So when I activate this:

RadTabStrip1.Tabs[0].Selected = true;

RadMultiPage1.SelectedIndex = pvPlanner.Index;

The Gantt chart does not display correctly ( Gantt_b).

General Discussions

answered on 19 Aug 2015

17 answers

317 views

what am I doing wrong?

when the page loads I see all the pageviews being displayed for the first tab, it is not till I click through all the tabs once will the pageviews show correctly for the selected tab

Ok here is my code

<telerik:RadTabStrip ID="RadTabStrip1" runat="server" MultiPageID="RadMultiPage1">

<Tabs>

<telerik:RadTab runat="server" Text="1" PageViewID="rpv1">

</telerik:RadTab>

<telerik:RadTab runat="server" Text="2" PageViewID="rpv2">

</telerik:RadTab>

<telerik:RadTab runat="server" Text="3" PageViewID="rpv3">

</telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<telerik:RadMultiPage ID="RadMultiPage1" runat="server" SelectedIndex="0">

<telerik:RadPageView ID="rpv1" runat="server">

<asp:Label ID="Label1" runat="server" CssClass="BoldPrompt" Text="rpv1"></asp:Label>

</telerik:RadPageView>

<telerik:RadPageView ID="rpv2" runat="server">

<asp:Label ID="Label2" runat="server" CssClass="BoldPrompt" Text="rpv2"></asp:Label>

</telerik:RadPageView>

<telerik:RadPageView ID="rpv3" runat="server">

<asp:Label ID="Label3" runat="server" CssClass="BoldPrompt" Text="rpv3"></asp:Label>

</telerik:RadPageView>

</telerik:RadMultiPage>

TabStrip

answered on 18 Aug 2015

14 answers

1.4K+ views

Setting values in AutoComplete Box

I am facing a couple of issues:

How do I assign values to the autocomplete box?
Here is how I was doing to the normal text box:
txtIssTitle.Text = ds.Tables[0].Rows[0]["ISSUE TITLE"].ToString();

I have now replaced the text box with the autocomplete box. The text I want to display in the autocomplete box upon user click of a Retrieve button will already be part of the entries in the autocomplete box. I just can't figure out how to set and display it in the box.
How do I Left align the text in the box? Right now it's all center aligned.

Though I have opened a support ticket for this but it is kind of urgent for me to find a solution for this since I have to show it to the users asap.

Thanks!

AutoCompleteBox

answered on 18 Aug 2015

2 answers

83 views

RecurrenceRule in custom insert form

Is there an example of how to process the RadSchedulerRecurrenceEditor1.RecurrenceRule data when processing server side and saving the appointment data?

Persumably the RadSchedulerRecurrenceEditor1.RecurrenceRule.ToString() is stored in the RecurrenceRule column of the sample database

Do we then process the recurrences and insert records for each occurence like this: http://docs.telerik.com/devtools/aspnet-ajax/controls/scheduler/server-side-programming/working-with-recurring-appointments

Is the rule stored in each occurence ?

What is the RecurrenceParentID set to?

Scheduler

answered on 18 Aug 2015

2 answers

106 views

RadComboBox position

Hi,

I have a radcombobox inside a radwizard.

However, when click on the arrow my combobox dropdown appears at the top of the page. I am unable to figure it out. I have radcomboboxes at other places in the application and they seem to work fine there.

See screenshot.

ComboBox

answered on 18 Aug 2015

4 answers

164 views

shape raduis

Hello

We are using shape to draw a "geo-fence" on a radmap. we are currently passing a coordinate, along with a property of radius to the map. The value of the radius property is a double representing meters. so a 1 nautical mile = 1852 meters, so the geofence has a radius of 926 meters

We have looked through all the samples and all the questions we can find in the forum, but we are not understanding what formula / calculation to use to draw this correctly on the map, and of course it needs to scale with zooming. We have been attempting this in the shapeCreated(e) client event as below: This of course draws a very large shape on the map.

function shapeCreated(e) {

if (e.shape.dataItem.properties.Radius) {

var currentZoom = e.sender.zoom();

var fenceRadius = e.shape.dataItem.properties.Radius;

e.shape._geometry.radius = fenceRadius;

}

Any direction on how to translate a shape based on radius meters (or other metric.. miles, feet, whatever) would be appreciated.

Map

answered on 18 Aug 2015

1 answer

68 views

RadAjaxManager obstructs other events to fire

I’m trying to update a RadPivotGrid object using RadAjaxManager and some loading panel, so the user sees something while data is loading. I have already accomplished this but I have other logic in the page, some jQuery modal dialog() to save pivogrid states. Since the RadAjaxManager object is present events do not fire. Not even an onclick with an alert(). I’m attaching the code with some comments to help comprehend the scenario.
Help my friends!
Thanks

Ajax

answered on 18 Aug 2015