Questions on UI for ASP.NET AJAX Forum

1 answer

25 views

Hello,

I have a master grid with multiple rows, each row has a detail grid (sub-grid). I do not explicitly set Item Style and Alternate Item Style anywhere in the code and yet somehow items in the detail sub-grid displayed in alternating pattern (even rows with white background and odd rows with light blue background), but items in the master grid do not have this alternating pattern and all have the same style.

Any idea why its different for master and details grid? How do I turn off Alternating Item Style for the entire grid?

Thanks,

Olga

Grid

answered on 14 Dec 2023

3 answers

29 views

Change Box Plot culture and Sumbole

Hi,

I would like help with the following:

1. How can I modify the culture settings for a Box Plot Chart?

2. What steps are involved in changing the symbol from "$" to "£"?

Review the attached image for reference.

Best regards,
Omar

Chart (HTML5)

answered on 13 Dec 2023

0 answers

32 views

When using RadTabStrip and RadMultiPage what should the callbacks look like.

I have implemented a web application that uses the RadTabStrip and RadMultiPage. The tabs and pages are dynamically created when the page is loaded. I did not create a TabStrip_TabClick() callback and when I click on a tab, the tab's associated page shows up as expected - everything works fine!

Now I want to intercept the TabClick() callback in order to do some additional processing before the page is redisplayed.

When I add the TabClick() callback, clicking on a tab does not trigger the page to be displayed.

What basic code needs to be in the callback in order to trigger the default page load behavior?

protected void myTabStrip_TabClick(object sender, RadTabStripEventArgs e)
{
    // What
    // goes
    // here?
}

TabStrip

asked on 12 Dec 2023

1 answer

26 views

Center RadNumericTextBox in RadGrid column

I'm trying to center a RadNumericTextBox in a RadGrid column and it is not working. HEre's what my grid looks like:

        <telerik:RadGrid ID="rgGrid" runat="server" OnNeedDataSource="rgGrid_NeedDataSource" EnableAjaxSkinRendering="true"
            AutoGenerateColumns="False" CellSpacing="0" GridLines="None" MasterTableView-CommandItemDisplay="None" OnPreRender="rgGrid_PreRender" OnItemDataBound="rgGrid_ItemDataBound">
            <MasterTableView DataKeyNames="ProjectDataIndividualsBenefitedId" AllowFilteringByColumn="false" AllowSorting="false" AllowPaging="false" PageSize="1000">
                <Columns>
                    <telerik:GridBoundColumn DataField="Question" HeaderText="Question" UniqueName="Question">
                    </telerik:GridBoundColumn>
                    <telerik:GridTemplateColumn UniqueName="Target" HeaderText="Target" HeaderStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                        <ItemTemplate>
                            <telerik:RadNumericTextBox ID="rntbTarget" runat="server" DataType="System.Int32" MinValue="0" NumberFormat-DecimalDigits="0" DbValue='<%# Eval("TargetBenefited") %>' Width="50" CssClass="form-control"></telerik:RadNumericTextBox>
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
               </Columns>
          </MasterTableView>
     </telerik:RadGrid>

And what I'm getting is the following:

Any ideas?

Grid

NumericTextBox

answered on 12 Dec 2023

1 answer

44 views

Radgrid group aggregates fail when auto-generating columns. Exception: Column '[columnName]' does not belong to table .

I have a radgrid building columns dynamically using the autogenerate feature. I am hooked into the columnCreated event to set some column properties including Aggregate = GridAggregateFunction.Sum. If I do not set an aggregate function, the grid builds functions appropriately. If I set the aggregate function, I receive a stack trace listed below.

I see the exception is happening in System.Data.DataRow.GetColumn() however I have confirmed in the dataTable that the column name exists. Sample table output from the query is below as well as my markup and relevant parts of my code-behind.

Exception Details: System.ArgumentException: Column 'Q1.2023' does not belong to table .
...

