Home ›
ASP.NET Forums » General ASP.NET » Data Presentation Controls » Newbie GridView problem

Newbie GridView problem

Last post 03-03-2008 9:44 AM by illmo76. 2 replies.

Sort Posts:

  • Newbie GridView problem

    03-03-2008, 9:28 AM
    • Member
      16 point Member
    • illmo76
    • Member since 01-30-2008, 11:21 AM
    • Posts 52

    I have a GridView that is not showing up. I am passing 4 QueryString Parameters from a form page to a page with my GridView but nothing appears. I have a SQLDataSource that uses a stored procedure and it tests fine. Here is my code. Any help is appreciated...

    <%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="ECITypes.aspx.vb" Inherits="secure_admin_ECITypes" title="ECI Child Care Types" %>

    <asp:Content ID="Content1" ContentPlaceHolderID="CPH1" Runat="Server">

    <asp:SqlDataSource ID="ECItypesSQL" runat="server" ConnectionString="<%$ ConnectionStrings:LocalSqlServer2 %>"

    SelectCommand="mf_CCTypeOptions" SelectCommandType="StoredProcedure">

    <SelectParameters>

    <asp:QueryStringParameter Name="cctype" QueryStringField="typeID" Type="Int32" />

    <asp:QueryStringParameter Name="geogtype" QueryStringField="geogarea" Type="String" />

    <asp:QueryStringParameter Name="geogarea" QueryStringField="geog" Type="String" />

    <asp:QueryStringParameter Name="ccdate" QueryStringField="year" Type="String" />

    </SelectParameters>

    </asp:SqlDataSource>

    <asp:GridView ID="GridView1" runat="server" DataSourceID="ECItypesSQL" AutoGenerateColumns="true">

    </asp:GridView>

    </asp:Content>

  • Re: Newbie GridView problem

    03-03-2008, 9:37 AM
    Answer
    • All-Star
      86,764 point All-Star
    • ecbruck
    • Member since 12-30-2005, 7:39 PM
    • Des Moines, IA
    • Posts 9,209
    • Moderator
      TrustedFriends-MVPs

    By default, if any of your Parameters are empty, your SqlDataSource Select event will be cancelled. To change this behavior, set the SqlDataSource.CancelSelectOnNullParameter is set to False.

    Thanks, Ed

    Microsoft MVP - ASP/ASP.NET

  • Re: Newbie GridView problem

    03-03-2008, 9:44 AM
    • Member
      16 point Member
    • illmo76
    • Member since 01-30-2008, 11:21 AM
    • Posts 52

    ecbruck...that was it! I think this is the 3rd time you've helped me out! Thanks! Smile
Page 1 of 1 (3 items)
RSS Available

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.