convert List items to Datatable

Question

i need to convert list dynamic items to datatable . please help on this below is my sample code. public DataTable ToDataTable (dynamic items) { return dtDataTable; }

Manav Pandya · Answer

Hello I have developed same functionality as you want Please find attachment below : class Program { static void Main(string[] args) { // Created List of Dynamic items List items = new List (); items.Add( "Manav" ); items.Add( 'B' ); items.Add( 10 ); items.Add( 10.10 ); items.Add(true); DynamicToDT(items); // Calling conversion method Console.ReadKey(); } public static DataTable DynamicToDT(List objects) { DataTable dt = new DataTable( "MAnav" ); // Runtime Datatable dt.Columns.Add( "Values" ,typeof(string)); // Adding dynamic column if (objects != null && objects.Count > 0 ) { for (int i = 0 ; i { DataRow dr = dt.NewRow(); // Adding values to Datatable dr[ "Values" ] = objects[i]; dt.Rows.Add(dr); } return dt; // Converted Dynamic list to Datatable } return null; } } I hope your doutbts will be solved Thanks

Altaf Ansari · Answer

Try this : public DataTable ClassToDataTable (List items) { DataTable dataTable = new DataTable( typeof (T).Name); //Get all the properties PropertyInfo[] Props = typeof (T).GetProperties(BindingFlags.Public | BindingFlags.Instance); foreach (PropertyInfo prop in Props) { //Defining type of data column gives proper data table var type = (prop.PropertyType.IsGenericType && prop.PropertyType.GetGenericTypeDefinition() == typeof (Nullable ) ? Nullable.GetUnderlyingType(prop.PropertyType) : prop.PropertyType); //Setting column names as Property names dataTable.Columns.Add(prop.Name, type); } foreach (T item in items) { var values = new object [Props.Length]; for ( int i = 0; i { //inserting property values to datatable rows values[i] = Props[i].GetValue(item, null ); } dataTable.Rows.Add(values); } //put a breakpoint here and check datatable return dataTable; }

Manav Pandya · Answer

Hello Please show me model.TableColumnValues snippet And tell me that how many rows you want , bcoz i have taken single column and six rows Thanks

venkat · Answer

My input is this one : DataTable dt = new DataTable(); dt = ClassToDataTable (model.TableColumnValues); if i pass like this , i am getting error plz help on this so how to change public DataTable ClassToDataTable (List items) { so i am not able to call ClassToDataTable. so any solution

venkat · Answer

please find attached file

Manav Pandya · Answer

Hello Please attach your code because photo quality is too bad , i cant understand it Thanks

venkat · Answer

Below is my model.Tablecolumns snippet

venkat · Answer

above one is my dynamic data. first screen is my input dynamic data. after calling that method am getting data like above screen. any suggestions.

convert List<dynamic> items to Datatable

Answers (8)