the dataset in the objectdatasource does not contain any tables

See more:

C#

ASP.NET

VS2010

dataset

I am facing the error " the dataset in the objectdatasource does not contain any tables" and i have no idea what is causing this problem.

Below is an extract of my codes used to retrieve the second row from the database table:

public DataSet GetConfirmedAdv2(int categoryID)
      {
          SqlConnection conn;
          StringBuilder sql;
          SqlDataAdapter da;
          DataSet confirmed;

          conn = dbConn.GetConnection();
          confirmed = new DataSet();
          sql = new StringBuilder();
          sql.AppendLine("SELECT a.imageID, a.categoryID ");
          sql.AppendLine("FROM ( SELECT *, ROW_NUMBER() OVER(ORDER BY PaymentID) AS RowNo FROM WP_advConfirmed) AS a ");
          sql.AppendLine("WHERE RowNo = 2");
          sql.AppendLine("INNER JOIN WP_advCategory AS b ");
          sql.AppendLine("ON a.categoryID = b.categoryID ");
          sql.AppendLine("WHERE a.categoryID = @categoryID ");

          //sql.AppendLine("AND a.companyID = @companyID");


          try
          {
              conn.Open();
              da = new SqlDataAdapter(sql.ToString(), conn);
              da.SelectCommand.Parameters.AddWithValue("@categoryID", categoryID);
              //da.SelectCommand.Parameters.AddWithValue("@companyID", companyID);
              da.Fill(confirmed);
          }
          catch (Exception ex)
          {
              errMsg = ex.Message;
          }
          finally
          {
              conn.Close();
          }

          return confirmed;
      }

After i bind this method to my objectdatasource and run the page, it shows me the error. Is there something wrong with my SELECT statement that might be causing this?

i tried using the Query string builder and is able to retrieve what i want. but when i copy over to the DAL, it does not work?

Any help will be greatly appreciated.