database stored procedure

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hello ,

I have a form on dotnet in which there are around 20 fields according to this filter data fetch in gridview so i want to make a stored procedude in which data fetching is done accordind to filter condition .........

in short for example there are fields like country, city,product, item,quality,location etc so i want that if we select only country than according to this data fetched and if we select two fields like country and city then data is fetch accoding to that and so on
and one more thing that field are not related to each other each field are separte....

Please Reply

Thanks & Regards
Srishti

Posted 25-Feb-13 19:39pm

srishti_

Add a Solution

Comments

RDBurmon 26-Feb-13 2:07am

Could you please provide image of your form to get more clarity on your searching method ?
You can upload your image in free image hosting site and paste a link here

See this http://postimage.org/

srishti_ 26-Feb-13 2:35am

link is
http://postimage.org/image/xdjmtnefx/

but in this link field are less i have some more fields around 20.......

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)

OriginalGriff · Answer 1 · 2013-02-25T20:13:00

You could do it, but it's horribly messy, as you have probably seen when trying to do it in .NET - which is presumably why you want to move it to SQL so you don't have to think about it! :laugh:

There is no magic way to do it: It's actually easier to do in .NET rather than SQL because it's range of string manipulations is better, but the principle is the same in either case.

To do it in SQL you have to assemble a SELECT statement as a varchar string, then EXEC the string.
I'm not going to do it for you, because in SQL it's a monolithic CASE WHEN statement, using a prefix to separate clauses:
0) Set the query string to "SELECT <your fields list> FROM <Your table>"
1) Start with the prefix set to " WHERE "
2) Check the first parameter. If it is present, then append the prefix to the query string, then add your parameter data to that. Set the prefix to " AND "
3) Check the second parameter. If it is present, then append the prefix to the query string, then add your parameter data to that. Set the prefix to " AND "
Repeat.

It's easier, tidier and more maintainable in .NET - at least you have arrays!