limit what the gridview shows based on what is searched for

[lillyehrhart]

I have a gridview that is bound to a database. I also have fields where you can search for something and then it show up in the gridview based on what you searched for. ex, you can search for pro that starts with 123 and everything that starts with those numbers will come up. I also have a field called invoice number. however, i want to only allow it to show in the gridview if it is searched for. right now this is my code for the gridview.

<asp:GridView ID="GridView1" PageIndex="0" EnableSortingAndPagingCallbacks="True" CssClass="GridView" AllowPaging="false" PageSize="30" AllowSorting="true" OnSorting="gvFreightBills_Sorting" runat="server" CellPadding="1" CellSpacing="2" GridLines="Vertical" HorizontalAlign="Left" AutoGenerateColumns="false" RowStyle-Height="19" DataKeyNames="DATE_ENT,CARRIER,PRO">
 
 
                    <AlternatingRowStyle BackColor="#CCCCCC" />
                    <Columns>
                        <asp:CommandField ControlStyle-CssClass="GridViewSelectButton" HeaderStyle-Width="40" ItemStyle-Width="40" SelectText="Select" ShowSelectButton="true" ItemStyle-HorizontalAlign="center"></asp:CommandField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="SHIP_DATE" HeaderText="Ship Date" ControlStyle-Width="70" HeaderStyle-Width="70" ItemStyle-Width="70" SortExpression="tbl_Bills.[Date]" DataFormatString="{0:d}"></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="DATE_ENT" HeaderText="Date Ent." ControlStyle-Width="70" HeaderStyle-Width="70" ItemStyle-Width="70" SortExpression="tbl_Bills.[DATE ENT]" DataFormatString="{0:d}"></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="CARRIER" HeaderText="Carrier" ReadOnly="True" SortExpression="CARRIER" HeaderStyle-Width="50" ItemStyle-Width="50"></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="PRO" HeaderText="PRO" ControlStyle-Width="105" HeaderStyle-Width="105" ReadOnly="True" SortExpression="PRO"></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="spec_fedinv" HeaderText="Invoice No" SortExpression="tbl_bills.[spec_fedinv]"></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="SHIPPER" HeaderText="Shipper" ControlStyle-Width="50" HeaderStyle-Width="70" ItemStyle-Width="70" SortExpression="SHIPPER" ></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="CONS" HeaderText="Consignee" SortExpression="CONS" ControlStyle-Width="70" HeaderStyle-Width="70" ItemStyle-Width="70"></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="F_B" HeaderText="BOL No" SortExpression="F_B"></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="LOC" HeaderText="Loc" SortExpression="LOC"></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="PCS" HeaderText="PCS" SortExpression="PCS" ControlStyle-Width="30" HeaderStyle-Width="30" ItemStyle-Width="30"></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="WT" HeaderText="WT" SortExpression="WT" ControlStyle-Width="30" HeaderStyle-Width="30" ItemStyle-Width="30"></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="NET_CHGS" HeaderText="NET Chgs." ControlStyle-Width="60" HeaderStyle-Width="60" ItemStyle-Width="60" SortExpression="NET_CHGS" DataFormatString="{0:$0.00}"></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="DATE_PAID" HeaderText="Date Paid" ControlStyle-Width="70" HeaderStyle-Width="70" ItemStyle-Width="70" SortExpression="tbl_Bills.[DATE PAID]" DataFormatString="{0:d}"></asp:BoundField>
                        <asp:BoundField ItemStyle-CssClass="GVCol" DataField="CK_NO" HeaderText="CK No." SortExpression="tbl_Bills.[CK NO]"></asp:BoundField>
                    </Columns>
                    <FooterStyle BackColor="#CCCCCC" />
                    <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
                    <RowStyle Height="19px"></RowStyle>
                    <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
                </asp:GridView>

this is what i have for my textboxes

<div class="Spacer5"></div>
            <div class="Dotted40"></div>
            <div class="Spacer5"></div>
 
                <div class="divFBQueryLineItemWrapper">
                    <div class="divFBQueryLeftColumn">
                        Pro: 
                    </div>
                    <div class="divFBQueryRightColumn">
                        <asp:TextBox ID="tbProNumber" Width="115px" runat="server"></asp:TextBox>
 
                    </div>
                    <div style="clear: both"></div>
                </div>
 
 
                <div class="Spacer5"></div>
                <div class="divFBQueryLineItemWrapper">
                    <div class="divFBQueryLeftColumn">
                        Invoice No: 
                    </div>
                    <div class="divFBQueryRightColumn">
                        <asp:TextBox ID="tbInvoiceNo" Width="115px" runat="server"></asp:TextBox>
 
                    </div>
                    <div style="clear: both"></div>
                </div>
 
                <div class="Spacer5"></div>
                <div class="divFBQueryLineItemWrapper">
                    <div class="divFBQueryLeftColumn">
                        Bill of Lading: 
                    </div>
                    <div class="divFBQueryRightColumn">
                        <asp:TextBox ID="tbBillOfLadingNumber" Width="115px" runat="server"></asp:TextBox>
 
                    </div>
                    <div style="clear: both"></div>

i also have a search button. I think that i would put something in my search button click event that says if tbinvoice is blank then do not show the row for invoice in the gridview, else show it. but how i would i code that? please help!

[lillyehrhart]

nevermind i figured it out.

[Rabbit]

Could you post your solution in case someone runs into the same issue?

[lillyehrhart]

here is my solution

If tbInvoiceNo.Text = "" Then
            GridView1.Columns(5).Visible = False
        Else
            GridView1.Columns(5).Visible = True
        End If