show only filter record data in asp.net

Accepted answer

Lan Huang-MSFT 28,666 Microsoft Vendor

You can try to use Yet Another DataTables Column Filter - (yadcf) - (yadcf), which provides one feature: cumulative filtering.

https://github.com/vedmack/yadcf?tab=readme-ov-file

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
    <link href="https://nightly.datatables.net/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />
     <link href="https://cdnjs.cloudflare.com/ajax/libs/yadcf/0.9.4-beta.13/jquery.dataTables.yadcf.css" rel="stylesheet" type="text/css" />
    <script src="https://nightly.datatables.net/js/jquery.dataTables.js"></script>
    <!-- Select2 plugin -->
    <link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/css/select2.min.css" />
    <!-- Select2 plugin -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/js/select2.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/yadcf/0.9.4-beta.13/jquery.dataTables.yadcf.min.js"></script>
    <script>
        $(document).ready(function () {
            var oTable;
            oTable = $('#list').DataTable();
            yadcf.init(oTable,
                [
                    {
                        column_number: 1,
                        filter_type: "multi_select",
                        select_type: 'select2',
                        cumulative_filtering: false
                    },
                    {
                        column_number: 2,
                        filter_type: "multi_select",
                        select_type: 'select2'
                    },
                    {
                        column_number: 3,
                        filter_type: "multi_select",
                        select_type: 'select2',
                    }
                ],
                {
                    cumulative_filtering: true
                }
            );
        });
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <div id="c1" runat="server">
                <table cellspacing="0" class="myClass" id="list" style="width: 1400px; font-family: Calibri; font-size: 11px; border-collapse: collapse; border: 1px solid black; z-index: 102;">
                    <thead>
                        <tr>
                            <th style="width: 60px; text-align: center;">F1</th>
                            <th style="width: 110px; text-align: center;">F2</th>
                            <th style="width: 150px; text-align: center;">F3</th>
                            <th style="width: 40px; text-align: center;">F4</th>
                            <th style="width: 40px; text-align: center;">F5</th>
                        </tr>
                    </thead>
                    <tbody style="border-collapse: collapse; border: 1px solid black;">
                        <asp:Repeater ID="Repeater1" runat="server">
                            <ItemTemplate>
                                <tr onmouseover="this.style.backgroundColor='#DFE7E5'" onmouseout="this.style.backgroundColor=''">
                                    <td style="text-align: center; border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F1")%></td>
                                    <td style="text-align: center; border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F2")%></td>
                                    <td style="text-align: center; border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F3")%></td>
                                    <td style="text-align: right; border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F4")%></td>
                                    <td style="text-align: right; border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F5")%></td>
                                </tr>
                            </ItemTemplate>
                        </asp:Repeater>
                    </tbody>
                    <tfoot>
                        <tr>
                            <td style="background: sandybrown; border: 1px solid black;"></td>
                            <td style="background: sandybrown; border: 1px solid black;"></td>
                            <td style="text-align: right; border-collapse: collapse; background: sandybrown; border: 1px solid black; font-size: larger; font-weight: bold; font-size: 20px;"></td>
                            <td style="text-align: right; border-collapse: collapse; background: sandybrown; border: 1px solid black; font-size: larger; font-weight: bold; font-size: 20px;"></td>
                            <td style="background: sandybrown; border: 1px solid black;"></td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </form>
</body>
</html>

User's image

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

RAVI 1,036 Reputation points

2024-06-27T06:57:51.97+00:00
Thank you for your code if i use this above code i need two things please last help

for example f4 column is interger value i want to show total of that column in footer and it should chage autotmtically when filters

when i click export to excel it should open in excel with perfect alginment and column total as well

Please please help me this two points your code works fine.
Lan Huang-MSFT 28,666 Reputation points Microsoft Vendor

2024-06-27T07:21:00.29+00:00

``*******

RAVI 1,036

