how can i get the output using sql query

See more:

C#

Student table as follows;

studentid   studentname  marks  Qpname
1          Ram      70     MFA
1              Ram          80     TCF
1              Ram          80     AFF
1              Ram          80     PH2
2          Sam      70     MFA
2              Sam          80     TCF
2              Sam          80     AFF
2              Sam          80     PH2
3          Raja         70     MFA
3              Raja         80     TCF
3              Raja         80     AFF
3              Raja         80     PH2

Answer table as follows;

studentid  Qno
 1          2
 1          4
 1          10
 1          7
 2          3
 2          5
 2          6
 2          8
 3          7
 3          9
 3          10
 3          6

Course Table as follows;

CourseCode
 MFA
 TCF
 AFF
 PH2

Batch Table as follows;

Btchno     Batchdt       Attender
B1152      5/4/2010       RK
B1135      6/4/2013       MJ
B734       18/4/2013      SK
B802       24/4/2013      VG

From the above four table using i want the output as follows;


in run mode as follows;

Student id textbox1 Show (Button)

when i enter the student id and click the Show Button i want the output as follows from the database records'

Marks  Qpname Qno CourseCode  Btchno     Batchdt       Attender

for that how can i write the query using sqlserver