searching in database

Question

i have a table named fname (say). this table has two fields named date and student roll. i need to search all the roll numbers corresponding to a date. suppose i have five roll number entry corresponding to date 10/24/2010. i need to accumulate all the roll numbers in a gridview at once. how can i do it? please give me some suggestions. thanks in advance