DataTable

Great Reads

A generic Collection to DataTable Mapper

by Jörgen Andersson

A high performance extension for creating a DataTable from a Generic collection.

Abstract Nonsense in Software Development. Databases

by Petr Ivankov

Application of abstract approach to database domain

Accessing Value from System.Data.DataTable : Tip

by TweakBird

Accessing Value from System.Data.DataTable

Accessing Value from System.Data.DataTable : Tip

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 =...

Latest Articles

A generic Collection to DataTable Mapper

by Jörgen Andersson

A high performance extension for creating a DataTable from a Generic collection.

Abstract Nonsense in Software Development. Databases

by Petr Ivankov

Application of abstract approach to database domain

Accessing Value from System.Data.DataTable : Tip

by TweakBird

Accessing Value from System.Data.DataTable

Accessing Value from System.Data.DataTable : Tip

by Andrew Rissing

All Articles

top

DataTable

A generic Collection to DataTable Mapper

by Jörgen Andersson

A high performance extension for creating a DataTable from a Generic collection.

Abstract Nonsense in Software Development. Databases

by Petr Ivankov

Application of abstract approach to database domain

Add Responsive Behaviour to a GridView in ASP.NET

by Declan Bright

A technique which ensures that an ASP.NET GridView displays nicely on small screen devices.

Advanced WPF TreeViews in C#/VB.Net Part 4 of n

by Dirk Bahle

Tips & Tricks on loading and saving WPF Tree View based content.

ASP.NET MVC Editable Table (jQuery DataTables and ASP.NET MVC integration - Part II)

by Jovan Popovic(MSFT)

Create datatable with standard CRUD functionalites in ASP.NET MVC using the jQuery DataTables Editable plug-in

Beginners Guide for Creating GridView in ASP.NET MVC 5

by Ehsan Sajjad

A guide on how to implement gridview in ASP.NET MVC 5

C#.NET – Removing Duplicate Records From DataTable

by Noor Ahmad Feroozi

A function to remove and select unique records from a DataTable in C#.NET and return a clean and duplicate-free DataTable

Comparator - Data Sources Comparer

by Alex Pumpet

A simple program for comparing table data from two sources - SQL databases, Excel, CSV or XML-files

Conversion Between DataTable and List in C#

by DiponRoy

Conversion between DataTable and List in C#

Creating an Expandable Master-Details Table (jQuery DataTables and ASP.NET MVC Integration - Part IV)

by Jovan Popovic(MSFT)

Implement an expandable master-details table in ASP.NET MVC using jQuery DataTables plug-in

CSV/Excel File Parser - A Revisit

by #realJSOP

An example of evolving code to fit new demands

Custom DataGridView for Data Management

by haisol

Custom DataGridView for managing data

Data Dictionary in C#.NET

by Mehedi Shams

Create a data dictionary for your database tables

Dynamically Map SQL Resultset to Business Object

by Sam Lombardo

Dynamically map a DataTable to type-safe business objects using reflection and generics

Editable (CRUD) Web Tables in J2EE (jQuery Data Tables and J2EE Application Integration - Part II)

by Jovan Popovic(MSFT)

This article explains how you can implement full data management functionalites (adding, deleting, inline editing) into web tables using jQuery DataTables/Editable and J2EE applications.

Enhancing HTML tables using the jQuery DataTables plug-in

by Jovan Popovic(MSFT)

This article shows how to enhance a plain HTML table with the jQuery DataTables plug-in.

Export DataTable to Excel with Formatting in C#

by Santhosh Kumar Jayaraman

Export a DataTable to an Excel file and add format to the contents while writing the Excel file.

Grid View with AJAX based CRUD Operations in ASP.NET MVC 5

by Ehsan Sajjad

In this post, I will be addressing this problem and we will learn that how can implement CRUD using JQuery DataTables in one page without any full page reloads.

GridviewFix jQuery plugin

by Rupesh Kumar Tiwari

GridviewFix is a helper jQuery plugin that solves the compatibility problem in between .NET Gridview and dataTable plugin.

In Search of the Ultimate DataTable Serializer

by Massimo Fabiano

I know that "returning DataSets from WebServices is the spawn of Satan" but...

Integrate DataTables into Java Web Application (Datatables and Java)

by Tuan Xuan Bui

Integrate DataTables into a Java web application, render DataTable on demand, simple to use and flexible to work with.

jQuery DataTable Integration - Dynamic Columns and Records

by Proneetkumar Pradeep Ray

JQuery Datatable (Dynamic columns) populate after Ajax JSON response via server side processing - Using EF Raw SQL query

jQuery DataTable Integration with Server Side Processing Using Dynamic LINQ

by Proneetkumar Pradeep Ray

Easy way to integrate jQuery DataTable Server Side processing using Dynamic LINQ | Server Side processing using extension method

jQuery DataTables Advanced Filtering in ASP.NET MVC (jQuery DataTables and ASP.NET MVC Integration - Part V)

by Jovan Popovic(MSFT)

How to implement advanced column filtering using jQuery DataTables

jQuery DataTables and ASP.NET MVC Integration - Part I

by Jovan Popovic(MSFT)

Code samples that explain how the jQuery DataTables plug-in can be integrated into ASP.NET MVC applications

jQuery DataTables in Java Web Applications

by Jovan Popovic(MSFT)

Enhancing simple tables implemented in Java web applications using the jQuery DataTables plug-in

jQuery Datatables Wrapper

by Vitalii Novotarskyi

To simplify working with jQuery Datatables.

LINQ to DataSets

by ASP.NET Community

IntroductionLINQ is one of the new entrants in C# 3.0, introduced as part of .NET 3.5. As you are already aware, LINQ is a unified querying

MP3 Rearrange

by John Orendt

Prepares play list elements for burning to CD or DVD or loading onto a MP3 player.

Paging WPF DataGrid

by WyoMetz

Simple and easy paging of a WPF DataGrid with DataTable and LINQ queries

Read CSV file using C#

by ASP.NET Community

I'm going to expalin how extract data from csv file using c#.First you have to declare two string variables and their properies for store directory

Refreshing Content of the Table using AJAX in ASP.NET MVC (jQuery DataTables and ASP.NET MVC Integration - Part III)

by Jovan Popovic(MSFT)

How to refresh content of the table in ASP.NET MVC using the jQuery DataTables plug-in

Retrieving failed records after an SqlBulkCopy exception

by David Catriel

How to get a list of data rows that caused an exception (or several of them) in a SqlBulkCopy operation

Show Hide Grid Content using Server side(.Net) and Client side(JQuery)

by vinodkumarnie

Handling controls inside GridView using RowCommand and jQuery.

Shuffle DataRow in DataTable

by ASP.NET Community

We all know that we can sort the rows in DataTable by making a simple use of DefaultView. But now if i want a few conditional rows to be shuffled in

Swaping GridView rows Up and Down

by ASP.NET Community

In this article I am posting code about swapping GridView rows Up and Down using DataTables.Here is Aspx Code <form id="form1"

Table Row Drag and Drop in ASP.NET MVC (jQuery DataTables and ASP.NET MVC Integration - Part VI)

by Jovan Popovic(MSFT)

Reordering table rows using drag and drop functionality with jQuery DataTables plug-in in ASP.NET MVC applications