Search on database using mutiple values from textbox

Question

1.00/5 (2 votes)

See more:

I have three text boxes - roll,registration,name ;and a submit button

Now the user can provide input in the text boxes

there is a possibility of few textboxes being blank. So a empty ( "" ) string goes into the where clause.

I want a select query in such a way that it should search the data in database according to the values entered by the user, and ignore the the values not entered

Posted 22-Jan-16 2:36am

Member 12270086

Updated 22-Jan-16 2:41am

Richard MacCutchan

v2

Add a Solution

Comments

F-ES Sitecore 22-Jan-16 8:44am

Are you using a stored procedure? ADO.net? Entity Framework? Something else?

Member 12270086 22-Jan-16 8:51am

no....

F-ES Sitecore 22-Jan-16 8:53am

You must be using something to access the database. If we don't know what technology you're using we can't give you a solution.

HardikPatel.SE 22-Jan-16 8:47am

You have to use Dynamic Query for it...

Member 12270086 22-Jan-16 8:51am

how could i use it??

HardikPatel.SE 2-Feb-16 8:41am

Like given in following solution and create Where conditions as per your conditions and append that query and then pass it to SQL Stored procedure and write exec('DynamicQuery').

1 solution

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)

Richard MacCutchan · Answer 1 · 2016-01-22T02:46:00

Then you need to adjust your select clause to ignore the blank entries. A few if statements and a StringBuilder should do the trick.

C#

StringBuilder select = new StringBuilder("SELECT * from datatable WHERE");
if (!textRoll.IsEmpty && textRoll != "")
{
// add the details for the roll being present
// and the parameter value(s) for the query
}
...
// repeat for the other fields