ltaspGridView ID34gvsiswa34 runat34server34 AutoGenerateColumns34False34 CellPadding34434 ForeColor3433333334 GridLines34None34 FontSize34Small34 EmptyDataText34No Record Display34 CssClass34table34gt ltAlternatingRowStyle BackColor34White34 ForeColor3428477534 gt ltColumnsgt ltaspBoundField DataField34nik34 HeaderText34Nik34 gt ltaspTemplateField SortExpressio

Hi Ruben12345I have created sample code which fulfill your requirementHTMLltdivgt ltaspGridView ID34gvCustomers34 AutoGenerateColumns34true34 runat34server34 EmptyDataText34No Records Found34 OnDataBound34gvCustomersDataBound34 gt ltbr gt ltaspButton ID34Button134 Text34SHOW ALL34 OnClick34onclick34 runat34server34 gtltdivgtCstring constring ConfigurationManagerConnectionStrings34constr34ToStringint customerId 0string Namestring countryprotected void PageLoadobject sender EventArgs e thisGetDataprivate void GetData SqlConnection con new SqlConnectionconstring SqlCommand cmd new SqlCommand34SELECT from Customers34 con SqlDataAdapter sda new SqlDataAdaptercmd DataTable dt new DataTable sdaFilldt gvCustomersDataSource dt gvCustomersDataBindprotected void gvCustomersDataBoundobject

How to filter GridView Based on Dynamically Added Textboxes on first row position using C# and VB.Net in ASP.Net

Ruben123...

SOLVED CLOSED ACTIVE ANSWERED
User: Ruben12345
Posted: on Feb 03, 2017 06:10 AM
Forum: Data Controls
Answer: 1
Views: 11057

<asp:GridView ID="gv_siswa" runat="server" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None" Font-Size="Small" EmptyDataText="No Record Display" CssClass="table">
    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
     <Columns>
       <asp:BoundField DataField="nik" HeaderText="Nik" />
       <asp:TemplateField SortExpression="nik">
               <HeaderTemplate>
                   <asp:TextBox ID="txtnik" runat="server" placeholder="Filter Nik" AutoPostBack="true" Width="100px" OnTextChanged="txtnik_TextChanged"></asp:TextBox>
               </HeaderTemplate>
           </asp:TemplateField>     
       <asp:BoundField DataField="nama" HeaderText="Nama" />
           <asp:TemplateField>
               <HeaderTemplate>
                   <asp:TextBox ID="txtnama" runat="server" placeholder="Filter Nama" AutoPostBack="true" Width="100px"></asp:TextBox>
               </HeaderTemplate>
           </asp:TemplateField>                       
       <asp:BoundField DataField="fakultas" HeaderText="Fakultas" />  
           <asp:TemplateField>
               <HeaderTemplate>
                   <asp:TextBox ID="txtfakultas" runat="server" placeholder="Filter Fakultas" AutoPostBack="true" Width="100px"></asp:TextBox>
               </HeaderTemplate>
           </asp:TemplateField>                        
       <asp:BoundField DataField="jurusan" HeaderText="Jurusan" />
           <asp:TemplateField>
               <HeaderTemplate>
                   <asp:TextBox ID="txtjurusan" runat="server" placeholder="Filter Jurusan" AutoPostBack="true" Width="100px"></asp:TextBox>
               </HeaderTemplate>
           </asp:TemplateField>   
       <asp:BoundField DataField="nilai1" HeaderText="Nilai1" />
           <asp:TemplateField>
               <HeaderTemplate>
                   <asp:TextBox ID="txtnilai1" runat="server" placeholder="Filter Nilai1" AutoPostBack="true" Width="100px"></asp:TextBox>
               </HeaderTemplate>
           </asp:TemplateField>   
       <asp:BoundField DataField="nilai2" HeaderText="Nilai2" />
           <asp:TemplateField>
               <HeaderTemplate>
                   <asp:TextBox ID="txtnilai2" runat="server" placeholder="Filter Nilai2" AutoPostBack="true" Width="100px"></asp:TextBox>
               </HeaderTemplate>
           </asp:TemplateField>   
       <asp:BoundField DataField="nilai3" HeaderText="Nilai3" /> 
           <asp:TemplateField>
               <HeaderTemplate>
                   <asp:TextBox ID="txtnilai3" runat="server" placeholder="Filter Nilai3" AutoPostBack="true" Width="100px"></asp:TextBox>
               </HeaderTemplate>
           </asp:TemplateField>

Download FREE API for Word, Excel and PDF in ASP.Net

Ruben123...

0 3

Reply
User: Ruben12345
Replied: on Feb 11, 2017 04:52 AM
Report

Hi .. I Think just add for filter expresion in my code below, i added one textbox as control

Protected Sub OnDataBound(sender As Object, e As EventArgs)
        Dim row As New GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal)
        For i As Integer = 0 To gv_siswa.Columns.Count - 1
            Dim cell As New TableHeaderCell()
            Dim txtsearch As New TextBox()
            txtsearch.Attributes("Placeholder") = gv_siswa.Columns(i).HeaderText
            txtsearch.CssClass = "textbox"
            cell.Controls.Add(txtsearch)
            row.Controls.Add(cell)
        Next
        gv_siswa.HeaderRow.Parent.Controls.AddAt(1, row)
    End Sub

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to filter GridView Based on Dynamically Added Textboxes on first row position using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us