Posted on: 4/25/2011 11:36:12 PM | Views : 356

Hi Folks
I am fairly new to asp.net. I have done stuff like this in access but not sure how to get it to work here.
 
I have 3 tables a Master,Detail,Item sort of relation ship.
I need to create a GridView of sorts that my users can see data that has been entered update it and or add data to the records easily. I would prefer a non click button method just click in the field edit when done editing all press save or what have you.
 
I am trying to figure out the best way to do this.
 
I have a Query and a Sub Query in access that pulls out the data I need so I would like to show it as an example.
The first query pulls out all the data for the team and year that are active
SELECT Impact_tblGoals.idGoal, Impact_tblGoals.GoalDescription, Impact_tblTeamIndicators.IndicatorName, Impact_tblTeamIndicators.IndicatorID, Impact_tblTeamIndicators.Active, Impact_tblTeamIndicators.FiscalYear
FROM I ...

Go to the complete details ...