Datatable转实体和list实体

 /// <summary>
        /// DateTable转实体
        /// </summary>
        /// <typeparam name="T">对象实体</typeparam>
        /// <param name="table">table</param>
        /// <returns></returns>
        public static T GetEntity<T>(DataTable table) where T : new()
        {
            T entity = new T();
            if (table != null)
            {
                foreach (DataRow row in table.Rows)
                {
                    foreach (var item in entity.GetType().GetProperties())
                    {
                        if (row.Table.Columns.Contains(item.Name))
                        {
                            if (DBNull.Value != row[item.Name])
                            {
                                item.SetValue(entity, Convert.ChangeType(row[item.Name], item.PropertyType), null);
                            }

                        }
                    }
                }
            }
            return entity;
        }
        /// <summary>
        /// datatable转对象集合集合
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="table"></param>
        /// <returns></returns>
        public static IList<T> GetEntities<T>(DataTable table) where T : new()
        {
            IList<T> entities = new List<T>();
            foreach (DataRow row in table.Rows)
            {
                T entity = new T();
                foreach (var item in entity.GetType().GetProperties())
                {
                    if (row.Table.Columns.Contains(item.Name))
                    {
                        if (DBNull.Value != row[item.Name])
                        {
                            item.SetValue(entity, Convert.ChangeType(row[item.Name], item.PropertyType), null);
                        }
                    }
                }
                entities.Add(entity);
            }
            return entities;
        }

用法:

DataTableTool.GetEntity<Courselnfo>(datatble数据);
DataTableTool.GetEntities<List<Courselnfo>>(datatble数据);