Advanced search using C# ASP dot net 2010 with SQL server 2008 database.

Question

0.00/5 (No votes)

See more:

Friends,
I need an Advanced search in .aspx page with one dropdown combobox for gender selection
and one for Age range (From age, To age) and one for Class(class 1 to 12) and one for Section(A,B,C) So altogether there are 5 dropdown combobox. The result will be displayed in Gridview. I need a very simple code in c# .aspx in sql server 2008. I DONT WANT stored procedure or LINQ to SQL Classes please.
Kindly give a reference link or source code similar to my requirement.
Thank you and please help.

What I have tried:

I just designed .aspx page - nothing fashion and waiting for help from you for code behind.

Posted 15-May-21 0:36am

ravitv

Updated 15-May-21 3:46am

Add a Solution

2 solutions

Solution 1

Sorry, you misunderstand the purpose of this forum. It is for answering technical questions, not for doing other people's work.

Posted 15-May-21 1:04am

Richard MacCutchan

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wendelius · Accepted Answer · 2021-05-15T03:46:00

As far as I can see if you select something from a combo box, then you would generate corresponding condition into your SQL statement.

For example if your initial SQL looks like

SQL

SELECT ...
FROM MyTable mt
WHERE ...

Now when something from the age combo is selected you would add corresponding condition

SQL

AND Age = @SelectedAge

In your code you would also add definition for the parameter as described in SqlParameter Class (System.Data.SqlClient) | Microsoft Docs[^]

So in brief you dynamically add conditions and their parameters when user select something from the comboboxes.

One thing to notice is that SQL Server 2008 is no longer supported so you should use a newer version. See End support SQL Server 2008 R2 (KB 4456242) - SQL Server | Microsoft Docs[^]