Create Database report with VB

I need to create an application that can create a report from a view in a sql database.  I need to be able to pass it a search filter or sql query and then print it to the screen.  I've found examples of how to parse a dataset and print it out, but I need to be able to filter the data that comes out or perhaps create a dataset based on the filtered data that I can then spout out with a nested for loop for each column or row.

Can anyone point me in the right direction?

What do you mean by "create a report"?