datagrid mimic excel sheet for a newbie

Question

I am really stumped on all of this.

 

I have three database tables

Outcome TABLE - FIELDS: Outcome_id, Name, Notes, Grade, Subject_id

Assessment TABLE - FIELDS: Assessment_id, Name, Custom

Outcome_Plan TABLE(Connecting table) - FIELDS: Outcome_Plan_id, Name, Mark, Outcome_id & Assessment_id

 

I would like to set up my datagrid with my column headers as the values in OUTCOME TABLE - Field values of 'Name' field, my Row Headers as the ASSESSMENT TABLE  - field values of the 'Name' field and the body of the datgrid made up of the information in the Outcome_Plan TABLE where they intersect the Outcome_id & Assessment_id. 

Where would I begin with this? I apologize as I am new to asp.Net and to programming as a whole. I read an article where you suggested not creating a datagrid dynamically but both the Outcome Name field and the Assessment Field values can be added to and the datagrid needs to encompass any additions to the database tables.

 

Is there a way to set this up and bind the data to the datagrid?  I bought Scott Mitchell's book but there isn't really anything about setting up your column headers by the values found in the fields versus the field name itself. 

 

I thought about selecting all the info with one sql statement but what is the syntax to split apart the info into the header values and then the row headers and datagrid body.  As I require to loop through the data I was thinking of creating the grid dynamically and then looping through with the records count as my counter and creating a new column header with each value found but not sure how to relate all of this to the body of the rest of the grid.  Do I require to set up relationships? 

 

The biggest problem seems to lie with the column headers coming from field values versus the actual field names as is generally the case.

 

Thank you, I really need to get started on all of this and need somewhere to begin . . . . .  Maybe what I am attempting is not possible . . . . . .