CODEWITHSUNDEEP
c#asp.netgridviewlinq-to-sql
Djama
Djama

Reputation: 791

Data filtering on gridview-want to show ALL records by default

Here is my GridView and LinqDataSource

<div id="container">

     <asp:GridView ID="dgvClients" runat="server" OnSelectedIndexChanged="dgvClients_SelectedIndexChanged"
         CssClass="table table-hover table-striped table-condensed" GridLines="None"
         ShowHeaderWhenEmpty="True"
         AutoGenerateColumns="False" AllowPaging="True" DataSourceID="LinqDataSourceClient">
         <Columns>
             <asp:BoundField DataField="accno" HeaderText="Acc No" ReadOnly="True" SortExpression="accno"></asp:BoundField>
             <asp:BoundField DataField="clientname" HeaderText="Client name" ReadOnly="True" SortExpression="clientname"></asp:BoundField>
             <asp:TemplateField HeaderText="Branch" SortExpression="t_branch.branch" >
                 <ItemTemplate>
                     <%# Eval("t_branch.branch")%>
                 </ItemTemplate>
             </asp:TemplateField>
             <asp:BoundField DataField="active" HeaderText="Active" ReadOnly="True" SortExpression="active"></asp:BoundField>
             <asp:BoundField DataField="lastupdated" HeaderText="Last Updated" ReadOnly="True" SortExpression="lastupdated"></asp:BoundField>
         </Columns>
         <Columns>
         </Columns>
         <PagerStyle CssClass="pagination" />
     </asp:GridView>
     <asp:LinqDataSource runat="server" EntityTypeName="" ID="LinqDataSourceClient" ContextTypeName="mcollector.mcollectorDataContext" OrderBy="accno, clientname, branchid" Select="new (accno, clientname, branchid, active, lastupdated, t_branch)" TableName="t_Clients" Where="accno == @accno">
         <WhereParameters>
             <asp:ControlParameter ControlID="TextBoxSearch" PropertyName="Text" DefaultValue="" Name="accno" Type="String"></asp:ControlParameter>
         </WhereParameters>
     </asp:LinqDataSource>
 </div>

i have a textbox , when it is empty i want to display all records from the table. How can i do that ?

Upvotes: 0

Views: 750

Answers (1)

Pleun
Pleun

Reputation: 8920

You could code your logic in the LinqDataSource.Selecting Event

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.linqdatasource.selecting(v=vs.110).aspx

Upvotes: 1

Related Questions