I need an ad hoc query builder similar to the view builder in MS SQL server enterprise manager or MS Access query builder. It must be written in VB.net and not be web based -**NO EXCEPTIONS**-
It should should broken into three (3) parts: a graphical representation of the tables, a SQL statement view, and a grid displaying results. It must be read only and use a disconnected recordset. The graphical builder should be similar to the examples above, i.e drag and drop table fields to create joins.
If you recreate one of the examples above you will satisfy my needs, I prefer SQL enterprise manager (if using access as the model place the grid on the same winform).
**Added 7/24/03 8:15**: To clarify - This is an ad hoc query builder to coincide with another reporting function. It is read only. There will be NO use of insert, update, alter or create. Only the select statement should be supported. The key to this project is the graphical SQL builder. The other two parts are nothing but a text box and a grid bound to the SQL. The graphical SQL builder should use a control similar to a list box to represent tables and fields. You should be able to drag a field from one table to a field on a different table to create a join.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.