forum

home / developersection / forums / how to convert generic list to datatable in c#

Ask Question

how to Convert Generic List to DataTable in c#

Anonymous User 659 01-Dec-2020

how to Convert Generic List to DataTable in c#

c# c# 
Updated on 01-Dec-2020
Anonymous User

Content Writer

I am a content writter !

Message
Can you answer this question?
Answer

1 Answers

Anonymous User

Anonymous User

01-Dec-2020

Here we are going to convert Generic List to datatable 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.

MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy