Grid Export to Excel Issue

[Ryan]

I have the following page that pulls a simple grid and I got it to export to excel fine after checking out the demos.
How ever now, when the page loads the grid is empty until I select something from the drop down list.

Any ideas on how I should get the grid to populate with the first in the list when the page first loads?

<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="report_daily_status_list.aspx.vb" Inherits="FacilityCodingStatus.report_daily_status_list" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">

    <h2>Daily Status list</h2>

    <asp:SqlDataSource ID="dsSiteList" runat="server"

        ConnectionString="<%$ ConnectionStrings:ServiceAudit_ConnectionString %>"

        SelectCommand="FacilityCodingStatus_SiteList"

        SelectCommandType="StoredProcedure"></asp:SqlDataSource>

 

 

    <asp:SqlDataSource ID="dsDailyStatuslist" runat="server"

        ConnectionString="<%$ ConnectionStrings:ServiceAudit_ConnectionString %>"

        SelectCommand="FacilityCodingStatus_DailyStatuslist"

        SelectCommandType="StoredProcedure">

        <SelectParameters>

            <asp:ControlParameter ControlID="cbSiteID" Name="sSiteID"

                PropertyName="SelectedValue" Type="String" />

        </SelectParameters>

    </asp:SqlDataSource>

 

    <script type="text/javascript">

        function onRequestStart(sender, args) {

            if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0 ||

                    args.get_eventTarget().indexOf("ExportToWordButton") >= 0 ||

                    args.get_eventTarget().indexOf("ExportToCsvButton") >= 0) {

                args.set_enableAjax(false);

            }

        }

    </script>

 

    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

        <ClientEvents OnRequestStart="onRequestStart" />

        <AjaxSettings>

            <telerik:AjaxSetting AjaxControlID="RadGrid1">

                <UpdatedControls>

                    <telerik:AjaxUpdatedControl ControlID="RadGrid1" />

                </UpdatedControls>

            </telerik:AjaxSetting>

        </AjaxSettings>

    </telerik:RadAjaxManager>

 

 

 

<p>Select a Site:<telerik:RadComboBox ID="cbSiteID" Runat="server" DataSourceID="dsSiteList"

        DataTextField="SiteDisplay" DataValueField="sSiteID" AutoPostBack="True">

    </telerik:RadComboBox>

 

</p>

 

 

 

 

    <telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True"

        AutoGenerateColumns="False" CellSpacing="0" DataSourceID="dsDailyStatuslist"

        GridLines="None" OnItemCommand="RadGrid1_ItemCommand">

 

            <ExportSettings ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true" HideStructureColumns="true">

                <Excel Format="ExcelML" />

            </ExportSettings>

 

<MasterTableView DataSourceID="dsDailyStatuslist"  CommandItemDisplay="Top">

<CommandItemSettings ExportToPdfText="Export to PDF" ShowExportToExcelButton="true" ShowAddNewRecordButton="false"></CommandItemSettings>

 

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">

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

</RowIndicatorColumn>

 

 

 

<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">

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

</ExpandCollapseColumn>

 

    <Columns>

        <telerik:GridBoundColumn DataField="sSiteID"

            FilterControlAltText="Filter sSiteID column" HeaderText="SiteID"

            SortExpression="sSiteID" UniqueName="sSiteID">

        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="MEDRECNUM"

            FilterControlAltText="Filter MEDRECNUM column" HeaderText="MedRec#"

            SortExpression="MEDRECNUM" UniqueName="MEDRECNUM">

        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="sDOS"

            FilterControlAltText="Filter sDOS column" HeaderText="DOS"

            SortExpression="sDOS" UniqueName="sDOS">

        </telerik:GridBoundColumn>

 

 

        <telerik:GridBoundColumn DataField="LASTNAME"

            FilterControlAltText="Filter LASTNAME column" HeaderText="Last Name"

            SortExpression="LASTNAME" UniqueName="LASTNAME">

        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="FIRSTNAME"

            FilterControlAltText="Filter FIRSTNAME column" HeaderText="First Name"

            SortExpression="FIRSTNAME" UniqueName="FIRSTNAME">

        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="EXCEPTIONCODE" DataType="System.Int32"

            FilterControlAltText="Filter EXCEPTIONCODE column" HeaderText="Ex Code"

            SortExpression="EXCEPTIONCODE" UniqueName="EXCEPTIONCODE">

        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="DateReceived" DataType="System.DateTime"

            FilterControlAltText="Filter DateReceived column" HeaderText="Date Received"

            SortExpression="DateReceived" UniqueName="DateReceived">

        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="DateCoded" DataType="System.DateTime"

            FilterControlAltText="Filter DateCoded column" HeaderText="Date Coded"

            SortExpression="DateCoded" UniqueName="DateCoded">

        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="DateHeld" DataType="System.DateTime"

            FilterControlAltText="Filter DateHeld column" HeaderText="Date Held"

            SortExpression="DateHeld" UniqueName="DateHeld">

        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="DateReleased" DataType="System.DateTime"

            FilterControlAltText="Filter DateReleased column" HeaderText="Date Released"

            SortExpression="DateReleased" UniqueName="DateReleased">

        </telerik:GridBoundColumn>

    </Columns>

 

<EditFormSettings>

<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>

</EditFormSettings>

</MasterTableView>

 

<FilterMenu EnableImageSprites="False"></FilterMenu>

 

<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>

    </telerik:RadGrid>

 

 

</asp:Content>

[Princy]

Hello Ryan,

You can set the seleted property for the DropDownListItem with which you want to populate the Grid initially.
aspx:

<telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource3">
</telerik:RadGrid>
<asp:DropDownList ID="DDL1" runat="server" AutoPostBack="true" >
            <asp:ListItem Text="select" Value="1"></asp:ListItem>
            <asp:ListItem Text="Text1" Value="10643" Selected="True"></asp:ListItem>
            <asp:ListItem Text="Text2" Value="10249"></asp:ListItem>
            <asp:ListItem Text="Text3" Value="10264"></asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource3" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
            ProviderName="System.Data.SqlClient" SelectCommand="SELECT [OrderID], [UnitPrice], [Quantity], [Discount] FROM [Order Details] WHERE ([OrderID] = @OrderID)"
            runat="server">
            <SelectParameters>
                <asp:ControlParameter ControlID="DDL1" Name="OrderID" PropertyName="SelectedValue"
                    DbType="String" />
            </SelectParameters>
</asp:SqlDataSource>

Thanks,
Princy.