[ArgumentException: Column 'Q1.2023' does not belong to table .]
   System.Data.DataRow.GetDataColumn(String columnName) +3129649
   Telerik.Web.UI.GridDataSetHelper.CalculateAggregates(DataRow SourceRow, DataRow DestRow, Int32 rowCountInGroup, GridTableView view, Boolean& changeRowCount) +1190
   Telerik.Web.UI.GridDataSetHelper.InsertGroupByInto(GridTableView gridTableView, DataTable DestTable, DataTable SourceTable, String RowFilter, Int32 FirstIndexInPage, Int32 LastIndexInPage, Boolean ApplyPaging, Boolean IsCustomPaging) +1432
   Telerik.Web.UI.GridEnumerableFromDataView.PerformTransformation() +3451
...

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.9181.0

Sample data row

Team		DoS     Broker		BrokerID	UserType	Live	Active	PeriodID	Q1.2023		Q2.2023		Q3.2023		Q4.2023
TeamName	DosName	BrokerName	120614		100001		Y	Y	Goal		262610.00	342715.00	139790.00	146724.50

Markup

<telerik:RadGrid ID="rgBrokerGoals" runat="server" RenderMode="Lightweight" AutoGenerateColumns="false" Skin="Metro" AllowSorting="false" ShowGroupPanel="false" ShowFooter="true" EnableViewState="True" >
	<HeaderStyle Font-Bold="true" />
        <ClientSettings ReorderColumnsOnClient="True" AllowDragToGroup="True" AllowColumnsReorder="True">
        <Selecting AllowRowSelect="True" />
        <Resizing AllowRowResize="True" AllowColumnResize="True" EnableRealTimeResize="True" ResizeGridOnColumnResize="False" />
        <ClientEvents OnRowDblClick="OnRowDblClick_EditBrokerGoal" />
        <Scrolling UseStaticHeaders="true" AllowScroll="true" ScrollHeight="800px" />
    </ClientSettings>
    <GroupingSettings RetainGroupFootersVisibility="true" />
    <ExportSettings FileName="BrokerGoals">
        <Excel Format="Xlsx" AutoFitColumnWidth="AutoFitAll" />
    </ExportSettings>
    <MasterTableView AutoGenerateColumns="true" DataKeyNames="BrokerID" ClientDataKeyNames="BrokerID" Font-Size="9" TableLayout="Auto" CommandItemDisplay="Top" AllowMultiColumnSorting="true" GroupLoadMode="Server"
        RetainExpandStateOnRebind="true" NoMasterRecordsText="Select a year from the dropdown." ShowGroupFooter="true" EnableViewState="true" >
        <CommandItemSettings ShowExportToExcelButton="false" ShowRefreshButton="true" ShowAddNewRecordButton="false" />
        <CommandItemTemplate>
            <div style="display:inline;">
                <telerik:RadSwitch ID="swRollupTerminatedBrokers" runat="server" Skin="Metro" CommandName="ShowHideTerminatedBrokers" Width="180px" AutoPostback="true" BorderStyle="none" >
                    <ToggleStates>
                        <ToggleStateOff Text="Rollup Separated Brokers" />
                        <ToggleStateOn Text="Show Separated Brokers" />
                    </ToggleStates>   
                </telerik:RadSwitch>
            </div>
            <div style="float:right; display:inline;">
                <telerik:RadButton runat="server" ID="RefreshButton" OnClientClicked="rebindGrid" AutoPostBack="false" Text="Refresh" ToolTip="Refresh" Skin="Metro" BorderStyle="none" >
                    <Icon PrimaryIconCssClass="rgRefreshIcon" />
                </telerik:RadButton>
            </div>
        </CommandItemTemplate>

        <GroupByExpressions>
            <telerik:GridGroupByExpression>
                <GroupByFields>
                    <telerik:GridGroupByField FieldName="Team" />
                </GroupByFields>
                <SelectFields>
                    <telerik:GridGroupByField FieldName="Team" HeaderText="Team" FieldAlias="Team" />
                </SelectFields>
            </telerik:GridGroupByExpression>
            <telerik:GridGroupByExpression>
                <GroupByFields>
                    <telerik:GridGroupByField FieldName="DoS" />
                </GroupByFields>
                <SelectFields>
                    <telerik:GridGroupByField FieldName="DoS"   HeaderText="SM" FieldAlias="SM" />
                </SelectFields>
            </telerik:GridGroupByExpression>
        </GroupByExpressions>
        <Columns>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

