Questions on UI for ASP.NET AJAX Forum

10 answers

370 views

Group Aggregate with Paging (showing partial aggregate)

I have basic radgrid with paging and grouping enabled. When my datasource has a small number of items everything is fine, however when the grid needs to use paging, my groups footer aggregate is evaluated on the rows of the current page only. I would like to build a custom aggregate function based on all the data (in the group) instead of having "per page per group" totals. How can it be done?

Given I achieve what I just described, would it be possible to hide the group footer ONLY when the end of group is not reached? As you can guess, it might be confusing to see multiple "group totals for the whole group"... Let's say I have a page size of 100 and my first group has 150 items, how could I force the group footer to appear only on the 2nd page (page 1 would have no group footer)?

Let me know if you want me to provide some code.

Grid

answered on 08 Nov 2016

1 answer

104 views

Visual Studio like sliding and docking

I'm trying to implement two panels that slide and dock similar to visual studio's Solution Explorer and Properites. I was able to make them slide using splitter/slidingzone/slidingpane with a litlle tab appearing when they are hidden. I want to also be able to dock them side by side by dragging one of them next to the other one. For my search I found that it may be done using Dock but I did not find how to do it. I tried to implement it by it did not work with me and I had to revert back to the splitter code to implement other functionalities. what it did was putting the slidingzone inside the dock/dockzone/dockpane

<telerik:RadSplitter RenderMode="Lightweight" ID="RadSplitter1" Skin="Material" runat="server" Width="100%" Height="100%">

<telerik:RadPane ID="LeftPane" runat="server" Width="22px" Scrolling="none" Locked="False">

<telerik:RadSlidingZone ID="SlidingZone1" runat="server" Width="22px" RenderMode="Lightweight">

<telerik:RadSlidingPane ID="RadSlidingPane1" Title="Emergency" runat="server" Width="300px" MinWidth="300">

<uc1:EmergencyControl runat="server" ID="EmergencyControl" />

</telerik:RadSlidingPane>

<telerik:RadSlidingPane ID="Radslidingpane2" Title="Alarm" runat="server" Width="300px" MinWidth="300">

<uc1:AlarmControl runat="server" ID="AlarmControl" />

</telerik:RadSlidingPane>

</telerik:RadSlidingZone>

</telerik:RadPane>

<telerik:RadPane ID="MiddlePane1" runat="server" Scrolling="None">

<telerik:RadSplitter RenderMode="Lightweight" ID="Radsplitter2" runat="server" Orientation="Horizontal" VisibleDuringInit="false" Height="100%">

<telerik:RadPane ID="MapPane" runat="server">

<uc1:MapControl runat="server" ID="MapControl" Height="100%" />

</telerik:RadPane>

</telerik:RadSplitter>

</telerik:RadPane>

<telerik:RadPane ID="EndPane" runat="server" Width="22px" Scrolling="None">

<telerik:RadSlidingZone ID="Radslidingzone1" runat="server" Width="22px" ClickToOpen="true"

SlideDirection="Left">

<telerik:RadSlidingPane ID="AlarmBtnPane" Title="Alarm Button" runat="server" Width="50px"

MinWidth="50" EnableDock="False" EnableResize="False" TabView="TextAndImage">

<uc1:AlarmBtnControl runat="server" ID="AlarmBtnControl" />

</telerik:RadSlidingPane>

</telerik:RadSlidingZone>

</telerik:RadPane>

</telerik:RadSplitter>

So I you can provide a example on how to implement it.

Splitter

answered on 08 Nov 2016

6 answers

131 views

RadConfirm in Toolbar

Hi, I am using this kb article to display a RadConfirm when the user clicks on a Delete button. I am currently using the latest build.

Everything worked fine, but lately it doesn't postback anymore ONLY ON FireFox.

I tried to replicate the issue in a small project, but it works as expected, so I guess there should be something I do in other places that breaks the behavior of the toolbar (?).

Note that

- if I remove the RadConfirm (or simply I do not cancel the ButtonClicking event) it works, so all my other code runs without interfering with the postback

- if I try to force a postback by calling __doPostBack() (after clicking on the Delete button and answering the RadConfirm) it doesnt work too

- I have a version of the application that runs with Telerik version 2015.2.623 without any problem (I am now going to try to go back to this version and see if it solves anything)

I need a way I can debug this, as what happens after I click Yes on the RadConfirm is a mix of Telerik and MS code that is fairly complex.

Thanks in advance

Luca

ToolBar

answered on 08 Nov 2016

20 answers

1.1K+ views

Export to pdf and save programmatically

Hi All

I have a radgrid and button (Export To pdf)

The radgrid contains the data

When I click the Export to pdf button

The datas are shown in the pdf

Before that a screen appears for open or save

if open i given it opens the pdf

