Jquery Datatable already provides individual column filters. However, we can leverage that to create our custom filter that works similar to Excel filter.

HTML

Javascript

jQuery

Dev

DataTable

JSON

Easily Apply Sorting for DataTables.js in C#

13 Oct 2018 by Stefan Vincent Haug

Helper method to apply sorting from DataTables.js parameters in C#

Javascript

.NET

DataTable

Accessing Value from System.Data.DataTable : Tip

27 Oct 2010 by Andrew Rissing

Technically, the best approach here for speed and flexibility is to do the following:public class TestClass{ private const string EMP_ID = "EmpId"; public void MyTestMethod() { //GetData fetches data from the database using a SQL query DataTable dt =...

DataTable

performance

Create Excel file from DataTable

4 Sep 2014 by ASP.NET Community

Here is a simplified class to create Excel file from DataTable just Pass DataTable and Preferred location on server to generate. Call the

MS-Excel

DataTable

file

Configurable Data Generator for GridView and DataTable

17 Nov 2013 by Hazem Torab

Generate reasonable sample data for you GridView without using databases.

Updating Auto-Numbered Primary Keys in a DataTable (MSAccess Databases)

3 Oct 2011 by Adam Covitch

It is common to configure back-end database tables to contain a column with an auto-generated ID unique to each row. This tip describes how to sync the ID generated by the database back to the application layer.

DataTable

MS-Access

Create job to export Stored Procedure daily

27 Nov 2012 by Aadhar Joshi

Creating job in sql server which automates taking backup of all stored procedures and functions in physical drive.

Distinct Raw Data Population in DataTable

15 Jun 2011 by leopard447

How to do distinct raw data population in a DataTable

DataTable

Generic LINQ Usage To Return Single Value From DataRow

15 Jul 2010 by Paul Brower

This tip will allow you to return the value from column X, where column Y matches your filter

LINQ

DataRow

DataTable

Accessing Value from System.Data.DataTable : Tip

27 Oct 2010 by A.J.Wegierski

int empId = dt.Columns[EMP_ID].Ordinal;...int empId = Convert.ToInt32(dRow[empId]);

DataTable

performance

Export Multidimensional Array to Excel with Formatting in C#

4 Oct 2012 by Santhosh Kumar Jayaraman

This is an alternative for "Export DataTable to Excel with Formatting in C#".

Convert EntityCollection to DataTable

26 Feb 2013 by Thakkar Amit

Code for converting the EntityCollection of a DataTable.

CRM

DataAdapter

DataTable

Save and Load a DataGrid's Columns Graphical Properties in WPF

3 Jan 2015 by Emiliano Musso

How to save DataGrid column's properties for further re-use

DataTable to List<> using Generics

4 Aug 2015 by Abdul Ahad Monty

Convert DataTable to List using Generics.

Automatic Numbering for the Primary Key Column

19 Dec 2013 by Shweta Lodha

Automatic numbering for the primary key column

DataTable

database

Print DataTable to Console (and more)

9 Nov 2017 by yuvalsol

Print DataTable, DataView, DataSet, DataRow[] to Console, StringBuilder or Stream

Chat / Conversation Balloon Control with datasource

15 Aug 2015 by IssaharNoam

Simple and customizable Chat Conversation control, with DataTable datasource, inspired by SMS application balloons in OnePlus One Android smartphone.

Nested GridView controls in ASP.NET: best practices

30 Oct 2011 by DrABELL

ASP.NET GridView control hosting another GridView in data-centric web applications

DataSet to T-SQL Script

17 Dec 2014 by Brad Joss

Export a System.Data.DataTable/DataSet into a T-SQL script that when run creates a #TEMP table of the same definition filled with data.

Customizing PDF Generated Using jQuery DataTables Plugin

25 Mar 2015 by Ramesh_Joshi

This tip shows how to customize PDF created with the jQuery DataTables plug-in.

Dynamically menu binding

29 Oct 2013 by ASP.NET Community

Hi friends..... Many of guys are trying or working on menus for binding it dynamically. i've the solution for ithere , i m putting sample code to

Hyperlinked Images in ASP.NET GridView

11 Feb 2015 by DrABELL

3 different techniques of adding hyperlinked image to ASP.NET GridView in data-centric RIA

Create Crystal Report Document Dynamically from List of Objects in Applications without Database

22 Apr 2012 by ashkanpower

How to create Crystal report document dynamically from a list of objects in applications without database

Visual-Studio

CrystalReports

DataTable

Split DataTable into Multiple DataTables C#

19 May 2019 by DiponRoy

The aim of this helper class is to divide a large datatable into multiple small datatables.

DataTable

splitter

DataTable.Select is Slow?

15 Aug 2014 by techcap

DataTable.Select performance test and how to improve it

DataTable

Combining DataTables with Different Schema

21 Nov 2017 by OriginalGriff

There is a problem with accessing Excel files via OleDb which contain more than 255 columns: they are truncated and need to be fetched using ranges. But what do you do with DataTables after that?

.NET

Dev

DataTable

HTML Table with Export, Sort, Filter and Paging

11 Jun 2016 by Er. Puneet Goel

Now export your table in Excel across all browsers and enable quick filter and paging

Data Entry Form made Easy, Enabled / Disabled controls on Data Entry Form

18 Sep 2010 by Tajwer Jalal

Data Entry Form made Easy, Enabled / Disabled controls on Data Entry Form

forms

DataTable

toolbar

DuplicateNameException when adding columns to a DataTable dynamically

24 Jun 2011 by David C. Williams

When building an ADO.NET DataTable dynamically in your code, each column name must be unique or you get a System.Data.DuplicateNameException. If you don't know at design time that the columns you will be adding are certain to have unique names, you can use this method to avoid a runtime error.

ADO.NET

ASP.NET

DataTable

Convert CSV file to XML with DataTable in Visual Basic

22 Jan 2015 by Emiliano Musso

A quick method to convert a CSV file in XML