urgent pl answer

[mvnsatya]

New Message on dotNET User Group Hyd urgent pl answer Reply   Reply to Sender   Recommend Message 1 in Discussion From: mvnsatya hello freinds i have a table subjectcode,questionno,question,answer1,answer2,answer3,aswer4,answer) tablename= exam table(subjectcode-------questionno---------question---------answer1------answer2-------answer3-------answer4-----answer) values(asp.net--------------1-----------what is asp.net----- language-----database------server--------platform----- 4) values(asp.net--------------2-----------mysecond queston----- answer1------aswer2-------answer3--------answer4------2) values(asp.net--------------1-----------what is asp.net----- language-----database------server--------platform----- 4) values(asp.net--------------2-----------mysecond queston----- answer1------aswer2-------answer3--------answer4------2) values(asp.net--------------1-----------what is asp.net----- language-----database------server--------platform----- 4) values(asp.net--------------2-----------mysecond queston----- answer1------aswer2-------answer3--------answer4------2) values(asp.net--------------1-----------what is asp.net----- language-----database------server--------platform----- 4) values(asp.net--------------2-----------mysecond queston----- answer1------aswer2-------answer3--------answer4------2) in the above manner i have a table once the person clicks the asp.net link he will go to new form and get the first question and when he clicks the next button he will get the second question and so on till the end question the same way even for the previos button also. i am using lables to for the questions to get displayed on them ,i have a dropdownbox where all the subjects are there in the list and i have declared dim qno as int; qno = 1 sqlquery = " select question,answer1,answer2,answer3,answer4 from exambank where subjectcode='" & dropdownbox.selectedvaue & "' and questionno = " & qno &" the above query will give me the first record but i want to get the next record and so on and also when i click the previous button i should get the previous record dislayed on the labels so can any one pls tell me the query fast , it is very urgent for me now thanks sai _________________________________________________________________ NRIs Zero balance Account. FREE Money Transfers with FREE DVD https://www.online.citibank.co.in/portal/rca_msntagofline.htm View other groups in this category. To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from dotNET User Group Hyd.