---
title: "how to Convert Generic List to DataTable in c#"  
description: "how to Convert Generic List to DataTable in c#"  
author: "Anonymous User"  
published: 2020-12-01  
updated: 2020-12-01  
canonical: https://www.mindstick.com/forum/156184/how-to-convert-generic-list-to-datatable-in-c-sharp  
category: "c#"  
tags: ["c#"]  
reading_time: 3 minutes  

---

# how to Convert Generic List to DataTable in c#

how to [Convert](https://www.mindstick.com/forum/2093/configurationmanager-appsettings-convert-n-to-n-why) Generic List to [DataTable in c#](https://www.mindstick.com/forum/12872/getting-count-of-all-repeated-rows-in-a-datatable-in-c-sharp)

## Replies

### Reply by Anonymous User

Here we are going to convert Generic List to [datatable](https://www.mindstick.com/blog/195/datatable-in-ado-dot-net) in c#.

Creating a simple Employee class following below:

```
 public class Employee
    {
        public string Name { get; set; }
        public int EmpId { get; set; }
        public int salary { get; set; }
    }
```

And a List with some data following below:

```
     List<Employee> Employee = new List<Employee>(){
                new Employee() { Name = "Pawan", salary = 15000, EmpId = 100 },
                 new Employee() { Name = "rajeev", salary = 25000, EmpId = 101},
                new Employee() { Name = "John", salary = 21000, EmpId = 102 }
            };
```

Create a method that will convert any type of Generic List to a DataTable.

```
    public DataTable ToDataTable<T>(List<T> items)
        {
            DataTable dataTable = new DataTable(typeof(T).Name);
            //Get all the properties by using reflection
            PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
            foreach (PropertyInfo prop in Props)
            {                //Setting column names as Property names
               dataTable.Columns.Add(prop.Name);
            }
            foreach (T item in items) {
                var values = new object[Props.Length];
                for (int i = 0; i < Props.Length; i++)
                {
                    values[i] = Props[i].GetValue(item, null);
                }
                dataTable.Rows.Add(values);
            }
            return dataTable;
        }
```

To call the “ToDataTable” method on button Click, use the following Code:

```
 List<Employee> Employee = new List<Employee>(){                  new Employee() { Name = "Pawan", salary = 15000, EmpId = 100 },
                 new Employee() { Name = "rajeev", salary = 25000, EmpId = 101},
                new Employee() { Name = "John", salary = 21000, EmpId = 102 }
            };

       DataTable dt = ToDataTable(Employee);
```

## Example :

```
    protected void btnConvertDatatableToList_Click(object sender, EventArgs e)
        {
            List<Employee> Employee = new List<Employee>(){
                new Employee() { Name = "Pawan", salary = 15000, EmpId = 100 },
                 new Employee() { Name = "rajeev", salary = 25000, EmpId = 101},
                new Employee() { Name = "John", salary = 21000, EmpId = 102 }
            };
            DataTable dt = ToDataTable(Employee);
        }
```

I hope it will help to you.


---

Original Source: https://www.mindstick.com/forum/156184/how-to-convert-generic-list-to-datatable-in-c-sharp

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.