How to display a matrix in Html

Question

I have 3 classes:

class R{ string NameR;}

class A{ string NameA;}

Class RP

{

  R objR;

  A objA;

  bool result;

}

I use NHibernate so in DB I have a table RP:

[Id] [int] IDENTITY(1,1) NOT NULL,

[Result] [bit] NULL,

[RId] [int] NULL,

[AId] [int] NULL

I need to display in my view a matrix like this:

__ A1 A2 A3

R1 1 0 1

R2 1 1 0

R3 0 0 1

where A1,A2,A3 are values for NameA, R1,R2,R3 for NameR and 1,0,1,0.. value for Result field. Problem: Columns number can grow if I add new A objects

Question:

Is't there a HtmlHelper that display such a grid (from a list of objects RP)?
Is't there a HtmlHelper that display a grid from a DataTable object (I create a sql query that renders this grid)?

First of all your code is wrong, where're the collections?

queen3
– queen3

2009-11-19 16:25:22 +00:00
Commented Nov 19, 2009 at 16:25 — queen3
– queen3, Commented Nov 19, 2009 at 16:25

queen3 · Accepted Answer · 2009-11-19 18:15:00Z

2

Anyway, even if you don't provide enough details, here it is. If you have IList<RP> you'll do

 <table>
  <tr>
      <th>R/A</th>
      <% foreach (var a in Model.Select(x => x.objA.NameA).OrderBy(x => x).Distinct()) { %>
           <th><%= a %></th>
      <% } %>
  </tr>
  <% foreach (var data in Model.GroupBy(x => x.objR.NameR)) { %>
      <tr> 
         <td><%= data.Key %></td>
         <% foreach (var aas in data.OrderBy(x => x.objA.NameA)) { %>
            <td><%= aas.result ? "1" : "0" %></td>
         <% } %>
      </tr>
  <% } %>
 </table>

Of course you better have this calculated in controller, so that you pass grouped model instead of a list to the view. And it assumes that you always have exact number of A's, or you'll have to extend logic a bit.

answered Nov 19, 2009 at 18:15

queen3

15.6k8 gold badges69 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to display a matrix in Html

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related