-
Dynamic sql query
Hi! I'm making an application in vb.net using MS Access as DB.. Nw in this, i want to do some complex stuff, that is dynamically making sql queries or in other words, changing the where clause according to user preference.
The scenario let's say is...in a form the user can search for records thru 1) university name or 2) between 2 dates 3) through application ids... They can do each of this individualy or 1 n 2 together or 1 n 3 etc. Now instead of writing the sql query for each combination, do you think there is a way i can put in a flag value n get wateva the user wants to search frm n pass that to the where clause?
Thank you so much!
-
It's possible to pass as parameter, but you still need to build that parameter.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|