I would probably populate a dataset. Then use a dataview to populate the grid. I use the dataview because with a dataview you can use sorting and paging. You can also use the built-in features of the gridview in VS 2005.
As far as the SQL statement I would use. If you are trying to combine two columns in a table then you should use a JOIN statement.
I hope this helps. I will try to put up some code by the end of the day that will show how to bind a datagrid with a join statement.
have a good day