Questions on UI for ASP.NET AJAX Forum

1 answer

118 views

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

171 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

86 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

277 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

126 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

188 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

18 answers

2.0K+ views

Only Horizontal Scrollbar for RadGrid

Is there a way to have only Horizontal Scrollbar in a radgrid? When I enable scrolling in ClientSettings, both Horizontal and Vertical scrollbar shows up. I want to have only Horizontal scrollbar and the height of the grid should adjust as per the number of records, which happens when you don't have scrolling enabled. I also tried using Scrollheight, in that case if the number of records are less than what can be shown in that height, there is whitespace for the rest of the height.

Thanks

Ajax

answered on 29 Sep 2016

1 answer

87 views

Add New button centered, perform command insert on click

I want to customize the add new button, centering it on the grid but also having the same functionality as the normal built in Add New button.

Here is the code I have so far:

The problem is the Insert command only makes the screen flash and doesn't open the Add New dialog.

Can you help?

Grid

answered on 29 Sep 2016

0 answers

48 views

Improving Lightweight Rendering for RadDropDownTree (R3 2016)

The R3 2016 release of the Telerik UI for ASP.NET AJAX suite introduces several improvements of the Lightweight rendering of the RadTreeView. As the RadDropDownTree uses an embedded RadTreeView for its drop-down, those changes apply for that control too.

Full description of the improvements made could be found in the following documentation article.

DropDownTree

asked on 29 Sep 2016