Webgrid column value depending on multiple values

yudi — Sun, 08 Apr 2012 23:22:10 GMT

I assume that the 8 different Sector tables (“SectorA”, “SectorB”, “SectorC”, …, “SectorH”) have identical structure. If my assumption is correct, then in the select query of “User” table, we can use the union query to combine the results of “Users” and “Sector” select statement into a single result set.

After WebGrid is bind to the “User” – “Sector” union table, the value list can be defined based on the “WorkArea” table.

Hope this helps. Please let us know if you have different scenario.

Webgrid column value depending on multiple values

beyti77 — Wed, 04 Apr 2012 10:03:18 GMT

The first thing I'm trying to achieve is, get a columns value that is calculated using 2 other columns, like:

"User" table has the "PrimarySectorId" and "PrimarySectorTypeId" columns.

And I have 8 different "Sector" tables like "SectorA", "SectorB", .... "SectorH".

There is a "WorkAreaId" column in every sector table that is a foreign key relation with "WorkArea" table's Id.

"PrimarySectorTypeId" is a enum value (integer) that differentiates the sectors.

Therefore, all I need to do is to bind the users to a webgrid and include a WorkArea column, so I need to get both the "PrimarySectorId" and "PrimarySectorTypeId" to get the correct "WorkArea" value.

But as far as I know, I can just use a <value list> and take only one value to calculate a column value.

I'd really like to get it by myself but it has been so long and no step forward I could get.

Thanks in advance.

Note: It would be lovely if someone could include a sample of many to many realationship binding to a webgrid.

Intersoft Community - WebGrid Enterprise - Webgrid column value depending on multiple values

Webgrid column value depending on multiple values

Webgrid column value depending on multiple values