TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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)
Reply
Answers (
1
)
asp.net
JQuery