i just want to export this repeater data in excel with perfect alignment with grand total i added this code not works

 $('#list').DataTable({
                "ordering": false,
                dom: 'Bfrtip',
                "buttons": [{
                    extend: 'excel',
                    footer: true,
                   // title: "Test",
                    title: "DETIALS",
                    className:'btn-success',
                    exportOptions: {
                       // columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16],
                        format: {
                            header: function (data, index, column) {
                                return thArray[index]
                            }
                        }
                    }
                }
                ],

Lan Huang-MSFT 28,666 Reputation points Microsoft Vendor

2024-06-27T07:35:09.4333333+00:00

Hi @RAVI,

Your question is not an answer, please do not post multiple answers, post a comment instead.

Lan Huang-MSFT 28,666 Microsoft Vendor

Hi @RAVI,

You only need to put the code that implements the relevant functions in your original code into the current code.

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
    <link href="https://nightly.datatables.net/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />
    <link href="https://cdnjs.cloudflare.com/ajax/libs/yadcf/0.9.4-beta.13/jquery.dataTables.yadcf.css" rel="stylesheet" type="text/css" />
    <script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.5.6/js/dataTables.buttons.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.flash.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.html5.min.js"></script>
    <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.print.min.js"></script>
    <!-- Select2 plugin -->
    <link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/css/select2.min.css" />
    <!-- Select2 plugin -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/js/select2.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/yadcf/0.9.4-beta.13/jquery.dataTables.yadcf.min.js"></script>
    <script>
        $(document).ready(function () {
            var thArray = [];
            $('#list > thead > tr > th').each(function () {
                thArray.push($(this).text())
            })
            var rowCount = $('table#list tbody tr').length;
            sessionStorage.setItem("rowCount", rowCount);
            var intVal = function (i) {
                return typeof i === 'string' ?
                    i.replace(/[\$,]/g, '') * 1 :
                    typeof i === 'number' ?
                        i : 0;
            };
            var oTable;
            oTable = $('#list').DataTable({
                "ordering": false,
                dom: 'Bfrtip',
                "buttons": [{
                    extend: 'excel',
                    footer: true,
                    // title: "Test",
                    title: "CHEMICAL ARRIVAL - ISSUE DETIALS",
                    className: 'btn-success',
                    exportOptions: {
                        // columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16],
                        format: {
                            header: function (data, index, column) {
                                return thArray[index]
                            }
                        }
                    }
                }
                ],
                lengthMenu: [
                    [2000, 1500, 1000, 500, -1],
                    [2000, 1500, 1000, 500, 'All'],
                ],
                footerCallback: function (tfoot, data, start, end, display) {
                    let api = this.api();
                    api.column(2).footer().innerHTML = "GRAND TOTAL";
                    // Total over all pages
                    total = api
                        .column(3, { search: 'applied' })
                        .data()
                        .reduce((a, b) => intVal(a) + intVal(b), 0);
                    // Update footer
                    api.column(3).footer().innerHTML = total.toFixed(0);
                }
            });
            yadcf.init(oTable,
                [
                    {
                        column_number: 1,
                        filter_type: "multi_select",
                        select_type: 'select2',
                        cumulative_filtering: false
                    },
                    {
                        column_number: 2,
                        filter_type: "multi_select",
                        select_type: 'select2'
                    },
                    {
                        column_number: 3,
                        filter_type: "multi_select",
                        select_type: 'select2',
                    }
                ],
                {
                    cumulative_filtering: true
                }
            );
        });
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <div id="c1" runat="server">
                <table cellspacing="0" class="myClass" id="list" style="width: 1400px; font-family: Calibri; font-size: 11px; border-collapse: collapse; border: 1px solid black; z-index: 102;">
                    <thead>
                        <tr>
                            <th style="width: 60px; text-align: center;">F1</th>
                            <th style="width: 110px; text-align: center;">F2</th>
                            <th style="width: 150px; text-align: center;">F3</th>
                            <th style="width: 40px; text-align: center;">F4</th>
                            <th style="width: 40px; text-align: center;">F5</th>
                        </tr>
                    </thead>
                    <tbody style="border-collapse: collapse; border: 1px solid black;">
                        <asp:Repeater ID="Repeater1" runat="server">
                            <ItemTemplate>
                                <tr onmouseover="this.style.backgroundColor='#DFE7E5'" onmouseout="this.style.backgroundColor=''">
                                    <td style="text-align: center; border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F1")%></td>
                                    <td style="text-align: center; border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F2")%></td>
                                    <td style="text-align: center; border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F3")%></td>
                                    <td style="text-align: right; border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F4")%></td>
                                    <td style="text-align: right; border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F5")%></td>
                                </tr>
                            </ItemTemplate>
                        </asp:Repeater>
                    </tbody>
                    <tfoot>
                        <tr>
                            <td style="background: sandybrown; border: 1px solid black;"></td>
                            <td style="background: sandybrown; border: 1px solid black;"></td>
                            <td style="text-align: right; border-collapse: collapse; background: sandybrown; border: 1px solid black; font-size: larger; font-weight: bold; font-size: 20px;"></td>
                            <td style="text-align: right; border-collapse: collapse; background: sandybrown; border: 1px solid black; font-size: larger; font-weight: bold; font-size: 20px;"></td>
                            <td style="background: sandybrown; border: 1px solid black;"></td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </form>
