gridview not waiting for user to hit go

mattcushing

I have three dropdowns, one is populated, the other two I'm just putting in values myself (facility, year, month). I have a gridview running a stored procedure that is waiting for values from the dropdowns so it can populate the grid.

I'd like to wait to populate the grid until the user selects values and hits go, but for some reason, it's just populating automatically. I tried putting in a "Please Select" in one of them, but then it complains that my input value is not right.

All three dropdowns are autopostback = false (advice from someone else).

Is there a property in the gridview I need to set?
here's the gridview code

Expand|Select|Wrap|Line Numbers

 
<asp:GridView ID="gv_cust1" runat="server" AutoGenerateColumns="False" DataSourceID="udsp_SCCust1" CellPadding="4" ForeColor="#333333" GridLines="None">

                        <Columns>

                            <asp:BoundField DataField="Measure1" HeaderText="Measure1" ReadOnly="True" SortExpression="Measure1" />

                            <asp:BoundField DataField="Measure2" HeaderText="Measure2" ReadOnly="True" SortExpression="Measure2" />

                            <asp:BoundField DataField="Score" HeaderText="Score" ReadOnly="True" SortExpression="Score" />

                        </Columns>

                        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <RowStyle BackColor="#EFF3FB" />

                        <EditRowStyle BackColor="#2461BF" />

                        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />

                        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />

                        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <AlternatingRowStyle BackColor="White" />

                    </asp:GridView>

here's the sql that it runs

Expand|Select|Wrap|Line Numbers

 <asp:SqlDataSource ID="udsp_SCCust1" runat="server" ConnectionString="<%$ ConnectionStrings:Cypress_APPConnectionString %>"

                        SelectCommand="udsp_ScorecardQuarterly" SelectCommandType="StoredProcedure">

                        <SelectParameters>

                            <asp:ControlParameter ControlID="ddlQuarter" Name="qtr" PropertyName="SelectedValue"

                                Type="Int32" />

                            <asp:ControlParameter ControlID="ddlYear" Name="year" PropertyName="SelectedValue"

                                Type="Int32" />

                            <asp:ControlParameter ControlID="ddlFacility" Name="entID" PropertyName="SelectedValue"

                                Type="Int32" />

                        </SelectParameters>

                    </asp:SqlDataSource>

Any ideas?

nateraaaa

Quote:

Originally Posted by mattcushing

I have three dropdowns, one is populated, the other two I'm just putting in values myself (facility, year, month). I have a gridview running a stored procedure that is waiting for values from the dropdowns so it can populate the grid.

I'd like to wait to populate the grid until the user selects values and hits go, but for some reason, it's just populating automatically. I tried putting in a "Please Select" in one of them, but then it complains that my input value is not right.

All three dropdowns are autopostback = false (advice from someone else).

Is there a property in the gridview I need to set?
here's the gridview code

Expand|Select|Wrap|Line Numbers

 
<asp:GridView ID="gv_cust1" runat="server" AutoGenerateColumns="False" DataSourceID="udsp_SCCust1" CellPadding="4" ForeColor="#333333" GridLines="None">

                        <Columns>

                            <asp:BoundField DataField="Measure1" HeaderText="Measure1" ReadOnly="True" SortExpression="Measure1" />

                            <asp:BoundField DataField="Measure2" HeaderText="Measure2" ReadOnly="True" SortExpression="Measure2" />

                            <asp:BoundField DataField="Score" HeaderText="Score" ReadOnly="True" SortExpression="Score" />

                        </Columns>

                        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <RowStyle BackColor="#EFF3FB" />

                        <EditRowStyle BackColor="#2461BF" />

                        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />

                        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />

                        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <AlternatingRowStyle BackColor="White" />

                    </asp:GridView>

here's the sql that it runs

Expand|Select|Wrap|Line Numbers

 <asp:SqlDataSource ID="udsp_SCCust1" runat="server" ConnectionString="<%$ ConnectionStrings:Cypress_APPConnectionString %>"

                        SelectCommand="udsp_ScorecardQuarterly" SelectCommandType="StoredProcedure">

                        <SelectParameters>

                            <asp:ControlParameter ControlID="ddlQuarter" Name="qtr" PropertyName="SelectedValue"

                                Type="Int32" />

                            <asp:ControlParameter ControlID="ddlYear" Name="year" PropertyName="SelectedValue"

                                Type="Int32" />

                            <asp:ControlParameter ControlID="ddlFacility" Name="entID" PropertyName="SelectedValue"

                                Type="Int32" />

                        </SelectParameters>

                    </asp:SqlDataSource>

Any ideas?

Where is the datasource assigned for this gridview? If it is in the Page_Load event that may be the problem. If you want your grid to populate on a button click or postback from a drop down list you will need to assign you datasource and databind calls in those methods, NOT in the Page_Load. Let us know if this works.

Nathan

prabunewindia

hi friend,
make the populated dropdown list's autopostback as true
and code ur fill grid code in dropdown selected index changed event
Prabu

Quote:

Originally Posted by mattcushing

I have three dropdowns, one is populated, the other two I'm just putting in values myself (facility, year, month). I have a gridview running a stored procedure that is waiting for values from the dropdowns so it can populate the grid.

I'd like to wait to populate the grid until the user selects values and hits go, but for some reason, it's just populating automatically. I tried putting in a "Please Select" in one of them, but then it complains that my input value is not right.

All three dropdowns are autopostback = false (advice from someone else).

Is there a property in the gridview I need to set?
here's the gridview code

Expand|Select|Wrap|Line Numbers

 
<asp:GridView ID="gv_cust1" runat="server" AutoGenerateColumns="False" DataSourceID="udsp_SCCust1" CellPadding="4" ForeColor="#333333" GridLines="None">

                        <Columns>

                            <asp:BoundField DataField="Measure1" HeaderText="Measure1" ReadOnly="True" SortExpression="Measure1" />

                            <asp:BoundField DataField="Measure2" HeaderText="Measure2" ReadOnly="True" SortExpression="Measure2" />

                            <asp:BoundField DataField="Score" HeaderText="Score" ReadOnly="True" SortExpression="Score" />

                        </Columns>

                        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <RowStyle BackColor="#EFF3FB" />

                        <EditRowStyle BackColor="#2461BF" />

                        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />

                        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />

                        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />

                        <AlternatingRowStyle BackColor="White" />

                    </asp:GridView>

here's the sql that it runs

Expand|Select|Wrap|Line Numbers

 <asp:SqlDataSource ID="udsp_SCCust1" runat="server" ConnectionString="<%$ ConnectionStrings:Cypress_APPConnectionString %>"

                        SelectCommand="udsp_ScorecardQuarterly" SelectCommandType="StoredProcedure">

                        <SelectParameters>

                            <asp:ControlParameter ControlID="ddlQuarter" Name="qtr" PropertyName="SelectedValue"

                                Type="Int32" />

                            <asp:ControlParameter ControlID="ddlYear" Name="year" PropertyName="SelectedValue"

                                Type="Int32" />

                            <asp:ControlParameter ControlID="ddlFacility" Name="entID" PropertyName="SelectedValue"

                                Type="Int32" />

                        </SelectParameters>

                    </asp:SqlDataSource>

Any ideas?

gridview not waiting for user to hit go

re: gridview not waiting for user to hit go

re: gridview not waiting for user to hit go

Similar .NET Framework bytes

/bytes/development

/bytes/it

/bytes/about