Answer the question
In order to leave comments, you need to log in
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
Found, FilterEditorControl Class Devexpress, what you need
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question