</body>
</html>

RAVI 1,036 Reputation points

2024-06-27T07:53:19.6766667+00:00

Thank You so Much @Lan Huang-MSFT

Thanks Again
RAVI 1,036 Reputation points

2024-06-27T07:56:50.56+00:00

Everythig fine i want one button clear if i click that button it will remove all fiter and back to normal how to do so without postback
RAVI 1,036 Reputation points

2024-06-27T08:03:33.1133333+00:00

Here One Problem

If i directly go to f3 column for fiter and i select im unable to select second value i want filter same like excel

here user will go any column filter f2,f3,f4 based on that multi filter next column data should be there
Lan Huang-MSFT 28,666 Reputation points Microsoft Vendor

2024-06-27T08:10:34.6566667+00:00

Hi @RAVI,

Please don't post multiple answers, post as a comment!

Please do not post multiple questions in one thread.
RAVI 1,036 Reputation points

2024-06-27T08:17:14.07+00:00

Here One Problem

If i directly go to f3 column for fiter and i select im unable to select second value i want filter same like excel

here user will go any column filter f2,f3,f4 based on that multi filter next column data should be there
Lan Huang-MSFT 28,666 Reputation points Microsoft Vendor

2024-06-27T08:21:54.1233333+00:00

Hi @RAVI,

Everythig fine i want one button clear if i click that button it will remove all fiter and back to normal how to do so without postback

The provided code already contains this functionality.

If i directly go to f3 column for fiter and i select im unable to select second value i want filter same like excel here user will go any column filter f2,f3,f4 based on that multi filter next column data should be thereYou can only implement one of these two functions. If you want to implement multiple filters, you need to set cumulative_filtering: false, but if you want to implement this (I want to only display W Z in the F3 filter), you need to set cumulative_filtering: true. These two are conflicting.
RAVI 1,036 Reputation points

2024-06-27T08:25:01.4266667+00:00

Simple

Once Page load user will go to any column and start doing filter on date it would be any f2,f3,f4 column based on column others columns should be shown in filter what user filter thanking you
Lan Huang-MSFT 28,666 Reputation points Microsoft Vendor

2024-06-27T08:35:41.1266667+00:00

deleted
RAVI 1,036 Reputation points

2024-06-27T08:40:40.16+00:00

Im really thank you for your help

ok i will explain what i need once page load it will show f2,f3,f4 column user will go to any column for multi search based on that search other column filter data should be shown not all data

For Example:- user go to F3 column now he want to select multiple options other f2 and f4 should show based on multi filrer data not all data in f2 and f4
Lan Huang-MSFT 28,666 Reputation points Microsoft Vendor

2024-06-27T08:44:16.3+00:00

Hi @RAVI,

I explained it.

You can only implement one of these two functions. If you want to implement multiple filters, you need to set cumulative_filtering: false, but if you want to implement this (I want to only display W Z in the F3 filter), you need to set cumulative_filtering: true. These two are conflicting.

If you insist, please find a more professional person:https://datatables.net/forums/

RAVI 1,036

Hello

This is my aspx page

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="A.aspx.cs" Inherits="Default3" %> 

