convert an object (list of strings) into data table

Question

I am working in C# and .net core. I have an object which consist of multiple lists of strings and i want to convert this object into datatable.

I have tried this code, but it failed:

public static DataTable ObjectToData(object o)
{
    DataTable dt = new DataTable("OutputData");

    DataRow dr = dt.NewRow();
    dt.Rows.Add(dr);

    o.GetType().GetProperties().ToList().ForEach(f =>
    {
        try
        {
            f.GetValue(o, null);
            dt.Columns.Add(f.Name, typeof(string));
            dt.Rows[0][f.Name] = f.GetValue(o, null);
        }
        catch { }
    });
    return dt;
}

Please amend your question to at least show what you have been working with. — Lee Taylor
– Lee Taylor, Commented Sep 28, 2019 at 21:24
Update. I am get System.Collections.Generic.List`1[System.String] this in row as data — Billz
– Billz, Commented Sep 28, 2019 at 21:29
Possible duplicate of stackoverflow.com/questions/4981390/… — Progman
– Progman, Commented Sep 28, 2019 at 21:31

R M Shahidul Islam Shahed · Accepted Answer · 2019-09-28 22:20:23Z

2

Generic convertion:

public DataTable ListToDataTable<T>(IList<T> data)
    {
        PropertyDescriptorCollection properties =
            TypeDescriptor.GetProperties(typeof(T));

        DataTable table = new DataTable();

        foreach (PropertyDescriptor prop in properties)
                table.Columns.Add(prop.Name, Nullable.GetUnderlyingType(prop.PropertyType) ?? prop.PropertyType);

        foreach (T item in data)
        {
            DataRow row = table.NewRow();
            foreach (PropertyDescriptor prop in properties)
            {
               row[prop.Name] = prop.GetValue(item) ?? DBNull.Value;
            }
            table.Rows.Add(row);
        }
        return table;
    }

answered Sep 28, 2019 at 22:20

R M Shahidul Islam Shahed

1,38417 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TiGreX · Accepted Answer · 2019-09-28 21:49:50Z

your problem is that you add the DataRow at the start of it. what you have to do is instanciate it, and then assign the values and finally add it to the datatable. Also change the add information into the row for the next dr[f.Name] = f.GetValue(o, null);

here is the code:

public static DataTable ObjectToData(object o)
{
    DataTable dt = new DataTable("OutputData");

    DataRow dr = dt.NewRow();


    o.GetType().GetProperties().ToList().ForEach(f =>
    {
        try
        {
            f.GetValue(o, null);
            dt.Columns.Add(f.Name, typeof(string));
            dr[f.Name] = f.GetValue(o, null);
        }
        catch (Exception e)
        {
            Console.WriteLine(e.Message);
        }
    });

    dt.Rows.Add(dr);

    return dt;
}

you can find an example here https://dotnetfiddle.net/EeegHg

Collectives™ on Stack Overflow

convert an object (list of strings) into data table

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related