how to store items from database using array

Question

  Table as follows

  

    Faculty id(Table name from faculty)

      1

      2

      3

      4

      5

      6

      7

      8

      9

     10

Then i have select query as follows

  Select CourseName from Course where Faculty id = '4'

   

  i want to store the Facultyid(From Table faculty) using array and pass that array into above select statement.

 for that how can i do using csharp.

 Regards,

 rao.