Need some professional advice...

Hi guys,

I am writing an ASP.NET 3.5 Website for a client.

Here is what she wants to do... I am stuck thinking of a way to plan this out... Some suggestions would be great...

She wants to list all of the major colleges in the USA. Then she wants to show what each college offers as far as courses and degrees that can be earned.

So I have one table that will hold all of the college names.
The second will hold the names of all the available courses.

What I need now is a way to list all of the courses under each college, then have a check mark that can be selected under each, that will say you can earn a diploma, a masters, etc in this course... now keep in mind the next school may only offer just a diploma in that course.

I am going to attach a Screen Shot of what I am trying to do to see if this helps explain better. If someone can point me to a tutorial or something that would be awesome!

Thanks so very much in advance!

acrow

Attachment 81866

Hello,

If you wanted to get REALLY fancy, you could use this:

http://weblogs.asp.net/scottgu/archi...available.aspx

As for the screenshot...

You could do this using a GridView. You would need to construct a SQL Query, such that the information was returned in that format, i.e. one row, multiple columns indicating true/false for whether they are supported or not, and from there it is just a CheckBoxField for the column, and away you go.

Gary