yes you can...but i'm preety curious about the situation...!

fire the query using sqlcommand object and get the data in reader..

and from reader add to array list and finally add arraylist to session..