DATASET set SELECT with WHERE clause

See more:

C#

VS2010

database

dataset

Hello, in my data access layer i have a method to return a particular field using WHERE clause.

I encountered an error : Dataset in object data source does not contain any tables

below is the code that results in the error message due to the WHERE clause :

public DataSet getImage(int imageID, String companyID)
        {
            SqlConnection conn;
            StringBuilder sql;
            SqlDataAdapter da;
            DataSet image;

            conn = dbConn.GetConnection();
            image = new DataSet();
            sql = new StringBuilder();
            sql.AppendLine("SELECT * FROM WP_advUploads");
            sql.AppendLine("WHERE imageID=@imageID");
            try
            {
                conn.Open();
                da = new SqlDataAdapter(sql.ToString(), conn);
                da.Fill(image);
            }
            catch (Exception ex)
            {
                errMsg = ex.Message;
            }
            finally
            {
                conn.Close();
            }

            return image;
        }

if i remove the WHERE clause, it shows all the information in the database. i only want the one with the specific imageID.

Any one have solution to this?