Developing a "Genric" Grid

[Chuck]

I need to develop Grid controls for a database to provide CRUD operations. The only issue is we got around 600 tables thus looking at ideas on how to make the ASP.MVC grid control razor code more generic. My idea is to decorate the properties on a object with attributes, where I am lost is the Razor part.  May be I have to go all JS and skip Razor code generation ? 

Thoughts ?

Jay

[Nikolay Rusev]

Hello Jay,

We are not sure what are the issues which you are facing in ` the Razor part. `. Can you please explain a bit more?

Regards,
Nikolay Rusev
Telerik

 

 

[Informed Sources]

I'm looking at something similar.

I think he means where you bind the columns 

columns.Bound(p => p.ShipName)            .Width(500)

how could you pass an model in with an object that defines all the columns to show, their widths and if they're editable. That way you could have the code to set up the grid in one place, and just pass different objects to it to have different content.

also the read and save would need to point to the correct controller

[Nikolay Rusev]

Hello Adam,

The Grid option in the view is defined in C#. That said you can always build the columns depending on some settings. The following example demonstrates column definition based on some server settings passed to the view in the ViewData.

.Columns(columns =>
{
 foreach (GridColumnSettings d in (List<GridColumnSettings>)ViewData["MyField"])
 {
  columns.Bound(d.MemberType, d.Member)
   .Title(d.Title)
   .Width(d.Width)
   .Sortable(d.Sortable);
  }
})

Regards,
Nikolay Rusev
Telerik