ASP and SQL Search

[bigmaddaz]

Right basically created a database in access, which is then displayed in a asp webpage. On this page I need a link called "search" then a page is displayed where the user will be shown a page with a drop down menu, a text field and a submit button.

From the drop down list then they can select various options such as "cd title, genre, price" ... then the text field next to it they type in what they are searching for within that category click submit and hey presto the relevant results are displayed in a table on a new page.

Ive been trying lots of ways to do this... ive got a lot of code done it just isnt bringing up the results. I was wondering if anyone was on msn who could spare 10 minutes of there time and I could send them my work for them too look at and talk me through where im going wrong.

(Cliosport technical helpline basically)

Cheers in advance!

Daz

 

[bigmaddaz]

 

[Capture_db]

hi so is there a problem with your syntx are u writing in c# if so i may be able to help ,
what you need to do is get there information that they have typed into the box and have selected and use this syntax

Select * from table_name where tag_field Like '%" + typeField.ToString() + "%'"

this is a very simple version if you want any help PM me

dan