This is a migrated thread and some comments may be shown as answers.

[Solved] Footer Aggregates not working when using server-side binding DetailTableDataBind

5 Answers 216 Views
Grid
This is a migrated thread and some comments may be shown as answers.
stewster
Top achievements
Rank 1
stewster asked on 28 Oct 2009, 01:33 PM
Aggregates are blank when binding server-side.

I Have the following GridBoundColumn:

 <telerik:GridBoundColumn Aggregate="Sum" SortExpression="UNIT_PRICE" HeaderText="UNIT_PRICE"
HeaderButtonType="TextButton" DataField="UNIT_PRICE" DataFormatString="{0:$###,###.##}"
FooterAggregateFormatString="TOTAL: {0:C}">
</telerik:GridBoundColumn>

On the server I have.

Protected

 

Sub RadGrid1_DetailTableDataBind(ByVal source As Object, ByVal e As Telerik.Web.UI.GridDetailTableDataBindEventArgs) Handles RadGrid1.DetailTableDataBind

 

 

Dim dataItem As GridDataItem = CType(e.DetailTableView.ParentItem, GridDataItem)

 

 

Dim OrderID As String = dataItem.GetDataKeyValue("WORK_ORDER").ToString()

 

 

Dim openstockDetail As SqlDataReader = DealerOpenStocks.GetOpenStockDetail(OrderID)

 

e.DetailTableView.DataSource = openstockDetail

 

End Sub

 

 

Protected Sub RadPanelBar1_ItemClick(ByVal sender As Object, ByVal e As Telerik.Web.UI.RadPanelBarEventArgs) Handles RadPanelBar1.ItemClick

 

 

Dim openstock As SqlDataReader = DealerOpenStocks.GetOpenStock(e.Item.Text)

 

Radgrid1.DataSource = openstock

RadGrid1.DataBind()

 

'ProductImage.Src = "images/" & e.Item.Text & ".jpg"

 

 

End Sub


Everything works fine except that my footer totals are not showing up. Any ideas?


Below is all the code if needed.

 

<

 

telerik:RadGrid ID="RadGrid1" runat="server" Width="100%" ShowStatusBar="True" AutoGenerateColumns="False"

 

 

ShowFooter="True" GridLines="Horizontal" Skin="Outlook">

 

 

<MasterTableView Width="100%" ClientDataKeyNames="WORK_ORDER" DataKeyNames="WORK_ORDER"

 

 

Name="Master">

 

 

<DetailTables>

 

 

<telerik:GridTableView DataKeyNames="WORK_ORDER" Name="Sub" Width="100%">

 

 

<Columns>

 

 

<telerik:GridBoundColumn SortExpression="WORK_ORDER" HeaderText="WORK_ORDER ID" HeaderButtonType="TextButton"

 

 

DataField="WORK_ORDER">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn SortExpression="PART_ID" HeaderText="PART ID" HeaderButtonType="TextButton"

 

 

DataField="PART_ID">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn SortExpression="DESCRIPTION" HeaderStyle-Width="250px" HeaderText="DESCRIPTION"

 

 

HeaderButtonType="TextButton" DataField="DESCRIPTION" UniqueName="DESCRIPTION">

 

 

<HeaderStyle Width="250px"></HeaderStyle>

 

 

<ItemStyle Width="250px" />

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn Aggregate="Sum" SortExpression="UNIT_PRICE" HeaderText="UNIT_PRICE"

 

 

HeaderButtonType="TextButton" DataField="UNIT_PRICE" DataFormatString="{0:$###,###.##}"

 

 

FooterAggregateFormatString="TOTAL: {0:C}">

 

 

</telerik:GridBoundColumn>

 

 

 

 

</Columns>

 

 

</telerik:GridTableView>

 

 

</DetailTables>

 

 

<Columns>

 

 

<telerik:GridBoundColumn DataField="WORK_ORDER" HeaderText="WORK_ORDER" SortExpression="WORK_ORDER"

 

 

UniqueName="WORK_ORDER">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="DESCRIPTION" HeaderText="DESCRIPTION" SortExpression="DESCRIPTION"

 

 

UniqueName="DESCRIPTION">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="MODEL" HeaderText="MODEL" SortExpression="MODEL"

 

 

UniqueName="MODEL">

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn DataField="UNIT_PRICE" DataType="System.Decimal" HeaderText="UNIT_PRICE"

 

 

SortExpression="UNIT_PRICE" UniqueName="UNIT_PRICE" DataFormatString="{0:C}">

 

 

</telerik:GridBoundColumn>

 

 

</Columns>

 

 

</MasterTableView>

 

 

<ClientSettings ReorderColumnsOnClient="True" AllowColumnsReorder="True">

 

 

<Selecting AllowRowSelect="True"></Selecting>

 

 

</ClientSettings>

 

 

</telerik:RadGrid>


 

 

 

 

5 Answers, 1 is accepted

Sort by
0
stewster
Top achievements
Rank 1
answered on 30 Oct 2009, 01:04 AM
Anyone?
0
Johny
Top achievements
Rank 1
answered on 02 Nov 2009, 01:21 PM
Hi Stewster,

I tried the following code and it runs normally on my side:

<telerik:RadGrid ID="RadGrid1" runat="server" Width="100%" ShowStatusBar="True" AutoGenerateColumns="False" 
            ShowFooter="True" GridLines="Horizontal" Skin="Outlook"  
            onneeddatasource="RadGrid1_NeedDataSource" OnDetailTableDataBind="RadGrid1_DetailTableDataBind"
            <MasterTableView Width="100%" ClientDataKeyNames="WORK_ORDER" DataKeyNames="WORK_ORDER" 
                Name="Master"
                <DetailTables> 
                    <telerik:GridTableView DataKeyNames="WORK_ORDER" Name="Sub" Width="100%"
                        <Columns> 
                            <telerik:GridBoundColumn SortExpression="WORK_ORDER" HeaderText="WORK_ORDER ID" HeaderButtonType="TextButton" 
                                DataField="WORK_ORDER"
                            </telerik:GridBoundColumn> 
                            <telerik:GridBoundColumn SortExpression="PART_ID" HeaderText="PART ID" HeaderButtonType="TextButton" 
                                DataField="PART_ID"
                            </telerik:GridBoundColumn> 
                            <telerik:GridBoundColumn SortExpression="DESCRIPTION" HeaderStyle-Width="250px" HeaderText="DESCRIPTION" 
                                HeaderButtonType="TextButton" DataField="DESCRIPTION" UniqueName="DESCRIPTION"
                                <HeaderStyle Width="250px"></HeaderStyle> 
                                <ItemStyle Width="250px" /> 
                            </telerik:GridBoundColumn> 
                            <telerik:GridBoundColumn Aggregate="Sum" SortExpression="UNIT_PRICE" HeaderText="UNIT_PRICE" 
                                HeaderButtonType="TextButton" DataField="UNIT_PRICE" DataFormatString="{0:$###,###.##}" 
                                FooterAggregateFormatString="TOTAL: {0:C}"
                            </telerik:GridBoundColumn> 
                        </Columns> 
                    </telerik:GridTableView> 
                </DetailTables> 
                <Columns> 
                    <telerik:GridBoundColumn DataField="WORK_ORDER" HeaderText="WORK_ORDER" SortExpression="WORK_ORDER" 
                        UniqueName="WORK_ORDER"
                    </telerik:GridBoundColumn> 
                    <telerik:GridBoundColumn DataField="DESCRIPTION" HeaderText="DESCRIPTION" SortExpression="DESCRIPTION" 
                        UniqueName="DESCRIPTION"
                    </telerik:GridBoundColumn> 
                    <telerik:GridBoundColumn DataField="MODEL" HeaderText="MODEL" SortExpression="MODEL" 
                        UniqueName="MODEL"
                    </telerik:GridBoundColumn> 
                    <telerik:GridBoundColumn DataField="UNIT_PRICE" DataType="System.Decimal" HeaderText="UNIT_PRICE" 
                        SortExpression="UNIT_PRICE" UniqueName="UNIT_PRICE" DataFormatString="{0:C}"
                    </telerik:GridBoundColumn> 
                </Columns> 
            </MasterTableView> 
            <ClientSettings ReorderColumnsOnClient="True" AllowColumnsReorder="True"
                <Selecting AllowRowSelect="True"></Selecting> 
            </ClientSettings> 
        </telerik:RadGrid> 

Here is my code behind:

Protected Sub RadGrid1_NeedDataSource(ByVal source As ObjectByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) 
  Dim dt As New DataTable() 
  dt.Columns.Add("WORK_ORDER"
  dt.Columns.Add("DESCRIPTION"
  dt.Columns.Add("MODEL"
  dt.Columns.Add("UNIT_PRICE"
  For i As Integer = 0 To 9 
  dt.Rows.Add("WORK_ORDER" & i, "DESCRIPTION" & i, "MODEL" & i, "UNIT_PRICE" & i) 
  Next 
  RadGrid1.DataSource = dt 
End Sub 
Protected Sub RadGrid1_DetailTableDataBind(ByVal source As ObjectByVal e As Telerik.Web.UI.GridDetailTableDataBindEventArgs) 
  Dim dt As New DataTable() 
  dt.Columns.Add("WORK_ORDER"
  dt.Columns.Add("PART_ID"
  dt.Columns.Add("DESCRIPTION"
  dt.Columns.Add("UNIT_PRICE"GetType(Integer)) 
  For i As Integer = 0 To 9 
  dt.Rows.Add("WORK_ORDER" & i, "DESCRIPTION" & i, "MODEL" & i, i * i * i * i) 
  Next 
  e.DetailTableView.DataSource = dt 
End Sub 
 
 

I have attached the result image.

Thanks
Johny.



0
Larry
Top achievements
Rank 1
answered on 03 Nov 2009, 03:31 PM
 

Johny,

Thanks for taking time in creating the sample app. No matter what I do It will not aggregate. I've recreated the application with the same results. Will the RADAJAXMANAGER cause this?

I'm also binding the grid with an sqldatasource.

Any Ideas TELERIK?

FULL CODE BELOW:

 

 

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="DealerPortal.aspx.vb" Inherits="DealerPortal" %> 
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml">  
<head id="Head1" runat="server">  
    <title>Sure-Trac - Dealer Page</title> 
    <link href="css/st2009.css" rel="stylesheet" type="text/css" /> 
    <link href="css/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" /> 
    <style type="text/css">  
        .DetailTable Outlook caption  
        {  
            color: blue;  
            background-color: red;  
        }  
        .InnerHeaderStyle  
        {  
            background: navy !important;  
            font-size: 13px !important;  
            color: white !important; /*add more style definitions here*/  
        }  
    </style> 
</head> 
<body> 
    <form id="form1" runat="server">  
    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">  
    </telerik:RadScriptManager> 
    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">  
 
        <script type="text/javascript">  
        function PrintRadGrid()  
        {  
          
            var previewWnd = window.open('about:blank', '', '', false);  
            var sh = '<%= ClientScript.GetWebResourceUrl(radGrid1.GetType(),String.Format("Telerik.Web.UI.Skins.{0}.Grid.{0}.css",radGrid1.Skin)) %>';  
            var styleStr = "<html><head><link href = '" + sh + "' rel='stylesheet' type='text/css'></link></head>";  
            var detailTable = $find('<%= radGrid1.ClientID %>').get_detailTables()[0];  
            var htmlcontent = styleStr + "<body><div class='RadGrid RadGrid_Simple'>" + detailTable.get_element().outerHTML + "</div></body></html>";  
                          
            previewWnd.document.open();  
            previewWnd.document.write(htmlcontent);  
            previewWnd.document.close();  
            previewWnd.print();  
        }  
          
          
          
    function imageMouseOver(sender, eventArgs)   
    {   
      
     var tooltipManager = $find("<%= RadToolTipManager1.ClientID %>");            
        if (!tooltipManager) return;    
        var tooltip = tooltipManager.getToolTipByElement(element);    
          
        if (!tooltip) {    
            tooltip = tooltipManager.createToolTip(element);    
    
            tooltip.set_value(arguments[1].toString());    
        }    
    
        tooltip.show();    
 
      
          
        //var item = eventArgs.get_item();        
       var imagename = eventArgs.get_item().get_text() + '.jpg';  
        
       //alert();           
                
              document.images["ProductImage"].src"Trailer_Images/" + imagename;  
    }   
 
          
         function HierarchyExpanding(sender, args)  
        {        
        alert('in');  
          
        }   
          
          
        </script> 
 
    </telerik:RadCodeBlock> 
    <div> 
        <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" 
            id="master">  
            <tr> 
                <td> 
                    <table width="950" border="0" align="left" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">  
                        <tr> 
                            <td colspan="2">  
                                <table width="950" cellspacing="0" cellpadding="0">  
                                    <tr> 
                                        <td> 
                                            <div align="right">  
                                                <img src="images/st__searchblock.jpg" alt="" width="950" height="54" border="0" usemap="#dealers" /><span 
                                                    class="footercopy"><br /> 
                                                </span> 
                                            </div> 
                                        </td> 
                                    </tr> 
                                </table> 
                            </td> 
                        </tr> 
                        <tr> 
                            <td colspan="2">  
                                <img src="images/st__logo.jpg" alt="" width="950" height="65" border="0" usemap="#HOME" /> 
                            </td> 
                        </tr> 
                        <tr> 
                            <td style="background-color: #D8E8FE">  
                                <telerik:RadMenu ID="RadMenu1" runat="server" Skin="Office2007" OnItemClick="RadMenu1_ItemClick">  
                                    <Items> 
                                        <telerik:RadMenuItem runat="server" Text="Home" NavigateUrl="http://www.sure-trac.com">  
                                        </telerik:RadMenuItem> 
                                        <telerik:RadMenuItem runat="server" Text="Open Stock">  
                                            <Items> 
                                                <telerik:RadMenuItem runat="server" Text="Dealer Price" Value="d">  
                                                </telerik:RadMenuItem> 
                                                <telerik:RadMenuItem runat="server" Text="MSRP" Value="m">  
                                                </telerik:RadMenuItem> 
                                            </Items> 
                                        </telerik:RadMenuItem> 
                                        <telerik:RadMenuItem runat="server" Text="Orders">  
                                            <Items> 
                                                <telerik:RadMenuItem runat="server" Text="Order History" NavigateUrl="OrderHistory.aspx">  
                                                </telerik:RadMenuItem> 
                                                <telerik:RadMenuItem runat="server" Text="Pending Orders">  
                                                </telerik:RadMenuItem> 
                                            </Items> 
                                        </telerik:RadMenuItem> 
                                        <telerik:RadMenuItem runat="server" Text="Manage">  
                                        </telerik:RadMenuItem> 
                                    </Items> 
                                </telerik:RadMenu> 
                            </td> 
                            <td style="background-color: #D8E8FE; font-family: verdana; color: #000066 !important;" 
                                align="right">  
                                <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/images/icon-printer.gif" 
                                    OnClientClick="PrintRadGrid(); return false;" Height="23px" ToolTip="Print" Width="30px" /> 
                                <asp:LoginStatus ID="LoginStatus1" runat="server" /> 
                                &nbsp;  
                            </td> 
                        </tr> 
                        <tr> 
                            <td colspan="2">  
                                <!-- InstanceBeginEditable name="headercontent" --> 
                                <table width="100%" border="0" cellspacing="0" cellpadding="0">  
                                    <tr> 
                                        <td> 
                                            <table width="100%" border="0" cellspacing="0" cellpadding="0">  
                                                <tr> 
                                                    <td colspan="2" valign="top" bgcolor="#194094">  
                                                        <table width="100%" border="0" cellspacing="10" cellpadding="0">  
                                                            <tr> 
                                                                <td class="header2">  
                                                                    THE PROFESSIONAL ADVANTAGEâ„¢  
                                                                </td> 
                                                                <td class="header2" align="right">  
                                                                    <asp:Label ID="lblSelected" runat="server" Text=""></asp:Label> 
                                                                </td> 
                                                                <td class="header2" align="right">  
                                                                    <asp:Image ID="SelectedImage" runat="server" /> 
                                                                </td> 
                                                            </tr> 
                                                        </table> 
                                                    </td> 
                                                </tr> 
                                                <tr> 
                                                    <td width="29%" valign="top" bgcolor="#F79223">  
                                                        <table border="0" cellspacing="15" cellpadding="0">  
                                                            <tr> 
                                                                <td class="header2">  
                                                                    welcome:  
                                                                    <asp:LoginName ID="LoginName1" runat="server" /> 
                                                                    &nbsp;  
                                                                    <telerik:RadPanelBar ID="RadPanelBar1" runat="server" Skin="Web20" DataFieldID="MODEL">  
                                                                    </telerik:RadPanelBar> 
                                                                    <hr /> 
                                                                    <telerik:RadPanelBar ID="RadPanelBar2" runat="server" Skin="Web20" DataFieldID="MODEL">  
                                                                    </telerik:RadPanelBar> 
                                                                </td> 
                                                            </tr> 
                                                        </table> 
                                                    </td> 
                                                    <td width="71%" valign="top" align="right">  
                                                        <table width="100%" border="0" cellspacing="15" cellpadding="0">  
                                                            <tr> 
                                                                <td> 
                                                                    <div align="center">  
                                                                        <telerik:RadGrid ID="RadGrid1" runat="server" Width="100%" ShowStatusBar="True" AutoGenerateColumns="False" 
                                                                            ShowFooter="True" GridLines="Horizontal" AllowSorting="True">  
                                                                            <MasterTableView Width="100%" ClientDataKeyNames="WORK_ORDER" DataKeyNames="WORK_ORDER" 
                                                                                Name="Master">  
                                                                                <DetailTables> 
                                                                                    <telerik:GridTableView DataKeyNames="WORK_ORDER" Name="Sub" Width="100%">  
                                                                                        <Columns> 
                                                                                            <telerik:GridBoundColumn SortExpression="WORK_ORDER" HeaderText="WORK_ORDER ID" HeaderButtonType="TextButton" 
                                                                                                DataField="WORK_ORDER" Visible="false">  
                                                                                                <HeaderStyle Width="100px" HorizontalAlign="Center" BackColor="ForestGreen" /> 
                                                                                                <ItemStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                            </telerik:GridBoundColumn> 
                                                                                            <telerik:GridBoundColumn SortExpression="PART_ID" HeaderText="PART ID" HeaderButtonType="TextButton" 
                                                                                                DataField="PART_ID">  
                                                                                                <HeaderStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                                <ItemStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                            </telerik:GridBoundColumn> 
                                                                                            <telerik:GridBoundColumn SortExpression="DESCRIPTION" HeaderStyle-Width="250px" HeaderText="DESCRIPTION" 
                                                                                                HeaderButtonType="TextButton" DataField="DESCRIPTION" UniqueName="DESCRIPTION">  
                                                                                                <HeaderStyle Width="250px" HorizontalAlign="Left"></HeaderStyle> 
                                                                                                <ItemStyle Width="250px" HorizontalAlign="Left" /> 
                                                                                            </telerik:GridBoundColumn> 
                                                                                            <telerik:GridBoundColumn Aggregate="Sum" SortExpression="PRICE" HeaderText="PRICE" 
                                                                                                HeaderButtonType="TextButton" DataField="PRICE" DataFormatString="{0:$###,###.##}" 
                                                                                                FooterAggregateFormatString="TOTAL: {0:C}">  
                                                                                                <HeaderStyle Width="100px" HorizontalAlign="Left"></HeaderStyle> 
                                                                                                <ItemStyle Width="100px" HorizontalAlign="Left" /> 
                                                                                            </telerik:GridBoundColumn> 
                                                                                        </Columns> 
                                                                                    </telerik:GridTableView> 
                                                                                </DetailTables> 
                                                                                <ExpandCollapseColumn Visible="True">  
                                                                                </ExpandCollapseColumn> 
                                                                                <Columns> 
                                                                                    <telerik:GridBoundColumn DataField="WORK_ORDER" HeaderText="ORDER ID" SortExpression="WORK_ORDER" 
                                                                                        UniqueName="WORK_ORDER">  
                                                                                        <HeaderStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                        <ItemStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                    </telerik:GridBoundColumn> 
                                                                                    <telerik:GridBoundColumn DataField="DESCRIPTION" HeaderText="DESCRIPTION" SortExpression="DESCRIPTION" 
                                                                                        UniqueName="DESCRIPTION">  
                                                                                        <HeaderStyle Width="250px" HorizontalAlign="Left"></HeaderStyle> 
                                                                                        <ItemStyle Width="250px" HorizontalAlign="Left" /> 
                                                                                    </telerik:GridBoundColumn> 
                                                                                    <telerik:GridBoundColumn DataField="MODEL" HeaderText="MODEL" SortExpression="MODEL" 
                                                                                        UniqueName="MODEL">  
                                                                                        <HeaderStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                        <ItemStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                    </telerik:GridBoundColumn> 
                                                                                    <telerik:GridBoundColumn DataField="PRICE" DataType="System.Decimal" HeaderText="PRICE" 
                                                                                        SortExpression="PRICE" UniqueName="PRICE" DataFormatString="{0:$###,###.##}">  
                                                                                        <HeaderStyle Width="100px" HorizontalAlign="Left"></HeaderStyle> 
                                                                                        <ItemStyle Width="100px" HorizontalAlign="Left" /> 
                                                                                    </telerik:GridBoundColumn> 
                                                                                </Columns> 
                                                                            </MasterTableView> 
                                                                            <ClientSettings ReorderColumnsOnClient="True" AllowColumnsReorder="True">  
                                                                                <Selecting AllowRowSelect="True"></Selecting> 
                                                                            </ClientSettings> 
                                                                        </telerik:RadGrid> 
                                                                    </div> 
                                                                </td> 
                                                            </tr> 
                                                        </table> 
                                                    </td> 
                                                </tr> 
                                            </table> 
                                        </td> 
                                    </tr> 
                                </table> 
                                <!-- InstanceEndEditable --> 
                            </td> 
                        </tr> 
                        <tr> 
                            <td colspan="2">  
                                <table width="100%" border="0" cellspacing="0" cellpadding="4">  
                                    <tr> 
                                        <td height="32">  
                                            <span class="footercopy">&nbsp;&nbsp;&nbsp;Novae Corp.&nbsp;&nbsp;&nbsp;&nbsp;One Novae  
                                                Parkway &nbsp;&nbsp;&nbsp;&nbsp;Markle, IN 46770 &nbsp;&nbsp;&nbsp;&nbsp;Toll Free  
                                                <strong>800-372-1755</strong>&nbsp; &nbsp;&nbsp;&nbsp;Ph (260) 758-9838 &nbsp;&nbsp;&nbsp;&nbsp;Fax  
                                                (260) 758-9839 &nbsp;&nbsp;&nbsp;&nbsp;&copy; 2009 Novae Corp </span> 
                                        </td> 
                                    </tr> 
                                </table> 
                            </td> 
                        </tr> 
                    </table> 
                    &nbsp;  
                </td> 
            </tr> 
        </table> 
    </div> 
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NOVAEDealerOpenStock %>" 
        SelectCommand="SELECT distinct MODEL FROM Trailers"></asp:SqlDataSource> 
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">  
        <AjaxSettings> 
            <telerik:AjaxSetting AjaxControlID="RadMenu1">  
                <UpdatedControls> 
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> 
                    <telerik:AjaxUpdatedControl ControlID="HiddenPriceType" /> 
                    <telerik:AjaxUpdatedControl ControlID="HiddenCurrentModel" /> 
                    <telerik:AjaxUpdatedControl ControlID="ProductImage" /> 
                </UpdatedControls> 
            </telerik:AjaxSetting> 
            <telerik:AjaxSetting AjaxControlID="RadPanelBar1">  
                <UpdatedControls> 
                    <telerik:AjaxUpdatedControl ControlID="SelectedImage" /> 
                    <telerik:AjaxUpdatedControl ControlID="lblSelected" /> 
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> 
                    <telerik:AjaxUpdatedControl ControlID="HiddenPriceType" /> 
                    <telerik:AjaxUpdatedControl ControlID="HiddenCurrentModel" /> 
                    <telerik:AjaxUpdatedControl ControlID="ProductImage" /> 
                </UpdatedControls> 
            </telerik:AjaxSetting> 
        </AjaxSettings> 
    </telerik:RadAjaxManager> 
    <br /> 
    <div style="visibility: hidden;">  
        <img alt="" src="Trailer_Images/Angle%20Car%20Hauler.jpg" /> 
        <img alt="" src="Trailer_Images/Deckover.jpg" /> 
        <img alt="" src="Trailer_Images/High%20Side%20Angle.jpg" /> 
        <img alt="" src="Trailer_Images/High%20Side%20Three%20Board.jpg" /> 
        <img alt="" src="Trailer_Images/Homeowner%20Dump.jpg" /> 
        <img alt="" src="Trailer_Images/Tube%20Top.jpg" /> 
        <img alt="" src="Trailer_Images/Wood%20Deck%20Car%20Hauler.jpg" /> 
        <img alt="" src="Trailer_Images/Angle%20Car%20HaulerPanel.jpg" style="height: 146px;  
            width: 215px" /> 
        <img alt="" src="Trailer_Images/DeckoverPanel.jpg" style="height: 146px; width: 215px" /> 
        <img alt="" src="Trailer_Images/High%20Side%20AnglePanel.jpg" style="height: 146px;  
            width: 215px" /> 
        <img alt="" src="Trailer_Images/High%20Side%20Three%20BoardPanel.jpg" style="height: 146px;  
            width: 215px" /> 
        <img alt="" src="Trailer_Images/Homeowner%20DumpPanel.jpg" style="height: 146px;  
            width: 215px" /> 
        <img alt="" src="Trailer_Images/Tube%20TopPanel.jpg" style="height: 146px; width: 215px" /> 
        <img alt="" src="Trailer_Images/Wood%20Deck%20Car%20HaulerPanel.jpg" style="height: 146px;  
            width: 215px" /> 
    </div> 
    <telerik:RadToolTipManager ID="RadToolTipManager1" runat="server">  
    </telerik:RadToolTipManager> 
    <asp:HiddenField ID="HiddenPriceType" runat="server" /> 
    <asp:HiddenField ID="HiddenCurrentModel" runat="server" /> 
    <telerik:RadGrid ID="RadGrid2" runat="server" Skin="Outlook">  
        <MasterTableView> 
            <RowIndicatorColumn> 
                <HeaderStyle Width="20px"></HeaderStyle> 
            </RowIndicatorColumn> 
            <ExpandCollapseColumn> 
                <HeaderStyle Width="20px"></HeaderStyle> 
            </ExpandCollapseColumn> 
        </MasterTableView> 
    </telerik:RadGrid> 
    </form> 
</body> 
</html> 
 

Imports DealerOpenStock.BLL  
Imports System.Data.SqlClient  
Imports Telerik.Web.UI  
Partial Class DealerPortal  
    Inherits System.Web.UI.Page  
 
    Protected Sub RadGrid1_DetailTableDataBind(ByVal source As Object, ByVal e As Telerik.Web.UI.GridDetailTableDataBindEventArgs) Handles RadGrid1.DetailTableDataBind  
 
        Dim dataItem As GridDataItem = CType(e.DetailTableView.ParentItem, GridDataItem)  
        dataItem.Selected = True 
 
        Dim OrderID As String = dataItem.GetDataKeyValue("WORK_ORDER").ToString()  
 
        Dim openstockDetail As SqlDataReader = DealerOpenStocks.GetOpenStockDetail(OrderID, HiddenPriceType.Value)  
        e.DetailTableView.DataSource = openstockDetail 
 
        Dim InnerHeaderStyle As New Style()  
        InnerHeaderStyle.ForeColor = Drawing.Color.Navy  
        e.DetailTableView.ApplyStyle(InnerHeaderStyle)  
 
    End Sub  
 
    Protected Sub RadPanelBar1_ItemClick(ByVal sender As Object, ByVal e As Telerik.Web.UI.RadPanelBarEventArgs) Handles RadPanelBar1.ItemClick  
 
        HiddenCurrentModel.Value = e.Item.Text  
        LoadOpenStock(e.Item.Text)  
        SelectedImage.ImageUrl = "Trailer_Images/" & e.Item.Text & ".jpg"  
        lblSelected.Text = e.Item.Text  
 
    End Sub  
 
 
 
    Private Sub LoadOpenStock(ByVal Model As String)  
 
        Dim PriceType As String = HiddenPriceType.Value  
        Dim openstock As SqlDataReader = DealerOpenStocks.GetOpenStock(Model, HiddenPriceType.Value)  
        RadGrid1.DataSource = openstock 
        RadGrid1.DataBind()  
 
    End Sub  
 
      
 
    Protected Sub RadMenu1_ItemClick(ByVal sender As Object, ByVal e As RadMenuEventArgs)  
 
        Select Case e.Item.Value  
            Case "d"  
                HiddenPriceType.Value = "d" 
                RadGrid1.Skin = "Sunset" 
 
            Case "m"  
                HiddenPriceType.Value = "m" 
                RadGrid1.Skin = "Outlook" 
 
            Case Else  
                HiddenPriceType.Value = "d" 
                RadGrid1.Skin = "Sunset" 
        End Select  
 
        If Not HiddenCurrentModel.Value = "" Then  
 
            LoadOpenStock(HiddenCurrentModel.Value)  
 
        End If  
 
    End Sub  
 
 
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load  
 
        If Not Page.IsPostBack Then  
 
            Dim trailers As SqlDataReader = DealerOpenStocks.GetTrailerModels()  
 
            While trailers.Read  
 
                Select Case trailers.Item("MODEL").ToString  
 
                    Case "Round Top Tube"  
                        AddTrailerModel("enclosed", trailers.Item("MODEL").ToString)  
 
                    Case "Round Top"  
                        AddTrailerModel("enclosed", trailers.Item("MODEL").ToString)  
 
                    Case Else  
                        AddTrailerModel("open", trailers.Item("MODEL").ToString)  
 
                End Select  
 
            End While  
 
        End If  
 
    End Sub  
    Private Sub AddTrailerModel(ByVal _trailerType As String, ByVal _trailerValue As String)  
 
        Dim trailerItem As New RadPanelItem()  
        trailerItem.Text = _trailerValue 
        trailerItem.Value = _trailerValue 
        trailerItem.ImageUrl = "Trailer_Images/" & _trailerValue & "Panel.jpg"  
        trailerItem.ImagePosition = RadPanelItemImagePosition.Right  
        trailerItem.Expanded = False 
         
        If Not _trailerType = "enclosed" Then  
            RadPanelBar1.Items.Add(trailerItem)  
 
        Else  
            RadPanelBar2.Items.Add(trailerItem)  
 
        End If  
 
    End Sub  
 
    Protected Sub Page_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreRender  
        If (Not User.Identity.IsAuthenticated) Then  
            Response.Redirect("login.aspx?ReturnUrl=DealerPortal.aspx?")  
 
        Else  
 
            If Not Page.IsPostBack Then  
 
                HiddenCurrentModel.Value = "Tube Top" 
                RadGrid1.Skin = "Sunset" 
                LoadOpenStock(HiddenCurrentModel.Value)  
 
            End If  
 
        End If  
    End Sub  
 
    Protected Sub RadPanelBar2_ItemClick(ByVal sender As Object, ByVal e As Telerik.Web.UI.RadPanelBarEventArgs) Handles RadPanelBar2.ItemClick  
 
        HiddenCurrentModel.Value = e.Item.Text  
        LoadOpenStock(e.Item.Text)  
 
        SelectedImage.ImageUrl = "Trailer_Images/" & e.Item.Text & ".jpg"  
        lblSelected.Text = e.Item.Text  
 
    End Sub  
End Class 

0
Johny
Top achievements
Rank 1
answered on 06 Nov 2009, 09:22 AM
Hi Larry

I tried your code and it is OK on my side. I only changed the source - i am using Northwind database:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %> 
 
<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml"
<head id="Head1" runat="server"
    <title>Sure-Trac - Dealer Page</title> 
    <link href="css/st2009.css" rel="stylesheet" type="text/css" /> 
    <link href="css/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" /> 
    <style type="text/css"
        .DetailTable Outlook caption 
        { 
            color: blue; 
            background-color: red; 
        } 
        .InnerHeaderStyle 
        { 
            background: navy !important; 
            font-size: 13px !important; 
            color: white !important; /*add more style definitions here*/ 
        } 
    </style> 
</head> 
<body> 
    <form id="form1" runat="server"
    <telerik:RadScriptManager ID="RadScriptManager1" runat="server"
    </telerik:RadScriptManager> 
    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server"
 
        <script type="text/javascript"
            function PrintRadGrid() 
            { 
                var previewWnd = window.open('about:blank', '', '', false); 
                var sh = '<%= ClientScript.GetWebResourceUrl(RadGrid1.GetType(),String.Format("Telerik.Web.UI.Skins.{0}.Grid.{0}.css",RadGrid1.Skin)) %>'
                var styleStr = "<html><head><link href = '" + sh + "' rel='stylesheet' type='text/css'></link></head>"; 
                var detailTable = $find('<%= RadGrid1.ClientID %>').get_detailTables()[0]; 
                var htmlcontent = styleStr + "<body><div class='RadGrid RadGrid_Simple'>" + detailTable.get_element().outerHTML + "</div></body></html>"; 
                previewWnd.document.open(); 
                previewWnd.document.write(htmlcontent); 
                previewWnd.document.close(); 
                previewWnd.print(); 
            } 
            function imageMouseOver(sender, eventArgs) 
            { 
                var tooltipManager = $find("<%= RadToolTipManager1.ClientID %>"); 
                if (!tooltipManager) return; 
                var tooltip = tooltipManager.getToolTipByElement(element); 
                if (!tooltip) 
                { 
                    tooltip = tooltipManager.createToolTip(element); 
 
                    tooltip.set_value(arguments[1].toString()); 
                } 
                tooltip.show(); 
                //var item = eventArgs.get_item();        
                var imagename = eventArgs.get_item().get_text() + '.jpg'; 
                //alert();           
                document.images["ProductImage"].src = "Trailer_Images/" + imagename; 
            } 
            function HierarchyExpanding(sender, args) 
            { 
                alert('in'); 
            }   
        </script> 
 
    </telerik:RadCodeBlock> 
    <div> 
        <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" 
            id="master"
            <tr> 
                <td> 
                    <table width="950" border="0" align="left" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"
                        <tr> 
                            <td colspan="2"
                                <table width="950" cellspacing="0" cellpadding="0"
                                    <tr> 
                                        <td> 
                                            <div align="right"
                                                <img src="images/st__searchblock.jpg" alt="" width="950" height="54" border="0" usemap="#dealers" /><span 
                                                    class="footercopy"><br /> 
                                                </span> 
                                            </div> 
                                        </td> 
                                    </tr> 
                                </table> 
                            </td> 
                        </tr> 
                        <tr> 
                            <td colspan="2"
                                <img src="images/st__logo.jpg" alt="" width="950" height="65" border="0" usemap="#HOME" /> 
                            </td> 
                        </tr> 
                        <tr> 
                            <td style="background-color: #D8E8FE"
                                <telerik:RadMenu ID="RadMenu1" runat="server" Skin="Office2007" OnItemClick="RadMenu1_ItemClick"
                                    <Items> 
                                        <telerik:RadMenuItem runat="server" Text="Home" NavigateUrl="http://www.sure-trac.com"
                                        </telerik:RadMenuItem> 
                                        <telerik:RadMenuItem runat="server" Text="Open Stock"
                                            <Items> 
                                                <telerik:RadMenuItem runat="server" Text="Dealer Price" Value="d"
                                                </telerik:RadMenuItem> 
                                                <telerik:RadMenuItem runat="server" Text="MSRP" Value="m"
                                                </telerik:RadMenuItem> 
                                            </Items> 
                                        </telerik:RadMenuItem> 
                                        <telerik:RadMenuItem runat="server" Text="Orders"
                                            <Items> 
                                                <telerik:RadMenuItem runat="server" Text="Order History" NavigateUrl="OrderHistory.aspx"
                                                </telerik:RadMenuItem> 
                                                <telerik:RadMenuItem runat="server" Text="Pending Orders"
                                                </telerik:RadMenuItem> 
                                            </Items> 
                                        </telerik:RadMenuItem> 
                                        <telerik:RadMenuItem runat="server" Text="Manage"
                                        </telerik:RadMenuItem> 
                                    </Items> 
                                </telerik:RadMenu> 
                            </td> 
                            <td style="background-color: #D8E8FE; font-family: verdana; color: #000066 !important;" 
                                align="right"
                                <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/images/icon-printer.gif" 
                                    OnClientClick="PrintRadGrid(); return false;" Height="23px" ToolTip="Print" Width="30px" /> 
                                <asp:LoginStatus ID="LoginStatus1" runat="server" /> 
                            </td> 
                        </tr> 
                        <tr> 
                            <td colspan="2"
                                <!-- InstanceBeginEditable name="headercontent" --> 
                                <table width="100%" border="0" cellspacing="0" cellpadding="0"
                                    <tr> 
                                        <td> 
                                            <table width="100%" border="0" cellspacing="0" cellpadding="0"
                                                <tr> 
                                                    <td colspan="2" valign="top" bgcolor="#194094"
                                                        <table width="100%" border="0" cellspacing="10" cellpadding="0"
                                                            <tr> 
                                                                <td class="header2"
                                                                    THE PROFESSIONAL ADVANTAGEâ„¢ 
                                                                </td> 
                                                                <td class="header2" align="right"
                                                                    <asp:Label ID="lblSelected" runat="server" Text=""></asp:Label> 
                                                                </td> 
                                                                <td class="header2" align="right"
                                                                    <asp:Image ID="SelectedImage" runat="server" /> 
                                                                </td> 
                                                            </tr> 
                                                        </table> 
                                                    </td> 
                                                </tr> 
                                                <tr> 
                                                    <td width="29%" valign="top" bgcolor="#F79223"
                                                        <table border="0" cellspacing="15" cellpadding="0"
                                                            <tr> 
                                                                <td class="header2"
                                                                    welcome: 
                                                                    <telerik:RadPanelBar ID="RadPanelBar1" runat="server" Skin="Web20" DataFieldID="MODEL"
                                                                    </telerik:RadPanelBar> 
                                                                    <hr /> 
                                                                    <telerik:RadPanelBar ID="RadPanelBar2" runat="server" Skin="Web20" DataFieldID="MODEL"
                                                                    </telerik:RadPanelBar> 
                                                                </td> 
                                                            </tr> 
                                                        </table> 
                                                    </td> 
                                                    <td width="71%" valign="top" align="right"
                                                        <table width="100%" border="0" cellspacing="15" cellpadding="0"
                                                            <tr> 
                                                                <td> 
                                                                    <div align="center"
                                                                        <telerik:RadGrid ID="RadGrid1" runat="server" Width="100%" ShowStatusBar="True" AutoGenerateColumns="False" 
                                                                            ShowFooter="True" GridLines="Horizontal" AllowSorting="True" OnDetailTableDataBind="RadGrid1_DetailTableDataBind"
                                                                            <MasterTableView Width="100%" ClientDataKeyNames="OrderID" DataKeyNames="OrderID" 
                                                                                Name="Master"
                                                                                <DetailTables> 
                                                                                    <telerik:GridTableView DataKeyNames="OrderID" Name="Sub" Width="100%"
                                                                                        <ParentTableRelation> 
                                                                                            <telerik:GridRelationFields DetailKeyField="OrderID" MasterKeyField="OrderID" /> 
                                                                                        </ParentTableRelation> 
                                                                                        <Columns> 
                                                                                            <telerik:GridBoundColumn SortExpression="OrderID" HeaderText="OrderID" HeaderButtonType="TextButton" 
                                                                                                DataField="OrderID" Visible="false"
                                                                                                <HeaderStyle Width="100px" HorizontalAlign="Center" BackColor="ForestGreen" /> 
                                                                                                <ItemStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                            </telerik:GridBoundColumn> 
                                                                                            <telerik:GridBoundColumn SortExpression="ProductID" HeaderText="ProductID" HeaderButtonType="TextButton" 
                                                                                                DataField="ProductID"
                                                                                                <HeaderStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                                <ItemStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                            </telerik:GridBoundColumn> 
                                                                                            <telerik:GridBoundColumn SortExpression="Quantity" HeaderStyle-Width="250px" HeaderText="Quantity" 
                                                                                                HeaderButtonType="TextButton" DataField="Quantity" UniqueName="Quantity"
                                                                                                <HeaderStyle Width="250px" HorizontalAlign="Left"></HeaderStyle> 
                                                                                                <ItemStyle Width="250px" HorizontalAlign="Left" /> 
                                                                                            </telerik:GridBoundColumn> 
                                                                                            <telerik:GridBoundColumn Aggregate="Sum" SortExpression="UnitPrice" HeaderText="UnitPrice" 
                                                                                                HeaderButtonType="TextButton" DataField="UnitPrice" DataFormatString="{0:$###,###.##}" 
                                                                                                FooterAggregateFormatString="TOTAL: {0:C}"
                                                                                                <HeaderStyle Width="100px" HorizontalAlign="Left"></HeaderStyle> 
                                                                                                <ItemStyle Width="100px" HorizontalAlign="Left" /> 
                                                                                            </telerik:GridBoundColumn> 
                                                                                        </Columns> 
                                                                                    </telerik:GridTableView> 
                                                                                </DetailTables> 
                                                                                <ExpandCollapseColumn Visible="True"
                                                                                </ExpandCollapseColumn> 
                                                                                <Columns> 
                                                                                    <telerik:GridBoundColumn DataField="OrderID" HeaderText="OrderID" SortExpression="OrderID" 
                                                                                        UniqueName="OrderID"
                                                                                        <HeaderStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                        <ItemStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                    </telerik:GridBoundColumn> 
                                                                                    <telerik:GridBoundColumn DataField="CustomerID" HeaderText="CustomerID" SortExpression="CustomerID" 
                                                                                        UniqueName="CustomerID"
                                                                                        <HeaderStyle Width="250px" HorizontalAlign="Left"></HeaderStyle> 
                                                                                        <ItemStyle Width="250px" HorizontalAlign="Left" /> 
                                                                                    </telerik:GridBoundColumn> 
                                                                                    <telerik:GridBoundColumn DataField="EmployeeID" HeaderText="EmployeeID" SortExpression="EmployeeID" 
                                                                                        UniqueName="EmployeeID"
                                                                                        <HeaderStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                        <ItemStyle Width="100px" HorizontalAlign="Center" /> 
                                                                                    </telerik:GridBoundColumn> 
                                                                                    <telerik:GridBoundColumn DataField="Freight" DataType="System.Decimal" HeaderText="Freight" 
                                                                                        SortExpression="Freight" UniqueName="Freight" DataFormatString="{0:$###,###.##}"
                                                                                        <HeaderStyle Width="100px" HorizontalAlign="Left"></HeaderStyle> 
                                                                                        <ItemStyle Width="100px" HorizontalAlign="Left" /> 
                                                                                    </telerik:GridBoundColumn> 
                                                                                </Columns> 
                                                                            </MasterTableView> 
                                                                            <ClientSettings ReorderColumnsOnClient="True" AllowColumnsReorder="True"
                                                                                <Selecting AllowRowSelect="True"></Selecting> 
                                                                            </ClientSettings> 
                                                                        </telerik:RadGrid> 
                                                                    </div> 
                                                                </td> 
                                                            </tr> 
                                                        </table> 
                                                    </td> 
                                                </tr> 
                                            </table> 
                                        </td> 
                                    </tr> 
                                </table> 
                                <!-- InstanceEndEditable --> 
                            </td> 
                        </tr> 
                        <tr> 
                            <td colspan="2"
                                <table width="100%" border="0" cellspacing="0" cellpadding="4"
                                    <tr> 
                                        <td height="32"
                                            <span class="footercopy">Novae Corp. One Novae Parkway Markle, IN 46770 Toll Free <strong> 
                                                800-372-1755</strong> Ph (260) 758-9838 Fax (260) 758-9839 Â© 2009 Novae Corp 
                                            </span> 
                                        </td> 
                                    </tr> 
                                </table> 
                            </td> 
                        </tr> 
                    </table> 
                </td> 
            </tr> 
        </table> 
    </div> 
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT TOP 10 [OrderID], [CustomerID], [EmployeeID], [Freight] FROM [Orders]"
    </asp:SqlDataSource> 
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT TOP 3 [OrderID], [ProductID], [Quantity], [UnitPrice] FROM [Order Details] WHERE ([OrderID] = @OrderID)"
        <SelectParameters> 
            <asp:Parameter Name="OrderID" Type="Int32" /> 
        </SelectParameters> 
    </asp:SqlDataSource> 
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"
        <AjaxSettings> 
            <telerik:AjaxSetting AjaxControlID="RadMenu1"
                <UpdatedControls> 
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> 
                    <telerik:AjaxUpdatedControl ControlID="HiddenPriceType" /> 
                    <telerik:AjaxUpdatedControl ControlID="HiddenCurrentModel" /> 
                    <telerik:AjaxUpdatedControl ControlID="ProductImage" /> 
                </UpdatedControls> 
            </telerik:AjaxSetting> 
            <telerik:AjaxSetting AjaxControlID="RadPanelBar1"
                <UpdatedControls> 
                    <telerik:AjaxUpdatedControl ControlID="SelectedImage" /> 
                    <telerik:AjaxUpdatedControl ControlID="lblSelected" /> 
                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" /> 
                    <telerik:AjaxUpdatedControl ControlID="HiddenPriceType" /> 
                    <telerik:AjaxUpdatedControl ControlID="HiddenCurrentModel" /> 
                    <telerik:AjaxUpdatedControl ControlID="ProductImage" /> 
                </UpdatedControls> 
            </telerik:AjaxSetting> 
        </AjaxSettings> 
    </telerik:RadAjaxManager> 
    <br /> 
    <div style="visibility: hidden;"
        <img alt="" src="Trailer_Images/Angle%20Car%20Hauler.jpg" /> 
        <img alt="" src="Trailer_Images/Deckover.jpg" /> 
        <img alt="" src="Trailer_Images/High%20Side%20Angle.jpg" /> 
        <img alt="" src="Trailer_Images/High%20Side%20Three%20Board.jpg" /> 
        <img alt="" src="Trailer_Images/Homeowner%20Dump.jpg" /> 
        <img alt="" src="Trailer_Images/Tube%20Top.jpg" /> 
        <img alt="" src="Trailer_Images/Wood%20Deck%20Car%20Hauler.jpg" /> 
        <img alt="" src="Trailer_Images/Angle%20Car%20HaulerPanel.jpg" style="height: 146px; 
            width: 215px" /> 
        <img alt="" src="Trailer_Images/DeckoverPanel.jpg" style="height: 146px; width: 215px" /> 
        <img alt="" src="Trailer_Images/High%20Side%20AnglePanel.jpg" style="height: 146px; 
            width: 215px" /> 
        <img alt="" src="Trailer_Images/High%20Side%20Three%20BoardPanel.jpg" style="height: 146px; 
            width: 215px" /> 
        <img alt="" src="Trailer_Images/Homeowner%20DumpPanel.jpg" style="height: 146px; 
            width: 215px" /> 
        <img alt="" src="Trailer_Images/Tube%20TopPanel.jpg" style="height: 146px; width: 215px" /> 
        <img alt="" src="Trailer_Images/Wood%20Deck%20Car%20HaulerPanel.jpg" style="height: 146px; 
            width: 215px" /> 
    </div> 
    <telerik:RadToolTipManager ID="RadToolTipManager1" runat="server"
    </telerik:RadToolTipManager> 
    <asp:HiddenField ID="HiddenPriceType" runat="server" /> 
    <asp:HiddenField ID="HiddenCurrentModel" runat="server" /> 
    <telerik:RadGrid ID="RadGrid2" runat="server" Skin="Outlook"
        <MasterTableView> 
            <RowIndicatorColumn> 
                <HeaderStyle Width="20px"></HeaderStyle> 
            </RowIndicatorColumn> 
            <ExpandCollapseColumn> 
                <HeaderStyle Width="20px"></HeaderStyle> 
            </ExpandCollapseColumn> 
        </MasterTableView> 
    </telerik:RadGrid> 
    </form> 
</body> 
</html> 

This is my code behind:

Imports System.Data 
Imports Telerik.Web.UI 
Imports System.Data.SqlClient 
Partial Class Default2 
    Inherits System.Web.UI.Page 
 
 
    Protected Sub RadGrid1_DetailTableDataBind(ByVal source As ObjectByVal e As Telerik.Web.UI.GridDetailTableDataBindEventArgs) Handles RadGrid1.DetailTableDataBind 
        e.DetailTableView.DataSourceID = SqlDataSource2.ID 
    End Sub 
 
    Protected Sub RadPanelBar1_ItemClick(ByVal sender As ObjectByVal e As Telerik.Web.UI.RadPanelBarEventArgs) Handles RadPanelBar1.ItemClick 
 
        HiddenCurrentModel.Value = e.Item.Text 
        LoadOpenStock(e.Item.Text) 
        SelectedImage.ImageUrl = "Trailer_Images/" + e.Item.Text + ".jpg" 
 
        lblSelected.Text = e.Item.Text 
    End Sub 
 
 
 
    Private Sub LoadOpenStock(ByVal Model As String
        RadGrid1.DataSourceID = SqlDataSource1.ID 
    End Sub 
 
 
 
    Protected Sub RadMenu1_ItemClick(ByVal sender As ObjectByVal e As RadMenuEventArgs) 
 
        Select Case e.Item.Value 
            Case "d" 
                HiddenPriceType.Value = "d" 
                RadGrid1.Skin = "Sunset" 
 
                Exit Select 
            Case "m" 
                HiddenPriceType.Value = "m" 
                RadGrid1.Skin = "Outlook" 
 
                Exit Select 
            Case Else 
                HiddenPriceType.Value = "d" 
                RadGrid1.Skin = "Sunset" 
                Exit Select 
        End Select 
 
        If Not String.IsNullOrEmpty(HiddenCurrentModel.Value) Then 
 
 
 
            LoadOpenStock(HiddenCurrentModel.Value) 
        End If 
    End Sub 
 
 
    Protected Sub Page_Load(ByVal sender As ObjectByVal e As System.EventArgs) Handles Me.Load 
 
    End Sub 
    Private Sub AddTrailerModel(ByVal _trailerType As StringByVal _trailerValue As String
 
        Dim trailerItem As New RadPanelItem() 
        trailerItem.Text = _trailerValue 
        trailerItem.Value = _trailerValue 
        trailerItem.ImageUrl = "Trailer_Images/" + _trailerValue + "Panel.jpg" 
        trailerItem.ImagePosition = RadPanelItemImagePosition.Right 
        trailerItem.Expanded = False 
 
        If Not (_trailerType = "enclosed"Then 
 
            RadPanelBar1.Items.Add(trailerItem) 
        Else 
 
 
            RadPanelBar2.Items.Add(trailerItem) 
        End If 
    End Sub 
 
    Protected Sub Page_PreRender(ByVal sender As ObjectByVal e As System.EventArgs) Handles Me.PreRender 
        If (Not User.Identity.IsAuthenticated) Then 
 
            Response.Redirect("login.aspx?ReturnUrl=DealerPortal.aspx?"
        Else 
 
            If Not Page.IsPostBack Then 
 
                HiddenCurrentModel.Value = "Tube Top" 
                RadGrid1.Skin = "Sunset" 
 
 
                LoadOpenStock(HiddenCurrentModel.Value) 
            End If 
        End If 
    End Sub 
 
    Protected Sub RadPanelBar2_ItemClick(ByVal sender As ObjectByVal e As Telerik.Web.UI.RadPanelBarEventArgs) Handles RadPanelBar2.ItemClick 
 
        HiddenCurrentModel.Value = e.Item.Text 
        LoadOpenStock(e.Item.Text) 
 
        SelectedImage.ImageUrl = "Trailer_Images/" + e.Item.Text + ".jpg" 
 
        lblSelected.Text = e.Item.Text 
    End Sub 
End Class 

And once again attached is the result image.

Thanks
Johny
0
stewster
Top achievements
Rank 1
answered on 19 Nov 2009, 02:46 PM

Thanks for all your help Johny. But once again I had to circumvent a Telerik control. I did my totals server side and added them to the footer manually. I've been using Telerik for almost 4 years know and have had nothing but issues along the way. Some have been fixed in upgrades but all in all it is much more time consuming trying to get these controls working than to do it the old fashion way.

Rapid development needs to be rapid.
Tags
Grid
Asked by
stewster
Top achievements
Rank 1
Answers by
stewster
Top achievements
Rank 1
Johny
Top achievements
Rank 1
Larry
Top achievements
Rank 1
Share this question
or