Questions on UI for ASP.NET AJAX Forum

1 answer

251 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

140 views

[Solved] 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

166 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

220 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

294 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

106 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>

do you have any idea how to Fix this?

Thanks

Ajax

PageLayout

Styling

asked on 30 Nov 2023

2 answers

192 views

RadAsyncUpoload upload to TargetFolder without postback

Hi,

Is it possible to upload directly to the TargetFolder when the file is dropped on a dropzone?

I mean, without hitting a submit button first?

Thanks,

Marc

AsyncUpload

answered on 30 Nov 2023

0 answers

182 views

RadGrid accessibility issue when using static header

When using RadGrid, if setting UseStaticHeaders="True", in rendered HTML, the table header will be rendered into a separate table, and we will get the following complaints from Siteimprove Accessibility Checker:

No data cells assigned to table header
Table cell missing context

Is there a solution to this issue?

Grid

asked on 28 Nov 2023

0 answers

143 views

Collapsing RadGrid Item not possible anymore in Sitefinity CMS after ASP.NET Ajax Update

Hello,

I made an update to the newest Telerik.Web.UI Version 2023.3.1010.45 and now I cannot collapse my RadGrid-Items anymore after expanding. Instead I can see a statusbar which is loading infinite long on the left side when the ViewState is enabled in the Sitefinity Backend. When I disable the ViewState I have the same problem, just without statusbar. There is a screenshot of the grid and my HTML-Code in the attachment. Could anybody help me?

Regards

Ajax

Grid

UI for ASP.NET AJAX in ASP.NET MVC