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

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

Accessing Value from System.Data.DataTable : Tip

by A.J.Wegierski

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

Automatic Numbering for the Primary Key Column

by Shweta Lodha

Automatic numbering for the primary key column

Chat / Conversation Balloon Control with datasource

by IssaharNoam

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

Combining DataTables with Different Schema

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?

Configurable Data Generator for GridView and DataTable

by Hazem Torab

Generate reasonable sample data for you GridView without using databases.

Convert CSV file to XML with DataTable in Visual Basic

by Emiliano Musso

A quick method to convert a CSV file in XML

Convert EntityCollection to DataTable

by Thakkar Amit

Code for converting the EntityCollection of a DataTable.

Create an Excel spreadsheet from Datatable

by Jerry Burch

Quickly create a spreadsheet from Datatable using Interop and the Clipboard

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

by ashkanpower

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

Create Excel file from DataTable

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

Create job to export Stored Procedure daily

by Aadhar Joshi

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

Customizing PDF Generated Using jQuery DataTables Plugin

by Ramesh_Joshi

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

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

by Tajwer Jalal

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

DataSet to T-SQL Script

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.

DataTable to List using Generics

by Abdul Ahad Monty

Convert DataTable to List using Generics.

DataTable.Select is Slow?

by techcap

DataTable.Select performance test and how to improve it

Distinct Raw Data Population in DataTable

by leopard447

How to do distinct raw data population in a DataTable

DuplicateNameException when adding columns to a DataTable dynamically

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.

Dynamically menu binding

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

Easily Apply Sorting for DataTables.js in C#

by Stefan Vincent Haug

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

Export Multidimensional Array to Excel with Formatting in C#

by Santhosh Kumar Jayaraman

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

Export to Excel 2007 Format (.xlsx) with Proper Formatting

by Vishal.KumarSingh

Export Data from a Entity DataSource / GridView / Datatable in ASP.NET to Excel 2007(.xlsx) format with proper formatting and no warning messages

Generic LINQ Usage To Return Single Value From DataRow

by Paul Brower

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

HTML Table with Export, Sort, Filter and Paging

by Er. Puneet Goel

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

Hyperlinked Images in ASP.NET GridView

by DrABELL

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

Jquery DataTable with Custom Filter with Materialize CSS

by SrikantSahu

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

List Batching/Paging With Entity Framework or Any IEnumerable in C#

by DiponRoy

The aim of this helper class is to divide a large IEnumerable into multiple small list.

Multilevel Nested Gridview in ASP.NET

by Chakravarthi Elchuri

Display data in Multi nested gridview using C# in ASP.NET

Nested GridView controls in ASP.NET: best practices

by DrABELL

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

Print DataTable to Console (and more)

by yuvalsol

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

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

by Emiliano Musso

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

Split DataTable into Multiple DataTables C#

by DiponRoy

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

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

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.