如何通过指定字段从UI动态创建查询 [英] How to dynamically Create Queries From UI by Specifying Fields

问题描述

Haii Senior ..


我的要求是基于来自UI的输入创建查询.允许用户通过仅指定字段名称进行搜索.对于任何只需要初始配置的数据库，此搜索将充当常规搜索选项.

为此，我还应使用其他什么工具..IE，所有工具都可以帮助我做到这一点..


谁能帮我...

谢谢你...

Haii Senior..


My requirement is to Create Queries Based On input From UI.User is allowed to Search by specifying only field names. This Search will act as a general search option For any databases which requires only initial Configuration.

What else should i use for this purpose..IE which all tools will help me Doing this..


Can anybody help me ...

Thank u...

推荐答案

通过字段名，我假设您的UI向用户显示列名或别名.如果用户选择一个字段并指定一个值，则他/她可以基于该表搜索表.

您可以为此使用动态sql.

http://www.benkotips.com/pages/DynamicSQL.aspx [

By field names I assume your UI displays the column names or their aliases to the user. If a user select a field and specifies a value, he/she can search a table based on that.

You can use dynamic sql for that.

http://www.benkotips.com/pages/DynamicSQL.aspx[^]

我不了解任何此类工具.我的意思是，您可以动态创建查询.

I lack the knowledge of any such tools. What I meant was, that you can create the queries dynamically.

这篇关于如何通过指定字段从UI动态创建查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！