[thelist] ASP.NET datagrids - displaying JOIN data

holmegm at comcast.net holmegm at comcast.net
Wed Sep 17 06:51:59 CDT 2003

My google skills are failing me on this one ...

I'm starting to (slowly) move my intranet pages
from classic ASP to ASP.NET.  I'm really trying
to use the built in classes (else why bother?).

I have a query:

SELECT Workaround.Workaround_Number,
FROM Workaround INNER JOIN (Screen
 INNER JOIN Workaround_Screen
 ON Screen.Screen_ID =
 ON Workaround.Workaround_ID =

Each Workaround has its own information, and
is linked by a crossover table to a Screen
table.  So there can be multiple screens per
Workaround.  This means if there are three screens
for a given Workaround, there will be three rows
in the results, which will differ only in the
Screen column.

In the past, I have just looped over the query
results, adding the screens to an array and only
outputing a table row when I get to a new Workaround.
So the visual result is like:

Wkrd # | HD Call | Shrt Problem | Date   | Screen(s)
17     | 123456  | Blah, blah   | 2/3/03 | ABCD, EFGH

rather than

Wkrd # | HD Call | Shrt Problem | Date   | Screen(s)
17     | 123456  | Blah, blah   | 2/3/03 | ABCD
17     | 123456  | Blah, blah   | 2/3/03 | EFGH

Is there an elegant way I can do this in ASP.NET,
with something like a datagrid?  I'm not being very
successful finding any examples.  Maybe I just don't
know the right search terms?  I'd appreciate any pointers!


Greg Holmes

More information about the thelist mailing list