Solved

How to prevent a Gridview to display on page_load

Posted on 2009-05-08
4
267 Views
Last Modified: 2012-05-06
I have a Gridview that is displayed directly when you enter the page.

I want it to show first when I submit a button.....

I've tried to set it to Visible="false" and to "True" when I submit the button but this is'nt a good solution.
<asp:GridView ID="GridView2" Visible="false" DataKeyNames="EventId,AttendeeID" Width="700px" 

                        runat="server" AllowPaging="True" PageSize="30" AutoGenerateColumns="False" 

                        DataSourceID="SqlDataSource1" AllowSorting="True">

                        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />

                        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />

                <Columns>

                    <asp:BoundField DataField="Fname" HeaderText="First Name" SortExpression="Fname" 

                    ItemStyle-Width="150px" >

                    </asp:BoundField>

                    <asp:BoundField DataField="Lname" HeaderText="Last Name" SortExpression="Lname" 

                    ItemStyle-Width="150px" >

                    </asp:BoundField>

                    <asp:BoundField DataField="EMail" HeaderText="e-mail" SortExpression="EMail" 

                    ItemStyle-Width="200px" >

                    </asp:BoundField>

                    <asp:BoundField DataField="RegDate" HeaderText="Registered (UTC)" 

                        SortExpression="RegDate" ItemStyle-Width="150px" >
 

                    </asp:BoundField>

                    

                    <asp:TemplateField ShowHeader="false" ItemStyle-Width="25">

                        <ItemTemplate>

                            <asp:HyperLink ID="myHyperLink" runat="server" NavigateUrl='<%# Eval("AttendeeID", "..\PAGES\AdminEditReg.aspx?atid={0}")%>' ImageUrl="..\..\images\edit.gif" />

                        </ItemTemplate>

                    

                    </asp:TemplateField>

                    <asp:TemplateField ShowHeader="false" ItemStyle-Width="25">

                        <ItemTemplate>

                            <asp:ImageButton ID="button" runat="server" CausesValidation="false" CommandName="Delete" 

                            OnClientClick='return confirm("Are you sure you want to delete?");' ImageUrl="..\..\images\delete.gif" /> 

                        </ItemTemplate>
 

                    </asp:TemplateField>

                </Columns>     

            </asp:GridView>

                </td>

            </tr>

         </table>   

      

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

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

            

             SelectCommand="SELECT * FROM [Attendees] WHERE ([EventId] = @EventId)" FilterExpression="Fname like '%{0}%'

                or Lname like '%{1}%' or EMail like '%{2}%' " 

             

             DeleteCommand="DELETE FROM [Attendees] WHERE [AttendeeID] = @AttendeeID">

             

                <DeleteParameters> 

                    <asp:Parameter Name="AttendeeID" Type="Int32" />

                </DeleteParameters>

                <SelectParameters>

                    <asp:SessionParameter Name="EventId" SessionField="RegEventId" 

                        Type="Int32" />

                </SelectParameters>

                <FilterParameters>

                    <asp:ControlParameter Name="Fname" ControlID="searchTextBox" 

                        PropertyName="Text" />

                    <asp:ControlParameter Name="Lname" ControlID="searchTextBox" 

                        PropertyName="Text" />

                    <asp:ControlParameter Name="EMail" ControlID="searchTextBox" 

                        PropertyName="Text" />    

                </FilterParameters>

            

        </asp:SqlDataSource>

Open in new window

0
Comment
Question by:mattegol
  • 2
  • 2
4 Comments
 
LVL 18

Expert Comment

by:David Robitaille
ID: 24336739
"I've tried to set it to Visible="false" and to "True" when I submit the button but this is'nt a good solution."
Why? it`s not working you have a philosophic objection against it?
0
 

Author Comment

by:mattegol
ID: 24337643
The user is only going to use the gridview sometimes and I don't wan't to get the database involved if I dont have to. If the gridview has lets say >3000 rows is slows the page down doesn't it?

Otherwise Visible="false" works fine for me...
0
 
LVL 18

Accepted Solution

by:
David Robitaille earned 500 total points
ID: 24337678
then just dont bind it (leave "DataSourceID" blank)
then, whan you set it to visible to true, set the DataSourceID and call databind
GridView2.visible=true
GridView2.DataSourceID ="SqlDataSource1"
GridView2.databind
 
0
 

Author Closing Comment

by:mattegol
ID: 31579343
Thank you, simple solution just like I like it
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now