Questions on UI for ASP.NET AJAX Forum

1 answer

82 views

mouse wheel changes cell value

When editing a cell, moving the mouse wheel changes the value of the cell. How can I stop this behavior?

Grid

answered on 30 Sep 2016

3 answers

182 views

Description box

Hi,

Can description handle the html tag and also scrollable if out width and height.?

thanks.

ImageGallery

answered on 30 Sep 2016

3 answers

107 views

Can't find OrgChart after a postback

Hi

I'm having some issues with a very big organisation chart (it contains about 3500 items in 1700 groups).

1. The first issue is that it takes a long time to load (about 20 seconds untill the control displays on the page). Is this normal for charts this size or should this be faster?

2. When I drill down and go back to the parent level, some errors occur. I noticed while debugging that the following line returns null, which then makes the rest of the javascript fail. This line is located in the pageLoad() method, so as I understand all controls should be initialized at the moment the line below is executed. I checked using the developer tools in IE and the control is still visible in the markup.

var orgChart = $find("<%=MyOrgChartControl.ClientID%>");

This only happens after a postback. So the initial request never returns an error. The weird thing is that it does not happen all the time, I can for example do 1 postback (drill down) without it failing, but during the next postback (go to parent level) the error occurs...

Do you guys have any idea on what might be causing this issue? Any help would be much appreciated!

Kind regards

Jens

OrgChart

answered on 30 Sep 2016

1 answer

110 views

Export Radgrid to PDF

Hi,

I have a RadGrid which I am trying to export to PDF. When I open PDF I want to see highlighted row based on criteria. I have a column in RadGrid call "TotHrs".

if (TotHrs) > 500 highlight the entire row in PDF.

How can I do this.

Thanks so much for your help.

General Discussions

answered on 30 Sep 2016

3 answers

159 views

Changing Tile Title Styling from Code Behind

I have a RadContentTemplateTile with a default Title colour of Black set via

.rtileTitle

{

color: Black !important;

}

Sometimes I have the need to change the Black to Red and I'd like to do it via CSS as below.

.rtileTitleRed

{

color: Red !important;

}

The trouble is, I don't know how/where to apply this CSS in code behind. Please assist.

TileList

answered on 30 Sep 2016

1 answer

78 views

tile tool tip change client side

How do I change a tile's tool tip on the client side?

TileList

answered on 30 Sep 2016

2 answers

267 views

changeCellValue when paging in Batch Edit mode

Hi,

Using the RadGrid in Batch Editing mode and the EditType is set to row.

I use pagination and to avoid to loose data when I navigate between pages, I save the data on the client in "sessionStorage" (See Attach file).

I try to use the function "changeCellValue" in event "OnGridCreated" but it doesn't work.

Question: Which event schould I use to set the cells from grid with the values from the sessionStorage, please ? or should I use another method ?

Thank you

