Search code examples
c#arraysreflectiondatacolumn

Can i store serializable array data in DataColumn?


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?


Solution

  • 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; }
    
    }