View Single Post
  #1 (permalink)  
Old February 25th, 2009, 06:53 PM
areed24 areed24 is offline
Authorized User
Join Date: Jan 2009
Posts: 51
Thanks: 0
Thanked 0 Times in 0 Posts
Default Working with a database

I have a database with three tables, CITIES (Id, Name), MEMBERS (Id, Name, Email), COMMENTS (Id, CityId, Comments, MemberId). On the site, there is a drop down which users can select a City. Based on the city seletion, I would like all the comments for that city to appear. How do I output the Member's Name (not Id), Email Address, and Comments in a customizable table for the users to see?

I am new to both ASP.NET and databases, so any information would be greatly appreciated.