Relevant Code-behind

Note that some event handlers have been omitted as the code does not reach them. The exception is thrown, as far as I can tell, after all of the columnCreated events have fired and but before reaching ItemCreated and ItemDataBound . Changing Aggregate function to Custom and setting a break on the OnCustomAggregate handler does not produce any sort of result either.

Public Class BrokerGoals
    Inherits Page

    Private Property RollupTerminatedBrokersChecked As Boolean = True

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Trim(HttpContext.Current.Session("UserID") & "") = "" Then Response.Redirect("../index.aspx")
        If IsPostBack Then
            rgBrokerGoals.Rebind()
        Else
            ddlPeriodStart.DataBind()
            ddlPeriodStart.SelectedText = $"{Date.Today.Year}.Q1"
            ddlPeriodEnd.DataBind()
            ddlPeriodEnd.SelectedText = $"{Date.Today.Year}.Q4"
        End If

        btnAddGoal.Attributes.Add("onclick", "NewGoal();return false;")
        btnAddGoal.NavigateUrl = "javascript:NewGoal();return false;"
        btnAddGoal.Visible = Functions.CheckFieldSecurity(251, HttpContext.Current.Session("UserID"))

    End Sub

Protected Sub rgBrokerGoals_NeedDataSource(sender As Object, e As GridNeedDataSourceEventArgs) Handles rgBrokerGoals.NeedDataSource
        Try
            Dim commandItems = rgBrokerGoals.MasterTableView.GetItems(GridItemType.CommandItem)
            If commandItems.Count > 0 Then
                Dim rollupBrokersSwitch = CType(rgBrokerGoals.MasterTableView.GetItems(GridItemType.CommandItem)?(0)?.FindControl("swRollupTerminatedBrokers"), RadSwitch)
                RollupTerminatedBrokersChecked = rollupBrokersSwitch.Checked
            End If
            Dim dt As New DataTable
            Using db = Functions.GetSqlConnection()
                Using cmd As New SqlCommand("JN_BrokerGoals_ByPeriod", db)
                    cmd.CommandType = CommandType.StoredProcedure
                    cmd.Parameters.Add("@PeriodStart", SqlDbType.Date).Value = SetDateValue(ddlPeriodStart.SelectedValue)
                    cmd.Parameters.Add("@PeriodEnd", SqlDbType.Date).Value = SetDateValue(ddlPeriodEnd.SelectedValue)
                    cmd.Parameters.Add("@RollupTerminatedBrokers", SqlDbType.Bit).Value = RollupTerminatedBrokersChecked
                    Using da As New SqlDataAdapter(cmd)
                        da.Fill(dt)
                    End Using
                End Using
            End Using

            CType(sender, RadGrid).DataSource = dt
        Catch ex As Exception
            'Error Handling
        End Try
    End Sub

    Private Sub rgBrokerGoals_ColumnCreated(sender As Object, e As GridColumnCreatedEventArgs) Handles rgBrokerGoals.ColumnCreated
        If e.Column.UniqueName.StartsWith("Q") Then
            Dim column = CType(e.Column, GridNumericColumn)
            column.Aggregate = GridAggregateFunction.Sum
            column.NumericType = NumericType.Currency
            column.HeaderText = column.UniqueName
            column.DataFormatString = "{0:C}"

        ElseIf {"PeriodID", "Active", "Live", "UserType", "BrokerID", "DoS", "Team"}.Contains(e.Column.UniqueName) Then
            e.Column.Display = False
        End If
    End Sub

    Protected Sub rgBrokerGoals_ItemCreated(ByVal sender As Object, ByVal e As GridItemEventArgs) Handles rgBrokerGoals.ItemCreated
        If TypeOf e.Item Is GridGroupHeaderItem Then
            AddHandler e.Item.PreRender, AddressOf HeaderItem_PreRender
        ElseIf TypeOf e.Item Is GridGroupFooterItem Then
            AddHandler e.Item.PreRender, AddressOf FooterItem_PreRender
        End If
    End Sub

    Private Sub rgBrokerGoals_ItemDataBound(sender As Object, e As GridItemEventArgs) Handles rgBrokerGoals.ItemDataBound
        If TypeOf e.Item Is GridDataItem Then
            Dim dataItem As GridDataItem = CType(e.Item, GridDataItem)
            Dim brokerID As Long = dataItem.GetDataKeyValue("BrokerID")
            Dim varUserType As Integer? = JearParse.SetIntValue(dataItem("UserType").Text)

            Dim BrokerIsLive As Boolean = JearParse.SetStringValue(dataItem("Live").Text) = "Y"
            Dim BrokerIsInSales = Function(UserType As Long?) As Boolean
                                      Return {100001, 100002, 100009}.Contains(If(UserType, -1))
                                  End Function


            ' If user is not active/in sales, put asterisk next to their name.
            If (BrokerIsLive AndAlso Not BrokerIsInSales(varUserType)) OrElse Not BrokerIsLive Then
                dataItem("Broker").Text &= "*"
                For Each cell As TableCell In dataItem.Cells
                    cell.ForeColor = Drawing.Color.Red
                Next
            End If

            dataItem.Enabled = IsNumeric(brokerID) andAlso brokerID <> -1
        End If
    End Sub
