convert List<dynamic> items to Datatable

venkat

8y21.9k.NET

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;

}

8 Replies

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

venkat8y ago
please find attached file
+1
Manav Pandya8y ago
Hello

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

Thanks
0
venkat8y ago
Below is my model.Tablecolumns snippet

+1
Manav Pandya8y ago
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
+1
venkat8y ago

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.
+1
Manav Pandya8y ago
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 < objects.Count;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
+3
venkat8y ago
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
+2
Altaf Ansari8y ago
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 < Props.Length; 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;
        }
+3