I am using VB6 With SQL Server 2005.
I am using below code to populate VB6 FlexGrid and it's working perfectly.
strSQL="Select * from <TABLE NAME>"
Set Grid1.DataSource = Nothing
Adodc1.ConnectionString = cnn
Adodc1.RecordSource = strSQL
Set .DataSource = Adodc1
Now i want execute Select Statement with Stored Procedure which have input parameter also.
What should i do to Get record with Stored Procedure.
Thanks in advance.