QBE (Query-By-Example)

[NusPieds]

Hi,

I'm trying to convert an Oracle Forms application to .NET.

The functionality I'm trying to duplicate now is the QBE,
Query By Example. The application has a form which
displays a Table list (i.e., DataGrid) and all the fields
are display-only.

Basically, the user presses a "Build Query" button and the
first row of the Table on the form changes to data-entry
mode for the user to enter query criteria.

For example, assuming my table contains fields Customer
Number, Customer Name, Address, State, Country, the user
can enter "%abc%" in the Name field and "CA" in the State
field. By pressing the "Execute Query" button, the row is
passed to Oracle Forms QBE and it automatically generates
the SQL to select all records with "abc" contained in the
Customer Name AND where the state is California.

The Query result rows are returned back to the data Table
and is displayed automatically. Again, there is no manual
SQL coding for the Query search in the application; Oracle
Forms does it all when it is passed the data-entry row.

Is there similar QBE functionality in .NET or do I have to
programmically build the Query?

Thanks,

NP