run sql string

[Guest]

Hello,
I have this sqlStr=â€Select * from myTable where userid=’myUserId’â€
how can I run it in my visual basic program and check it if it returns anything?
Thanks,
Jim.

 

[Jordan]

For some ideas, see my sample code posted in response to another thread "How
to use dataset" which was started at 1:20 PM.

 

[Dale]

You'd be better off running it in Query Analyzer for test.

Dale