How to create Advance Search..

Question

0.00/5 (No votes)

See more:

Dear sir
i want i have 10 dropdownlist boxs on a web page. i want to search data if any one select at least on or more than one of given dropdownlist Boxes,,

i want to generate dynamic Sql on base of selected value of Dropdownlist box and find record using such genrated sql..
Please Help to make advance search..

thankyou advance;

Posted 8-Feb-15 23:23pm

osmo33

Updated 9-Feb-15 0:23am

v3

Add a Solution

Comments

OriginalGriff 9-Feb-15 5:45am

And?
What have you tried?
Where are you stuck?

osmo33 9-Feb-15 6:01am

i want to make a advance search option where User can select one or more than Dropdownlist and after that click on search button and find record on bases of selected value of droupdownlist boxes from database table..

OriginalGriff 9-Feb-15 6:05am

Yes, I gathered that from the original post.

So what have you done so far to achieve this?
What is stopping you going further?
What help do you need?

osmo33 9-Feb-15 6:10am

what query should we run to get record for one selection of droupdownlist box or
for selection of more than one...

osmo33 9-Feb-15 6:19am

I want to generate dynamic sql query on selection on dropdownlist box.
and search the record on the base of such SQL QUERY.

Please help to do.
..........

2 solutions

Solution 1

"what query should we run to get record for one selection of dropdownlist box or
for selection of more than one..."

It would vary depending on your DB design. If the fields are all in the same table, it's relatively simple:

SQL

SELECT * FROM MyTable WHERE <condition1> OR <Condition2>

Or

SQL

SELECT * FROM MyTable WHERE <condition1> AND <Condition2>

But if they are in different tables, then it gets more complex: potentially a lot more complex.

We can't tell - we don't know what your columns are, your drop downs contain, anything realy. Remember that we can't see your screen, access your HDD, or read your mind! :laugh:

So start by looking at what info you are trying to fetch, and run up queries for various collections of them. It should become fairly obvious with a bit of thinking what you need to do.

Posted 9-Feb-15 0:21am

OriginalGriff

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

anand vemuri · Accepted Answer · 2015-02-09T21:42:00

SQL

--Try this stored proc, pass your required search values form front end by mapping  valid SQL table info.   
 
CREATE PROCEDURE [dbo].[Sp_Studentsearch]  	
	--input paramaters
	@FirstName nvarchar(50) = null,	 
	@Gender nvarchar(50) = null
AS
BEGIN
	--declaring variables
	DECLARE @Query VARCHAR(MAX),
            @WhereQuery VARCHAR(MAX)
      --set query    
      SET @Query = 'SELECT [ID],[FirstName],[LastName],[Gender] FROM [dbo].[Students]'				 
	SET @WhereQuery = 'WHERE 1=1'
	 --search functionality
	 IF ISNULL(@FirstName, '') <> ''
		SET @WhereQuery = @WhereQuery +' AND [FirstName] LIKE' + ''''+  @FirstName + '%' + ''''
	IF ISNULL(@Gender, '') <> ''
		SET @WhereQuery = @WhereQuery +' AND [Gender] LIKE' + ''''+ @Gender + '%' + ''''
	--set
	SET @Query = @Query + @WhereQuery
	--execute query
	EXEC (@Query)
END
GO

How to create Advance Search..

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to create Advance Search..

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us