I have an SQL command object in my data environment. The SQL command receives a variable from the user window to extract the required information from the recordset.

How do I call the SQL command, retrieve the user-entered variable, execute it and display the result of the query in my user window in a data grid?

I am utilizing ADO.