views:

449

answers:

1

I am trying to automatically convert object's properties to DataTable (object is array and has properties that instantiated from special class which has value type).

The code:

static public DataTable f_GetDataTableFromClassObject(object _objInstance)
{
    // geri dönecek datatable
    DataTable dataTable = new DataTable();

    // nesnenin propertyleri içinde dolanalım ve datatable içine kolon olarak ekleyelim.
    foreach (var p in f_GetProperties(_objInstance))
    {
        if (p.PropertyType.IsArray)
        {
            if (p.PropertyType.BaseType.Attributes.ToString().IndexOf("Serializable")>-1)
            {
                // Now i want to store to DataColumn this properties which is instantiated DifferentClass[] and Serializable                 
            }
        }
        else
        {
            dataTable.Columns.Add(new DataColumn(p.Name, p.PropertyType));                    
        }
    }

    // ve tablomuz.
    return dataTable;
}

What should i do to store this Array in DataColumn?

A: 
class Program
{
    static void Main(string[] args)
    {
        Person cenk = new Person() { adi = "Cenk", yasi = 18 };

        List<Person> lst = new List<Person>()
                               {
                                   cenk,
                                   new Person() {adi = "Cem", yasi = 17, harfler = new[] {"a","b","c"}},
                                   new Person() {adi = "Canan", yasi = 16, harfler = new[] {"a","b","c"}}
                               };
        DataTable dataTable = new DataTable();

        PropertyInfo[] pinfo = props();
        //var s = pinfo.Select(p => dataTable.Columns.Add(new DataColumn(p.Name, (p.PropertyType.FullName).GetType())));



        foreach (var p in pinfo)
        {
            dataTable.Columns.Add(new DataColumn(p.Name, p.PropertyType));
        }

        foreach (Person person in lst)
        {
            DataRow dr = dataTable.NewRow();
            foreach (PropertyInfo info in person.GetType().GetProperties())
            {
                object oo = person.GetType().GetProperty(info.Name).GetValue(person, null);
                dr[info.Name] = oo;
            }
            dataTable.Rows.Add(dr);
        }

    }

    static public PropertyInfo[] props()
    {
        return (new Person()).GetType().GetProperties();
    }
}

public class Person
{
    public string adi { get; set; }
    public int yasi { get; set; }
    public string[] harfler { get; set; }

}
uzay95