How to retrieve all Rows of the DataTable to a List in C#?

Published on May 30, 2013 by abundantcode

Filed under ADO.NET

Last modified May 30, 2013

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 3 (2 votes)

This article have been viewed 16569 times

Below is a sample sourecode demonstrating how to retrieve all rows of the DataTable to a list in C#.

How to retrieve all Rows of the DataTable to a List in C#?

using System;

using System.Collections.Generic;

using System.Data;

namespace AbundantCode


internal class Program


// Using Foreach to loop through datatable and retreive all rows to a List

private static void Main(string[] args)


List<CodeSnippet> CodeLst = new List<CodeSnippet>();

DataTable dt = new DataTable();



DataRow row1 = dt.NewRow();

row1["Name"] = "Abundantcode";

row1["Code"] = "1-1-1";


DataRow row2 = dt.NewRow();

row2["Name"] = "Plenty of sourcecode";

row2["Code"] = "1-1-12";


foreach (DataRow row in dt.Rows)


CodeLst.Add(new CodeSnippet { Code = row["Code"].ToString(), Name = row["Name"].ToString() });


foreach (var Lst in CodeLst)







public class CodeSnippet


public string Name { get; set; }

public string Code { get; set; }




  1. Sinan

    Awesome. Thanks

    April 16, 2015 - 2:54 pm – Reply

  2. Abhi

    very nice

    February 20, 2016 - 12:10 am – Reply

Leave a Comment


You might be Interested in these Posts

How to download a file from a URL using C#?

You can use the WebClient class in C# to download a file. How to download a file from a URL using C...

How to Create an Empty array without defining the size in C# ?

When we create an array in C# , we tend to define the size of the array as shown below. String[] st...

C++ Program to display "Hello, World!"

Problem Write a program in C++ to display "Hello, World!" on the screen. C++ Program to...