Ok, I have a data environment set up with my tables and such. I can attach any table to a grid and that works fine.

Now I have a DataGrid that I want to attach to a dynamic record set. Meaning my recordset can be any SQL the user types in (assuming it is functioning SQL).

The form has a text box for the user type SQL and a button and a datagrid. When the user clicks the button, I need to make the datagrid show the output created using the specified SQL. Sound simple? It would be if I could figure the flexgrid out!

I want to use the same connection string as being used in the already open data environment. Even the same connection if posible. Help please?

I don't have any data controls on my form.