Hey

In my SQL statement I use wildcards. But when I try to select something, it never select something. While when I execute the querry in Microsoft SQL Studio, it works fine. What am I doing wrong?

Click handler

protected void btnTitelAuteur_Click(object sender, EventArgs e)
    {
        cvalTitelAuteur.Enabled = true;
        cvalTitelAuteur.Validate();

        if (Page.IsValid)
        {
            objdsSelectedBooks.SelectMethod = "getBooksByTitleAuthor";
            objdsSelectedBooks.SelectParameters.Clear();
            objdsSelectedBooks.SelectParameters.Add(new Parameter("title", DbType.String));
            objdsSelectedBooks.SelectParameters.Add(new Parameter("author", DbType.String));
            objdsSelectedBooks.Select();
            gvSelectedBooks.DataBind();

            pnlZoeken.Visible = false;
            pnlKiezen.Visible = true;
        }

    }

In my Data Acces Layer

public static DataTable getBooksByTitleAuthor(string title, string author)
        {

            string sql = "SELECT 'AUTHOR' = tblAuthors.FIRSTNAME + ' ' + tblAuthors.LASTNAME, tblBooks.*, tblGenres.GENRE "
                        + "FROM tblAuthors INNER JOIN tblBooks ON tblAuthors.AUTHOR_ID = tblBooks.AUTHOR_ID INNER JOIN tblGenres ON tblBooks.GENRE_ID = tblGenres.GENRE_ID "
                        +"WHERE (tblBooks.TITLE LIKE '%@title%');";

                SqlDataAdapter da = new SqlDataAdapter(sql, GetConnectionString());
                da.SelectCommand.Parameters.Add("@title", SqlDbType.Text);
                da.SelectCommand.Parameters["@title"].Value = title;


            DataSet ds = new DataSet();
            da.Fill(ds, "Books");

            return ds.Tables["Books"];

        }

Thanks, Vincent