Exception Details: System.Data.SqlClient.SqlException: Must specify table toSQL error

Hi,

Using VB.Net, I'm trying to retrieve data using a dataset. The data is to be retrieved by passing a SQL string (built in VB) to a stored procedure, which then executes it.

The actual error is as follows:

Must specify table to select from.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Must specify table to select from.

Source Error:

Line 112: ' Create and Fill the DataSet
Line 113: Dim myDataSet As New DataSet()
Line 114: myCommand.Fill(myDataSet)
Line 115:
Line 116: ' Return the DataSet


The SQL string is correctly built and passed to the stored procedure.

If you have any Ideas, please feel free to respond.

Kind regards,

Rob