Is it possible to create a new type on fly (add properties depending on the type of data )?

Question

my application read Excel sheets and display it as a table. What I do is reading DataTable and putting data in an object of type:

List<List<string>>

To display data on the page I use 2 loops (inner and outer) to recreate the table.

What I'd like to do is to create a new type MyType, for instance. Then add properties to it depending in number and value types to the headers of the Excel data. I believe it's easier to work with type.

Thanks for helping

Related but not the same: http://stackoverflow.com/q/3862226/121309 — Hans Keﬆing, Oct 14 '10 at 11:12
@Hans Kesting: Yes, that is more or less whatI want. But, it's just heavy with the code. — Richard77, Oct 14 '10 at 11:25

score 2 · Answer 1 · answered Oct 14 '10 at 11:18

I think you may be looking for ExpandoObject, which lets you add arbitrary properties to each object at run-time. For example:

dynamic obj = new ExpandoObject();      // initially empty object
obj.Spread = "Nutella";   // obj now has a “Spread” property of type string

Of course, you can then put this object into a List<dynamic> along with all the other objects.

score 1 · Answer 2 · answered Oct 14 '10 at 11:07

1

You can do it using reflection.
take a look at the TypeBuilder class

answered Oct 14 '10 at 11:07

Itay Karo

17,924
4
40
58

score 0 · Answer 3 · answered Oct 14 '10 at 11:08

0

Maybe anonymous types?

http://msdn.microsoft.com/en-us/library/bb397696.aspx

You do need to set the properties all in one go, though.

answered Oct 14 '10 at 11:08

crdx

1,412
13
26

1

I think that the properties are only known at run-time. – Itay Karo Oct 14 '10 at 11:09

Is it possible to create a new type on fly (add properties depending on the type of data )?

3 Answers3