Output From Stored Procedures

[Dreamer2007]

How can I use a stored procedure to return query results and populate a data grid control? I am using VB 6.0 and SQL 2005.

[Tom Wright]

Same way as if you were not using a stored procedure.

Tom Wright tawright915@gmail.com

[Dreamer2007]

Thanks for replying. If you can kindly provide me with some vb 6.0 code to achieve this goal. A parameter is passed to the stored procedure at runtime and records are retrieved by the stored procedure which then populates the grid.

[NetRams]

If you created the stored procedure, then replace that stored procedure name instead of where you have put query in your code earlier.

Be simple and Be sample.

[Xandip]

consider a StoredProc "TEST" with parameters a and b, both of string datatype. call it like this.. Query = "TEST '"& value for a &"', '"& value for b &"'" now execute the Query as you do with simple queries...:)

The name is Sandeep