Re: Newbie GridView problem

illmo76 — Mon, 03 Mar 2008 14:44:54 GMT

ecbruck...that was it! I think this is the 3rd time you've helped me out! Thanks!

Re: Newbie GridView problem

ecbruck — Mon, 03 Mar 2008 14:37:06 GMT

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.

Newbie GridView problem

illmo76 — Mon, 03 Mar 2008 14:28:03 GMT

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

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

Data Presentation Controls

Re: Newbie GridView problem

Re: Newbie GridView problem

Newbie GridView problem