Follow the CodeBank link in my signature and check out my thread on Retrieving & Saving Data. One of the examples uses a data reader to read the result set of a query one record at a time. You can create a List<string> and then read the data the same way and add each value to that list. When you're done, you can just use the List as is or, if you specifically need an array, you can call its ToArray method.