Gridview show the record from the database

See more:

C#

Batch table as follows

Batchid

1
2
3
4
5
6
7
8
9
10

First Query as follows

select Batchid from batch order by 1 asc

second Query as follows

select b.batchid, s.studid,f.bfid, f.rate from batch b, studdet s, facfeedback f
where month(b.examdate) = 9 and year(b.examdate) = 2012
and b.batchid = s.bthid and f.studid =s.studid and f.bfid = '9' and b.batchid = 10
First query i have Batchid from batch table

in Second query i pass the batchid


Design screen as follows



Faculty Name dropdownlist1
Faculty ID dropdownlist2
Month dropdownlist3
Year dropdownlist4
Batchid DRopdownlist5

I have one gridview and one Show Button.


In run mode when i select the Faculty Name in the dropdownlist2 facutly id will be displayed and select the month and year and batch id then when i click the Show button.


In Gridview output as follows


Batchid Studentid Facultyid Rate

10 234 5 2
10 235 5 3

The above output in Gridview shows as for that batchid(10) and for particular Facultyid(5) this much of students give the Rate.


In show Button how can i write the code.

please help me

Regards,
Narasiman P.