I have a SQL query that returns a single column of data. I would like to put those results into a string array. I am running SQL Server 2005, so have to use SMO. The syntax I have to execute the query is:
but not sure how to get that into an array. I've been playing around with it quite a bit. If I add the .Tables property, I get a list of values from the query, complete with a header, but can't seem to get that information into an array.