C# DYNAMIC DATATABLE TO LIST

        public static List<T> DataTableToList<T>(DataTable dataTable) where T : new()
        {
            List<T> list = new List<T>();
            var props = typeof(T).GetProperties(System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance);

            foreach (DataRow row in dataTable.Rows)
            {
                T item = new T();

                for (int i = 0; i < props.Length; i++)
                {
                    if (dataTable.Columns.Contains(props[i].Name))
                    {
                        object value = row[props[i].Name];
                        try { props[i].SetValue(item, value); } catch { }
                    }
                }

                list.Add(item);
            }
            return list;
        }
//USAGE:  List<B2BLogoIntegration_FicheLine> fL= HELPER.DataTableToList<B2BLogoIntegration_FicheLine>(dt);

Leave a comment