populating a datagrid using sql

[jsub1]

How do I populate a DataGrid with SQL statements written from a textbox in VB?

adoPrimaryRS.Open "SELECT * FROM Authors", db, adOpenStatic, adLockOptimistic.

I need to substitute the "SELECT * FROM Authors" with SQL statements from a textbox.text and then use a command button to run the code and populate the DataGrid

Help Please!
The response to these forums are super!!!!