问题描述
任何人都知道在使用Visual Studio Query Builder时如何在查询中添加命名参数(图形化 - 不使用vb.net命令)。
我知道关于参数使用?符号,但是使用这种方法,我必须为每个列重复传递相同的值,我必须将值与之比较。
数据库我是使用是访问2013.
我尝试过:
当我尝试使用带有@keyword的查询生成器在过滤器列中创建查询时,它会自动将表达式更改为='@ keyword'
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' "
推荐答案
这篇关于在visual studio查询设计器中创建命名参数查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!