<html>
<head runat="server">
<title>demo</title>
 <script src="https://code.jquery.com/jquery-1.11.3.min.js"></script>
    <link href="https://nightly.datatables.net/css/jquery.dataTables.css" rel="stylesheet" type="text/css" />
     <link href="https://cdnjs.cloudflare.com/ajax/libs/yadcf/0.9.4-beta.13/jquery.dataTables.yadcf.css" rel="stylesheet" type="text/css" />
    <script src="https://nightly.datatables.net/js/jquery.dataTables.js"></script>
    <!-- Select2 plugin -->
    <link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/css/select2.min.css" />
    <!-- Select2 plugin -->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/js/select2.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/yadcf/0.9.4-beta.13/jquery.dataTables.yadcf.min.js"></script>
    
 
    <script>
        $(document).ready(function () {
            var thArray = [];
            $('#list > thead > tr > th').each(function () {
                thArray.push($(this).text())
            })
            var rowCount = $('table#list tbody tr').length;
            sessionStorage.setItem("rowCount", rowCount);
            var intVal = function (i) {
                return typeof i === 'string' ?
                    i.replace(/[\$,]/g, '') * 1 :
                    typeof i === 'number' ?
                        i : 0;
            };
            var oTable;
            oTable = $('#list').DataTable({
                "ordering": false,
                dom: 'Bfrtip',
                "buttons": [{
                    extend: 'excel',
                    footer: true,
                    // title: "Test",
                    title: "DATA",
                    className: 'btn-success',
                    exportOptions: {
                        // columns: [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16],
                        format: {
                            header: function (data, index, column) {
                                return thArray[index]
                            }
                        }
                    }
                }
                ],
                lengthMenu: [
                    [2000, 1500, 1000, 500, -1],
                    [2000, 1500, 1000, 500, 'All'],
                ],
                footerCallback: function (tfoot, data, start, end, display) {
                    let api = this.api();
                    api.column(3).footer().innerHTML = "GRAND TOTAL";
                    // Total over all pages
                    total = api
                        .column(4, { search: 'applied' })
                        .data()
                        .reduce((a, b) => intVal(a) + intVal(b), 0);
                    // Update footer
                    api.column(4).footer().innerHTML = total.toFixed(0);
                }
            });
            yadcf.init(oTable,
                [
                    {
                        column_number: 1,
                        filter_type: "multi_select",
                        select_type: 'select2' 
                           
                         
                    },
                    {
                        column_number: 2,
                        filter_type: "multi_select",
                        select_type: 'select2',
                        
                         
                         
                    },
                    {
                        column_number: 3,
                        filter_type: "multi_select",
                        select_type: 'select2',
                        
                        
                    }
                ],
                {
                     
                }
            );
        });
    </script>
 
 
 <style>

    .btn-success {
            width: 110px;
            height: 40px;
            background-image: url('images/excelnew.png');
            background-repeat: no-repeat;
            background-size: cover;
            position: relative;
            left:682px; 
            top: -34px;
            display: block;
            text-indent: -9999em;
        }
        
        .select2-results__options[aria-multiselectable="true"] li {
            padding-left: 30px;
            position: relative;           
        }
            .select2-results__options[aria-multiselectable="true"] li:before {
                position: absolute;
                left: 8px;
                opacity: .6;
                top: 6px;
                font-family: "FontAwesome";
                content: "\f0c8";
            }
            .select2-results__options[aria-multiselectable="true"] li[aria-selected="true"]:before {
                content: "\f14a";
            }
            
            table {
     margin: 0 auto;
     margin-top: 20px;
     width: 100%;
     position: relative;
     overflow: auto;
 }
 th, thead {
     position: sticky;
     top: 0;
     border: 1px solid #dddddd;
     background-color: #ABEBC6;
     text-align: center;
     table-layout: fixed;
    
     height: 25px;
 }
    </style>
     

</head>
<body>
    <form id="form1" runat="server">
    <div>
       <div id="c1" runat="server">
        <table cellspacing="0" class="myClass" id="list" style="width: 600px; font-family: Calibri; font-size: 11px; border-collapse: collapse; border: 1px solid black; z-index: 102;">
            <thead>
                <tr>
                
                  <th style="width:60px;text-align:center;">F1</th>
                    <th style="width:110px;text-align:center;">F2</th>
                    <th style="width:150px;text-align:center;">F3</th> 
                    <th style="width:40px;text-align:center;">F4</th>
                    <th style="width:40px;text-align:center;">F5</th>
                     
                    
                </tr>
            </thead>
            <tbody style="border-collapse: collapse; border: 1px solid black;">
                <asp:Repeater ID="Repeater1" runat="server">
                    <ItemTemplate>
                        <tr onmouseover="this.style.backgroundColor='#DFE7E5'" onmouseout="this.style.backgroundColor=''">
                           
                         <td style="text-align:center;border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F1")%></td>
                           
                            <td style="text-align:center;border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F2")%></td>
                            <td style="text-align:center;border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F3")%></td>
                          
                            <td style="text-align:right;border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F4")%></td>
                              <td style="text-align:right;border-collapse: collapse; border: 1px solid black; font-size: larger;"><%#Eval("F5")%></td> 
                                        
                        
                        </tr>
                    </ItemTemplate>
                </asp:Repeater>
            </tbody>
            <tfoot>
                <tr>
                                
             <td style="background: sandybrown; border: 1px solid black;"></td> 
                             
             <td style="background: sandybrown; border: 1px solid black;"></td>
                         
             <td style="text-align:right;border-collapse: collapse; background: sandybrown; border: 1px solid black; font-size: larger; font-weight: bold;font-size:20px;"></td>
                         
             <td style="text-align:right;border-collapse: collapse; background: sandybrown; border: 1px solid black; font-size: larger; font-weight: bold;font-size:20px;"></td> 
             
              
              
               <td style="background: sandybrown; border: 1px solid black;"></td>            
                          
               </tr>
            </tfoot>
        </table>
    </div>
    </div>
    </form>
