In ASP.net MVC , how to use a dynamic model?

Question

I create model from my sql 2008 server database using northwind example. Model.Order, I want to dynamically use the Order rows, just like datatable

DataTable a = New DataTable() .

.......fill the order data to table a .and then I can use

a[1] or a["orderid"] to get the data . but in mvc Ican just use Model.Order a = new Model.Order() ...fill the a with data . use a.OrderID to get the data

Is there any way to foreach it with count like

 for(int i=0;i<a.count;i++)
    {
      //how to get the data like these way ??
    }

score 0 · Answer 1 · answered Sep 10 '14 at 04:08

0

From your replies above it sounds like you want to use the ModelMetadata to display the data for an unknown model type. I developed Dynamic MVC to do something like this. Let me know if this helps.

http://dynamicmvc.com

answered Sep 10 '14 at 04:08

Chris Perry

121
5

score 0 · Answer 2 · answered Aug 26 '11 at 15:29

0

Generally speaking you want to give your View an IEnumerable<T>. So for example, you do something like:

@model IEnumerable<Project.WebUI.Models.Order>

@foreach (var item in Model) {
    <h1>item.Customername</h1>
}

In your controller, you have to create an IEnumerable<Order> collection and then pass it along the view. Since the controller is just a C# class, creating the collection will be the same process as you've come to know during previous .NET work.

The only new thing that you have to realize in MVC is that the View is dumb. It doesn't do any code processing, just burps up the information you've given it from the controller into a format you've defined in the view.

Does this make sense?

answered Aug 26 '11 at 15:29

Only Bolivian Here

35,719
63
161
257

I know this ,But I have many tables like order ,so in the control I like to enumerate the order's column ,I don't know the column name ,I like this – openkava Aug 27 '11 at 03:07
I know this ,But I have many tables like order ,so in the control I like to enumerate the order's column ,I don't know the column name ,I like this in function in control : public string getJsonData( orders){ foreach(var item in orders ) { StrinbBUilder sb = new StringBuilder ; for(int i =0;i – openkava Aug 27 '11 at 03:21

score 0 · Answer 3 · edited May 23 '17 at 11:55

0

This answer should answer your question

Enumerating through an object's properties (string) in C#

with Model.GetProperties() in get a list of all the properties. Then with a foreach you obtain the names and values of them. Hope it helps

edited May 23 '17 at 11:55

Community

1
1

answered Aug 27 '11 at 08:23

Iridio

9,213
4
49
71

In ASP.net MVC , how to use a dynamic model?

3 Answers3