A
A
artashesmelonyan2016-07-24 18:29:55
SQL
artashesmelonyan, 2016-07-24 18:29:55

How to implement the creation of a dynamic query to SQL?

Good evening, can anyone give me a recipe on how to construct a SQL database query by adding elements to a "blank slate". Each element you add corresponds to a specific database field. The fields are interconnected by expressions and/or.
For example: there is a panel of elements: last name, first name, patronymic, age, gender, etc.
The user puts on a "blank sheet"
Surname - Ivanov First
name - Ivan
Patronymic - Ivanovich
Age >30
Gender = M
That is, it is necessary that the user work with queries to the database without knowing the syntax.
I saw something like this, but maybe there is some kind of framework.
Preferably C#

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
artashesmelonyan, 2016-07-24
@artashesmelonyan

Found, FilterEditorControl Class Devexpress, what you need

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question