Question: table [ [ StudentID , Name,Age,Gender,ProgramID ] , [ 7 9 1 , table [ [ Stephanie ] , [ Brown ] ]

\table[[StudentID,Name,Age,Gender,ProgramID],[791,\table[[Stephanie],[Brown]],19,Female,BCS],[236,Shannon Dawn,25,Female,BA],[618,Geoff Berg,24,Male,ARET],[256,Andrew Schilling,22,Male,BSC],[902,Gary Sang,23,Male,DAAD]]
Time left 0:37:09
Note: There is a StudentDataSet with a Student table, a StudentTableAdapter, a StudentBindingSource, and a StudentDataGridView control on the form.
Note: There is an Average query, named Average, that returns the average age of the student from the Student table.
Note: There is also Max query, named Highest, that returns the highest age of the student from the Student table.
Write the code you would place in the AverageButton click event on your form to call the Average query and the Highest query and display in a DifferenceLabel, the difference between the highest age of a student and the average age.
 \table[[StudentID,Name,Age,Gender,ProgramID],[791,\table[[Stephanie],[Brown]],19,Female,BCS],[236,Shannon Dawn,25,Female,BA],[618,Geoff Berg,24,Male,ARET],[256,Andrew Schilling,22,Male,BSC],[902,Gary Sang,23,Male,DAAD]] Time left 0:37:09 Note: There is

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!