how to store the database value using array in asp.net using c#

See more:

C#

Faculty Table as follows


Facultyid

1
2
3
4
5
6
7
8
9
10



i want to store the above Facultyid using array.

i have query as follows

select s.studname,f.bthid,a.Facultyid from studdet s, facfeedback f,Faculty a
where month(b.examdate) = 9 and year(b.examdate) = 2012 and a.Facultyid = '';


from the above query in the a.Facultyid i wan to pass(store) the array value faculty id.

for that how can i do?

how can i store the Facultyid using array and pass the that array value in the above query.


for that how can i do using csharp.

Regards,
Narasiman P.