Convert DataTable To IList - CSharp System.Collections.Generic

CSharp examples for System.Collections.Generic:IList

  1. HOME
  2. CSharp
  3. System.Collections.Generic
  4. IList

Description

Convert DataTable To IList

Demo Code


using System.Reflection;
using System.ComponentModel;
using System.Collections;
using System.Data;
using System.Text;
using System.Linq;
using System.Collections.Generic;
using System;/* ww w . j a v  a2  s . c o  m*/

public class Main{
        public static IList<T> ConvertTo<T>(DataTable table)
        {
            if (table == null)
            {
                return null;
            }

            List<DataRow> rows = new List<DataRow>();

            foreach (DataRow row in table.Rows)
            {
                rows.Add(row);
            }

            return ConvertTo<T>(rows);
        }
        public static IList<T> ConvertTo<T>(IList<DataRow> rows)
        {
            IList<T> list = null;

            if (rows != null)
            {
                list = new List<T>();

                foreach (DataRow row in rows)
                {
                    T item = CreateItem<T>(row);
                    list.Add(item);
                }
            }

            return list;
        }
        public static DataTable ConvertTo<T>(IList<T> list)
        {
            DataTable table = CreateTable<T>();
            Type entityType = typeof(T);
            PropertyDescriptorCollection properties = TypeDescriptor.GetProperties(entityType);

            foreach (T item in list)
            {
                DataRow row = table.NewRow();

                foreach (PropertyDescriptor prop in properties)
                {
                    row[prop.Name] = prop.GetValue(item);
                }

                table.Rows.Add(row);
            }

            return table;
        }
}

Related Tutorials