Search Access DB using ASP and SQL

[TammiB78]

Hi,

I have an asp form on my website that has multiple drop down boxes. When
the user clicks on the submit button, I need to search the database for
records that match the criteria the user selected in the drop down boxes. I
haven't used sql in a long time and I need to figure this out asap. If
anyone has any suggestions, it would be greatly appreciated.

Tammi

 

[Stefan Hoffmann]

hi Tammi,

You should ask such question in either the C# or the ASP.Net newsgroups.

I have an asp form on my website that has multiple drop down boxes. When
the user clicks on the submit button, I need to search the database for
records that match the criteria the user selected in the drop down
boxes. I haven't used sql in a long time and I need to figure this out
asap. If anyone has any suggestions, it would be greatly appreciated.

Take a look at the data access tutorials at

http://www.asp.net/learn/

Imho the easiest way is using the EntLib DAAB to query your data:

http://davidhayden.com/blog/dave/archive/2007/01/28/EnterpriseLibraryDAABMicrosoftAccess2007.aspx


mfG
--> stefan <--