Questions on UI for ASP.NET AJAX Forum

1 answer

289 views

Hello,

I am currently Databinding elements from server side database(DB) to my grid and would like the Filter and Sort to be managed Server side too (Client side is too slow).

Is there any options available for this ?

If no, is there a way to use the filter and sort from Grid to launch my own code using the values to do my own server-side query to my DB and refresh the data ?

Thanks for the help.

Grid

answered on 30 Sep 2016

2 answers

171 views

RadEditor Popup

In the Telerik Comment Widget, a button called "Accept All Track Changes", which accepts everything within the body, has a popup when a user clicks on it. The problem is I'm trying to make it 508 compliant so that when the popup happens, it focus's on the "OK" button so the user can tab back and forth between that and Cancel. Currently there is no way to tab onto this button since it is a popup. I tried:

$('.Default').on('show', function () {
$('.ok').focus();
});

The .Default class is the the container and the "ok" class is the button. Is there a way to have the OK button be the focus on popup?

Editor

answered on 30 Sep 2016

1 answer

93 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

219 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

123 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

121 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

177 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

90 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

281 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