If save is given then the path if asked, and then it is saved

IS THERE ANY OPTION TO AUTOMATICALLY SAVE THE PDF

-Anto

Grid

answered on 08 Nov 2016

1 answer

196 views

RadGrid DeleteCommand error

Hello all,

I have a Radgrid with a DeleteColumn. When I click in delete image the row dessapear but when I refresh the grid the row appear again.

I try with Datasource delete query and code behind, but OnDeleteCommand never triggered.

Code:

<telerik:RadGrid ID="RGVEmpresasEnCentro" runat="server" Width="500px"

RenderMode="Lightweight" GridLines="None"

AllowAutomaticDeletes="true"

AllowAutomaticInserts="true"

PageSize="10"

OnPreRender="RGVEmpresasEnCentro_PreRender"

OnBatchEditCommand="RGVEmpresasEnCentro_BatchEditCommand"

OnDeleteCommand="RGVEmpresasEnCentro_DeleteCommand"

AllowAutomaticUpdates="true"

AllowPaging="true"

AutoGenerateColumns="False"

DataSourceID="SDSEmpresasEnCentro"

Skin="WebBlue" >

<MasterTableView CommandItemDisplay="TopAndBottom" DataKeyNames="id"

DataSourceID="SDSEmpresasEnCentro" HorizontalAlign="NotSet" EditMode="Batch" AutoGenerateColumns="False"

CommandItemSettings-AddNewRecordText="Insertar centro"

CommandItemSettings-SaveChangesText="Guardar"

CommandItemSettings-CancelChangesText="Cancelar"

CommandItemSettings-RefreshText="Refrescar"

NoMasterRecordsText="No hay empresas en el centro"

NoDetailRecordsText="No hay empresas en el centro">

<BatchEditingSettings EditType="Cell" />

<Columns>

<telerik:GridBoundColumn DataField="id"

Visible="false"

DataType="System.Int32"

HeaderText="id"

SortExpression="id"

UniqueName="id"

ReadOnly="true" />

<telerik:GridBoundColumn DataField="Empresa"

HeaderText="Empresa"

SortExpression="Empresa"

UniqueName="Empresa">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Numero"

HeaderText="Numero"

SortExpression="Numero"

UniqueName="Numero">

</telerik:GridBoundColumn>

<telerik:GridDateTimeColumn DataField="Desde"

HeaderText="Desde"

SortExpression="Desde"

UniqueName="Desde" PickerType="DatePicker" DataFormatString="{0:dd/MM/yyyy}" >

</telerik:GridDateTimeColumn>

<telerik:GridDateTimeColumn DataField="HastaEl"

HeaderText="Hasta el"

SortExpression="HastaEl"

UniqueName="HastaEl"

PickerType="DatePicker"

DataFormatString="{0:dd/MM/yyyy}" >

</telerik:GridDateTimeColumn>

<telerik:GridButtonColumn

HeaderText="Delete" HeaderStyle-Width="50px"

CommandName="Delete" Text="Delete" UniqueName="DeleteColumn">

</telerik:GridButtonColumn>

</Columns>

</MasterTableView>

<ClientSettings AllowKeyboardNavigation="true"></ClientSettings>

</telerik:RadGrid>

<asp:SqlDataSource ID="SDSEmpresasEnCentro" runat="server" ConnectionString="<%$ ConnectionStrings:PCMConnectionString %>"

SelectCommand="SELECT * From EmpresasEnCentros Where idRevisionCentros=@idRevisionCentros"

DeleteCommand="DELETE EmpresasEnCentros WHERE id = @id"

InsertCommand="INSERT INTO EmpresasEnCentros (idRevisionCentros,Empresa,Numero,Desde,HastaEl) VALUES (@idRevisionCentros,@Empresa,@Numero,@Desde,@HastaEl)"

UpdateCommand="UPDATE EmpresasEnCentros SET Empresa=@Empresa, Numero=@Numero,Desde=@Desde,HastaEl=@HastaEl WHERE id = @id">

<DeleteParameters>

<asp:Parameter Name="id" Type="Int32"></asp:Parameter>

</DeleteParameters>

<SelectParameters>

<asp:parameter Name="idRevisionCentros" DefaultValue="0" type="Int32" />

</SelectParameters>

<InsertParameters>

<asp:parameter Name="idRevisionCentros" type="Int32" />

<asp:Parameter Name="Empresa" Type="String"></asp:Parameter>

<asp:Parameter Name="Numero" Type="Int32"></asp:Parameter>

<asp:Parameter Name="Desde" Type="DateTime"></asp:Parameter>

<asp:Parameter Name="HastaEl" Type="DateTime"></asp:Parameter>

</InsertParameters>

<UpdateParameters>

<asp:Parameter Name="id" Type="Int32"></asp:Parameter>

