Convert DataTable to List

public static List ToList(this DataTable dataTable) where TSource : new()

{

var dataList = new List();

const BindingFlags flags = BindingFlags.Public | BindingFlags.Instance | BindingFlags.NonPublic;

var objFieldNames = (from PropertyInfo aProp in typeof(TSource).GetProperties(flags)

select new

{

Name = aProp.Name,

Type = Nullable.GetUnderlyingType(aProp.PropertyType) ?? aProp.PropertyType

}).ToList();

var dataTblFieldNames = (from DataColumn aHeader in dataTable.Columns

select new { Name = aHeader.ColumnName, Type = aHeader.DataType }).ToList();

var commonFields = objFieldNames.Intersect(dataTblFieldNames).ToList();

foreach (DataRow dataRow in dataTable.AsEnumerable().ToList())

{

var aTSource = new TSource();

foreach (var aField in commonFields)

{

PropertyInfo propertyInfos = aTSource.GetType().GetProperty(aField.Name);

var value = (dataRow[aField.Name] == DBNull.Value) ? null : dataRow[aField.Name]; //if database field is nullable

//propertyInfos.SetValue(aTSource, dataRow[aField.Name], null);

propertyInfos.SetValue(aTSource, value, null);

}

dataList.Add(aTSource);

}

return dataList;

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
hi,
you have given code, but you did not mention your problem or what you need, so please
elabrate what you need
Thiruppathi R9y ago
May be this link useful for you

http://www.c-sharpcorner.com/blogs/table-data-convert-to-list-using-reflection
Rajkiran Swain9y ago
http://www.c-sharpcorner.com/UploadFile/ee01e6/different-way-to-convert-datatable-to-list/
Rajkiran Swain9y ago
https://stackoverflow.com/questions/208532/how-do-you-convert-a-datatable-into-a-generic-list
Manikandan Murugesan9y ago
Refer this Article : http://www.c-sharpcorner.com/UploadFile/ee01e6/different-way-to-convert-datatable-to-list/