SQL Search Page ??

Hi :)





Ok i moved to Sql :)





Im having some trouble whith this code ...








Dim Search As String


Search = Request.QueryString("Search")





Dim strConn As SqlConnection = New SqlConnection(ConfigurationSettings.AppSettings("Myconn"))


Dim strSearch As String


strSearch = "SELECT id,brand,catg,foto,ref,descrabrv FROM products WHERE CONTAINS(ref,@search) ORDER BY ref ASC"


strConn.Open()


Dim cmd As New SqlCommand(strSearch, strConn)


cmd.Parameters.Add("@search", Search)





Dim adatp As SqlDataAdapter = New SqlDataAdapter(cmd)





Dim daSet As New DataSet


adatp.Fill(daSet)


rstDG.DataSource = daSet


rstDG.DataBind()


strConn.Close()











The main thing ..this is a result page


I got this error :





Prepared statement '(@search nvarchar(4000))SELECT id,brand,catg,foto,ref,descrabrv ' expects parameter @search, which was not supplied





Can anyone help me with this ???





Thanks in advance





Cheers