<asp:Parameter Name="Empresa" Type="String"></asp:Parameter>

<asp:Parameter Name="Numero" Type="Int32"></asp:Parameter>

<asp:Parameter Name="Desde" Type="DateTime"></asp:Parameter>

<asp:Parameter Name="HastaEl" Type="DateTime"></asp:Parameter>

</UpdateParameters>

</asp:SqlDataSource>

protected void RGVEmpresasEnCentro_PreRender(object sender, EventArgs e)

{

RGVEmpresasEnCentro.Rebind();

GridTableView masterTable = (sender as RadGrid).MasterTableView;

foreach (GridColumn column in masterTable.RenderColumns)

{

if ((column is IGridEditableColumn) && (column as IGridEditableColumn).IsEditable && masterTable.GetBatchColumnEditor(column.UniqueName) != null)

{

Control container = (masterTable.GetBatchColumnEditor(column.UniqueName) as IGridColumnEditor).ContainerControl;

if (container != null && container.Controls.Count > 0)

{

(container.Controls[0] as WebControl).Width = Unit.Percentage(100);

}

protected void RGVEmpresasEnCentro_BatchEditCommand(object sender, GridBatchEditingEventArgs e)

{

foreach (GridBatchEditingCommand command in e.Commands)

{

if(command.Type == GridBatchEditingCommandType.Insert)

{

Hashtable newValues = command.NewValues;

if(!newValues.ContainsValue(null))

{

string centro = Request.QueryString["Centro"];

string periodo = Request.QueryString["Periodo"];

int idRevisionCentro =CentrosBLL.ComprobarYCrearRegistros(centro, periodo, Session["codigoSap"].ToString());

string empresa = newValues["Empresa"].ToString();

int numero = Convert.ToInt32(newValues["Numero"]);

DateTime desde = Convert.ToDateTime(newValues["Desde"]);

DateTime hasta=Convert.ToDateTime(newValues["HastaEl"]);;

CentrosBLL.insertEmpresaCentro(idRevisionCentro,empresa,numero,desde,hasta);

}

e.Canceled = true;

}

protected void RGVEmpresasEnCentro_DeleteCommand(object sender, GridCommandEventArgs e)

{

//Some code for delete programatically

}

Grid

answered on 08 Nov 2016

3 answers

171 views

How to customize ToolTip with RadToolTipManager

I would like to customize the cell tooltip using RadTooltipManager. Is there an example somewhere? I'm using VB.NET with a SQL data source. The value I want in the tooltip is a separate value from what is displayed in the cell.

PivotGrid

answered on 07 Nov 2016

3 answers

927 views

Could not load assembly or file Telerik.Windows.Zip

Hi,

I use the spreadsheet part with much satisfaction, but since a while I get the following error

'Could not load file or assembly Telerik.Windows.Zip, Version=2016.1.106.40'

And i can't get any solution. I tried to upgrade all Telerik controls, but that didn't work yet.I will try again...

Can someone please help?

It breaks on the last line of my code block.

IWorkbookFormatProvider formatProvider = new XlsxFormatProvider();

var workbook = new EpicExcelExportManager().GetFilledWorkbook();

byte[] renderedBytes;

using (var ms = new MemoryStream())

{

formatProvider.Export(workbook, ms);

Thanks.

John

Spreadsheet

answered on 07 Nov 2016

5 answers

171 views

RadEditor IE 11 Preview More Not Working

Hi,

This is for IE11 on Widnows 7 with <meta http-equiv="X-UA-Compatible" content="IE=Edge" />

I have multiple rad editors on a page. For each of them the EditMode is set to Preview. The first editor shows correctly (cannot edit contents), all the rest of them are editable. The problem being the iframe body has contenteditable set to true for all of them except the first.

I am ina fix over this. I reaallly need help urgently

Editor

answered on 07 Nov 2016

12 answers

256 views

Field chooser available?

I am busy with an investigation which ASP.NET grid control to use. Some of the other grid vendors have the ability of having a visual field chooser in which the end user can add and remove the colums by having a toolbox with the invisible columns.

Does the RadGrid have this functionality too?

Grid

answered on 07 Nov 2016

3 answers

77 views

GridTableView W3C errors

Hi,

Today I have used HTML validator (https://validator.w3.org/) to check if I have any errors and found that there is summary attribute rendered inside of a table element which, according to the validator, is obsolete and instead of summary attribute, caption element should be used. Tried fixing this myself and found that however I set up GridTableView it always renders that summary attribute - internally summary attribute is always rendered. I would like to know how to solve that issue if it is possible to do so now or, if not, I would like to report it as an issue. (We are using Version 2016.2.607.45 of Telerik.Web.UI - Telerik UI for ASP.NET AJAX)

Thank you for your help.

Ajax

answered on 07 Nov 2016