function GridCreated(sender, eventArgs) {

var values = JSON.parse(sessionStorage.getItem("editedValues"));

if (values) {

var masterTable = sender.get_masterTableView();

var batchEditingManager = sender.get_batchEditingManager();

var rows = masterTable.get_dataItems();

for (var i = 0; i < rows.length; i++) {

var row = rows[i];

var mandant = row.get_element().cells[0].innerHTML;

for (var key in values) {

var id = key.split("#");

if (id[0] == mandant) {

var cell = row.get_cell(id[1]);

batchEditingManager.changeCellValue(cell, values[key]);

}

Grid

answered on 30 Sep 2016

1 answer

1.0K+ views

Filter Expression in Rad grid

Hi,
I have a radgrid which has custom filtering, sorting , paging and if I want to find the filter expression I go to

Radgrid.MasterTableView.FilterExpression.

The expression I get uses a lot of OR clause instead of having them in a IN clause.Ex.

(([Column_One] = 'Cust ')) AND (([Column_Two] = '3/31/2016 12:00:00 AM') OR ([Column_Two] = '3/18/2016 12:00:00 AM') OR ([Column_Two] = '3/28/2016 12:00:00 AM'))

When I use the below code to manually filter the datatable

Dim filteredRows As DataRow() = dataTable.Select(RadGrid1.MasterTableView.FilterExpression)

I get stackoverflow error when I use the above filter expression for custom filtering as the number of columns and options can get huge. This https://blogs.msdn.microsoft.com/sqldev/2008/12/10/you-may-get-system-stackoverflowexception-in-your-asp-net-application-if-your-filter-condition-has-too-many-or-in-your-datatable-select-function/ article suggest that instead of having multiple OR clauses it should be reduced to IN clause to mitigate this problem. Is there a way to get the query in such a way so that I don't have to write one myself.

Also, Can you also tell me how the default filtering using onNeedDataSource works. I have a huge datatable( around 50k recods). When I tried debugging with default paging goes to the onNeedDataSource event and then filters the data. I am not sure if the dataTable is being fetched every single time. As the time taken for filtering is quite high.

I followed all the optimization techniques and got the paging to run quicker. But in the example for custom paging I see that Custom paging is being turned off when filtering or grouping is applied. Like http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/paging/custom-paging . This again causes the filtering to run slower.

Is this because the default filtering causes the page the fetch the entire data and then select the required columns from there.?

This the code as of Now. I am turning off the custom paging only for grouping. And it runs faster as I take the table from the Cache and not the Database.



Private isGrouping As Boolean = False
 
    Protected Sub RadGrid1_GroupsChanging(source As Object, e As GridGroupsChangingEventArgs)
        isGrouping = True
        If e.Action = GridGroupsChangingAction.Ungroup AndAlso RadGrid1.CurrentPageIndex > 0 Then
            isGrouping = False
        End If
    End Sub
 
    Public Function ShouldApplySortFilterOrGroup() As Boolean
        Return (RadGrid1.MasterTableView.GroupByExpressions.Count > 0 OrElse isGrouping) OrElse RadGrid1.MasterTableView.SortExpressions.Count > 0
    End Function
 
    Protected Function getDataTable() As DataTable
        Dim key As String = [String].Format("{0}/{1}/{2}/{3}/{4}", x, y, c, f, s)
        Dim dataTable As DataTable = TryCast(HttpRuntime.Cache(key), DataTable)
        If dataTable Is Nothing Then
            SqlDataSource1.FilterExpression = Session("as")
            SqlDataSource1.DataBind()
            Dim dv As DataView = DirectCast(SqlDataSource1.[Select](DataSourceSelectArguments.Empty), DataView)
            dataTable = dv.ToTable()
            Session(key) = dataTable
            HttpRuntime.Cache(key) = dataTable
        End If
        Return dataTable
    End Function
 
    Protected Sub RadGrid1_NeedDataSource(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles RadGrid1.NeedDataSource
        Dim dataTable As DataTable = getDataTable()
        If RadGrid1.MasterTableView.FilterExpression <> "" Then
            Dim filteredRows As DataRow() = dataTable.Select(RadGrid1.MasterTableView.FilterExpression) `StackOverFlow error occours here
            If filteredRows.Length > 0 Then
                dataTable = filteredRows.CopyToDataTable()
            End If
        End If
        Dim startRowIndex As Integer = If((ShouldApplySortFilterOrGroup()), 0, RadGrid1.CurrentPageIndex * RadGrid1.PageSize)
        Dim maximumRows As Integer = If((ShouldApplySortFilterOrGroup()), dataTable.Rows.Count, RadGrid1.PageSize)
        RadGrid1.AllowCustomPaging = Not ShouldApplySortFilterOrGroup()
        If RadGrid1.AllowCustomPaging Then
            RadGrid1.VirtualItemCount = dataTable.Rows.Count
        End If
        Dim rows As DataTable = dataTable.AsEnumerable().Skip(startRowIndex).Take(maximumRows).CopyToDataTable()
        RadGrid1.DataSource = rows
    End Sub

Any help would be great. Thanks!

Grid

answered on 30 Sep 2016

1 answer

119 views

RadPageLayout and mobile menu (RadTreeView)

Good evening, I'm using a RadPageLayout control.
The control is formed by two lines, the first has a RadToolBar.
The second row is divided into two columns, in the first column has a RadTreeView and in the second a RadGrid.

My question is, what is the best way to show the sandwich icon (to show the RadTreeView in mobile device) as in the case of your website?

I hope I was clear.

Thanks in advance

General Discussions

answered on 30 Sep 2016

2 answers

182 views

RadGrid Pop up edit form labels

Hello Telerik,

I'm using a pop up edit form in a Radgrid. Is it possible to style (font size, color, etc) the Label associated with a given edit item in the code behind? I have multiple edit fields on the form and I need to change the style of some of the labels. but not all of them.

Also, how can I prevent the colon(":") from being added to the end of my labels.

Thank you.

Grid

answered on 29 Sep 2016