Hi folks

I know this has come up before, and the consensus seems to be in favour of DataReaders over DataAdapters and DataSets because of the memory saving.

My DataGrids are nested four deep with a pivot table at a fifth level, so the number of DataReader hits at the end rapidly multiply into the thousands.

This has worked well for a number of years but I have just started to get IISPool overloads. My application was hosted on an IP address with 118 other DNN sites (who knows how many child portals or even other IP addresses) and moving it to a less crowded server has solved the problem.

But I wonder if I am missing a trick with Multiple Active Result Sets or maybe even dataAdapters and DataSets. I see Michael Washington suggested Linq to SQL and Remote Execution in a similar thread, but I thought that was not suitable for commercial modules.

Here is a sample of my code... very standard as you can see

<asp:GridView ID="GridViewInterfaces"
    showheader=false
    runat="server"
    AutoGenerateColumns=false
    BorderWidth="0"
    CellPadding="0"
    AllowPaging=false
    EnableViewState=false>
    <Columns>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:Label ID="lblInterfaceName"
                    Text='<%# DataBinder.Eval(Container.DataItem,"Name") %>'
                    Tooltip='<%# DataBinder.Eval(Container.DataItem,"Description") %>'
                    runat=server
                    CssClass="Head" />
                <uc1:SuperTableAimsList ID="AimsList1"
                    runat="server"
                    DisplaySelected='<%# rblDisplay.SelectedIndex %>'
                    ShowTotals='<%# ShowTotals %>'
                    ShowBlanks='<%# ShowBlanks %>'
                    ProfileSelectedIndex='<%# ddlProfiles.SelectedIndex %>'
                    ProfileSelectedItem='<%# ddlProfiles.SelectedItem %>'
                    ToolTipText='<%# ToolTipText %>'
                    TotalText='<%# TotalText %>'
                    VisibilityCode='<%# VisibilityCode %>'
                    mid='<%# intModuleID %>'
                    tid='<%# intTabID %>'
                    Data='<%# DataBinder.Eval(Container.DataItem,"ItemId") %>' />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

' get the Interface data
        Dim objInterfaces As New [Interface].SqlDataProvider.InterfaceController
        Dim colInterfaces As List(Of [Interface].SqlDataProvider.InterfaceInfo)
        colInterfaces = objInterfaces.GetInterfaces(PortalId)

' bind the Interface Data to the GridView
            GridViewInterfaces.DataSource = colInterfaces
            GridViewInterfaces.DataBind()

Any suggestion?

Kind regards

---

Geoffrey Morton-Haworth www.yalaworld.net