04-30-2012, 11:31 AM
HEY CAN ANYONE HALP ME MAKING AN ADVANCED SEARCHING IN ACCESS DATABASE (IN VB.NET)WHICH TAKES MORE THAN PARAMETERS TO SEARCH...
EXAMPLE IF MY DATABASE HAS THE BOOK CATAGORY
THEN SEARCHING WILL BE AS FOLLOWS:
SEARCH BY:-
CATAGORY
AUTHOR NAME
PUBLISHER NAME
PRICE
ETC.
HERE THE USER CAN GIVE MORE THAN ONE SEARCHING OPTIONS.
THAT IS I MEAN ,TO SAY THAT IF I SEARCH FIRST BY CATAGORY ,LET US ASSUME THE CATAGORY TO BE "COMPUTERS", THEN A LIST OF ALL COMPUTER BOOKS WILL BE LISTED AND IF AMONG THE LISTED BOOKS I CAN REFINE MY SEARCH BY AUTHOR NAME OR PUBLISHER ETC.....
AND AGAIN THE LIST WILL BE REFINED....
I HOPE YOU HAVE UNDERSTOOD I WANT YOU TO UNDERSTAND
PLEASE HELP.
I AM TRYING HARDER BUT UNABLE TO DO SO.....
hELP ..
THANK YOU...
I WOULD LIKE YOU TO UPLOAD THE SOURCE CODE PLEASE......
EXAMPLE IF MY DATABASE HAS THE BOOK CATAGORY
THEN SEARCHING WILL BE AS FOLLOWS:
SEARCH BY:-
CATAGORY
AUTHOR NAME
PUBLISHER NAME
PRICE
ETC.
HERE THE USER CAN GIVE MORE THAN ONE SEARCHING OPTIONS.
THAT IS I MEAN ,TO SAY THAT IF I SEARCH FIRST BY CATAGORY ,LET US ASSUME THE CATAGORY TO BE "COMPUTERS", THEN A LIST OF ALL COMPUTER BOOKS WILL BE LISTED AND IF AMONG THE LISTED BOOKS I CAN REFINE MY SEARCH BY AUTHOR NAME OR PUBLISHER ETC.....
AND AGAIN THE LIST WILL BE REFINED....
I HOPE YOU HAVE UNDERSTOOD I WANT YOU TO UNDERSTAND
PLEASE HELP.
I AM TRYING HARDER BUT UNABLE TO DO SO.....
hELP ..
THANK YOU...
I WOULD LIKE YOU TO UPLOAD THE SOURCE CODE PLEASE......