End Class

Grid

answered on 12 Dec 2023

2 answers

24 views

Change Box Plot culture

Hi,

Can someone help with these questions:

1. How can I modify the culture settings for a Box Plot Chart?
2. What steps are involved in changing the symbol from "$" to "£"?

Could you review the attached image for reference, please?

Best regards,
Omar

Chart (HTML5)

answered on 09 Dec 2023

0 answers

32 views

What is the easiest way to check on the client side if RadGrid is in grouped state or ungrouped?

Hello,

I have a grid that could be grouped by one of the columns or ungrouped. GroupLoadMode = "Client".

What is the easiest way to get the grouping state (grouped or ungrouped) of the grid on the client side.

Thanks,

Olga

Grid

asked on 05 Dec 2023

0 answers

44 views

DropDownTree performance issue when checking an element with many child elements

When checking an element that has many child elements (> 30.000) it takes a while until that element becomes checked.

Found that some Telerik's Javascript code is being executed for all 30.000 elements (even nothing is being done with them from our perspective).

Example: when Option11 checkbox is clicked, page becomes unresponsive and it takes approx. 30 seconds to become checked.

Can we get some feedback why this is happening?

Thx in advance

DropDownTree

asked on 04 Dec 2023

0 answers

49 views

RacComboBox with checkboxes - Customize the "X items checked"

I would like to know how to customize the "X items checked" text when I set CheckedItemsTexts="FitInInput" and have multiple items checked.

Thanks

CheckBox

ComboBox

asked on 01 Dec 2023

0 answers

22 views

Telerik overlapping with radmenu on a aspx Report Viewer Form R1 2023

hi friends,

I'm adding a radmenu to a aspx Report Viewer Form, it overlaps the control bar ot he report,

   <form runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server" />
        <telerik:RadMenu ID="RadMenu1" runat="server">
            <Items>
                <telerik:RadMenuItem runat="server" Text="Root RadMenuItem1">
                    <Items>
                        <telerik:RadMenuItem runat="server" Text="Child RadMenuItem 1">
                        </telerik:RadMenuItem>
                        <telerik:RadMenuItem runat="server" Text="Child RadMenuItem 2">
                        </telerik:RadMenuItem>
                        <telerik:RadMenuItem runat="server" Text="Child RadMenuItem 3">
                        </telerik:RadMenuItem>
                    </Items>
                </telerik:RadMenuItem>
            </Items>
        </telerik:RadMenu>
		<br />
        <div>
            <p>what is this shir??</p>
        <telerik:ReportViewer
            ID="reportViewer1" ServiceUrl="api/reports" ScaleMode="Specific"
			Width="100%"
			Height="50%"
			EnableAccessibility="false"
            runat="server">
            <ReportSource IdentifierType="UriReportSource" Identifier="VentasPorCliente.trdp">
            </ReportSource>
			<%-- If set to true shows the Send Mail Message toolbar button --%>
            <SendEmail Enabled = "false" />
        </telerik:ReportViewer>
          </div>
    </form>