Good morning all... 
I want to know how I can set up a dataset in VB.net (beta2 enterprise) by calling a SQL Server stored procedure.
The help files are not very helpful, or I'm not looking in the right place.
I've got a WebService that I want to call with a parameter of a ClientID. This then populates a Dataset and then returns the results.
I've got it returning all clients just by using the drag/drop SQLConnection and SQLDataAdapter, but I now want to enhance this to call a stored procedure in the SQL DB that will return the ClientID. I've already got the stored procedure set up, I just need to know how to populate the parameter and get access to the results.
Any help much appreciated.
Mucho Thanks
Robert
I want to know how I can set up a dataset in VB.net (beta2 enterprise) by calling a SQL Server stored procedure.
The help files are not very helpful, or I'm not looking in the right place.
I've got a WebService that I want to call with a parameter of a ClientID. This then populates a Dataset and then returns the results.
I've got it returning all clients just by using the drag/drop SQLConnection and SQLDataAdapter, but I now want to enhance this to call a stored procedure in the SQL DB that will return the ClientID. I've already got the stored procedure set up, I just need to know how to populate the parameter and get access to the results.
Any help much appreciated.
Mucho Thanks
Robert