</body>
</html>

This is code beind

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections.Specialized;
using System.Text;
using System.Drawing;
using System.IO;
using System.Net;
using System.Net.Mail;
using System.Net.Configuration;
public partial class Default3 : System.Web.UI.Page
{

    

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {


            DataTable dt = new DataTable();
            SqlConnection con1 = new SqlConnection(ConfigurationManager.ConnectionStrings["CHEMIMSConnectionString"].ConnectionString);
            con1.Open();
            SqlCommand cmd1 = new SqlCommand("select * from Table1", con1);
            SqlDataAdapter ada1 = new SqlDataAdapter(cmd1);
            ada1.Fill(dt);
            con1.Close();
            con1.Dispose();
            Repeater1.DataSource = dt;
            Repeater1.DataBind();


        }

    }
    
    
}

This is MS SQL Data

USE [STAR]
GO
/****** Object:  Table [dbo].[Table1]    Script Date: 06/27/2024 14:33:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Table1](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[F1] [varchar](50) NULL,
	[F2] [varchar](50) NULL,
	[F3] [varchar](50) NULL,
	[F4] [varchar](50) NULL,
	[F5] [varchar](50) NULL,
 CONSTRAINT [PK_Table1_1] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[Table1] ON
INSERT [dbo].[Table1] ([ID], [F1], [F2], [F3], [F4], [F5]) VALUES (1, N'AA', N'A', N'AAA', N'AAAA', N'5')
INSERT [dbo].[Table1] ([ID], [F1], [F2], [F3], [F4], [F5]) VALUES (2, N'BB', N'B', N'BBB', N'BBBB', N'10')
INSERT [dbo].[Table1] ([ID], [F1], [F2], [F3], [F4], [F5]) VALUES (3, N'CC', N'C', N'CCC', N'CCCC', N'15')
INSERT [dbo].[Table1] ([ID], [F1], [F2], [F3], [F4], [F5]) VALUES (4, N'DD', N'D', N'DDD', N'DDDD', N'20')
INSERT [dbo].[Table1] ([ID], [F1], [F2], [F3], [F4], [F5]) VALUES (30, N'EE', N'E', N'EEE', N'EEEE', N'25')
INSERT [dbo].[Table1] ([ID], [F1], [F2], [F3], [F4], [F5]) VALUES (31, N'FF', N'F', N'FFF', N'FFFF', N'30')
SET IDENTITY_INSERT [dbo].[Table1] OFF

Here I will explain step by step and i have you will understand me clear

on load of page i have F1,F2,F3,F4,F5 Columns I have applied Multi Search for only f2,f3,f4 till this clear.

Next here user will do multi filter on any column may be he goes first f2 or f3 or f4 as per his choice what ever he filter what ever data comes that data should be in filter as well

For example if user select in f3 In AAA,BBB then in f4 it should show AAAA,BBBB and f2 A,B
For example if user select in f2 as C,E then in f3 it should show CCC,EEE and f4 CCCC,EEEE
**For example if user select in f4 as AAAA,EEEE then in f3 it should show AAAA,EEE and f2 A,E

hope this clear**

RAVI 1,036 Reputation points

2024-06-28T09:29:20.4266667+00:00

hello

i have posted this as u said in thta forum please check

https://datatables.net/forums/discussion/79284/show-only-filter-record-data-another-filter-like-excel/p1?new=1

i need help tosolve this

thanks

Share via

show only filter record data in asp.net

0 additional answers