Creating named parameter query in visual studio query designer

Question

0.00/5 (No votes)

See more:

Anybody knows how to add a named parameter in to query when using Visual Studio Query Builder(Graphically-Not by using vb.net command).

I know about parameter using ? symbol, but with this method I'll have to pass in the same value repeatedly for each column that i have to compare the value with.

The database I'm using is of Access 2013.

What I have tried:

As I was trying to crate a query using Query Builder with @keyword inside filter column it automatically change the expression in to " ='@keyword' "

Posted 11-Nov-18 1:32am

Member 14000611

Updated 11-Nov-18 6:11am

Add a Solution

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)

Dave Kreskowiak · Answer 1 · 2018-11-11T06:11:00

The problem is that you can't used named parameters with an Access database in the query designer. Access databases need more SQL code than the designer will generate to support named parameters.

Without this extra SQL code, Access reverts to positional parameters, meaning the parameter values you pass in must in the order that the parameters appear in the resulting SQL query.

If you're trying to just pass a single named parameter and reuse that parameter multiple times in the query, it's not going to work.

Seriously, nobody who writes code for a living uses the designers. They're too limiting and hide the details of what's really going on behind the scenes.