Neil

Neil

  • NA
  • 5
  • 0

Displaying 20 database elements in addition to a Datagrid

Oct 4 2006 2:39 PM
I am developing a database application that will be getting information off of two tables in the database.  Table 1 contains the high level info, table 2 contains the details.  Based on the selection, I will be populating a DataGrid with the info from Table 2.  But what is the best way to display the Table 1 data, which should only be displayed once.

An example:

Imagine a website called "Major League Pitchers" which contains a list of teams.  Table A on the database contains team information, table 2 contains pitcher information.  You click on the Team of your choice.  You will get a datagrid showing all the stats for the pitchers of that team, W/L record, ERA, games, innings pitched, walks, strikeouts, etc.

But I also need some information displayed on the page, but NOT in the datagrid.  Team Name, Team address, team schedule, record, etc.  What is the best way to get those 20 elements for display?  Right now, there is one label called "Team Name:" and another called TeamNameValue.  Team Address and TeamAddressValue, so the screen looks like this:

Team: Philadelphia Phillies
Address: 1 Main st, Philadelphia.
Team Record 100-62

etc

The Datagrid just gets bound to the table in the dataset, but whats the best way to bind the 20 fields needed?