Passing a value from VB to SQL script

[indydavid32]

I assume that an SQL script running on the SQL server would be faster than running a VB app.

So my question is how would you pass a value from a vb app to an SQL script, and then when the script is done, bring a value back to the vb app.

Anyone have any ideas on this subject?

Thanks

[indydavid32]

I realize that I would have to use a stored procedure.

My question was how do I pass a variable to this stored procedure from a vb app and vicea versa.

Thanks!

[diver]

That is a good way to do it.
Use the ADO command object and fill the parameters with your values before you execute it.

diver

[indydavid32]

How do you use the ADO command object? If someone could point me to a good resource on this I would appreciate it.

Thanks!

[diver]

Well... if you want a sample or something, then do a search on msdn. Otherwise, you might want to start a new thread asking about the ADO command object to solicit input.

diver

[vb_dba]

Or you could search this site. The command object has been discussed several times on these boards, so I'm sure you can find something that's already been posted that will help.

[diver]

That will work... but he wants return values.
The ADO connection object works very good with sql server to do this, and you can verify your parameter types beforehand.

diver