Ablafizi Kibiki

Ablafizi Kibiki

  • NA
  • 15
  • 29.5k

IDNTIFYING INDEX

Jun 1 2013 10:16 PM
How can i determine the index of a row in a dataset if one column value is known?
 
here the code to fill the data set:
string str = "SELECT ROUND(AVG((EXAMRESULTS.assessM1 + EXAMRESULTS.assessM2 + EXAMRESULTS.assessM3)/3), 2), STUDENT.studentId FROM EXAMRESULTS, STUDENT where EXAMRESULTS.Term = '" + comboBox15.Text + "' AND EXAMRESULTS.class = '" + comboBox14.Text + "' AND EXAMRESULTS.StudentId = STUDENT.studentId GROUP BY STUDENT.studentId,  EXAMRESULTS.StudentId ORDER BY AVG((EXAMRESULTS.assessM1 + EXAMRESULTS.assessM2 + EXAMRESULTS.assessM3)/3) DESC";
               
The i want to know the row that will have a particular STUDENT.studentId (say the id   = 23)

Answers (1)