I would create a stored procedure (provided that you are using sql server)that contains the select statement and in the client code(vb.net) fill a dataset based on that storedproc and get the dataset.tables(0).DefaultView as the view to bind to the grid.

Vlad