Project Description
This is a basic web site written in ASP and VB (.net 3.5) that allows students and other learners to test SQL queries on a database that is hosted online. It's set up in such a way that other hosted databases can be connected to it quickly, with the user able to switch between databases with a dropdownlist control. I included instructions on how to add another database in comments and examples within the VB code. The interface is basically just a simple textbox, dropdownlist and error message label, but it does give useful feedback from the SQL error handler, and I've also set it up so that you can attach a convenient database diagram for each database you connect to it, so that users can figure out their join syntax by looking at the diagram. (See demo link below.)

This is primarily intended for use in learning SQL syntax and testing queries for homework assignments, etc. Primary downloaders will be instructors and educators looking to enhance their classroom experience. But I image it could also be useful in certain team support and development scenarios. I don't intend to spend a lot of time developing new versions or anything, this was just something I banged out quickly between other projects, but if you have any comments please feel free to leave them here or email me, and I may update it at some point in the future. Enjoy. :-)

Note:
This project does not include the Northwind and Pubs databases that it is set up to run on by default. You'll need to download those separately and drop them into the App_Data folder for this to work as written. It's really intended to be used to query your own databases (using your own connection string), but I've set up a demo at the URL below so you can see how it works.

If you're wondering why I wrote this, it's to support our lower-level SQL classes, not our .NET programming courses. But I imagine it might be handy for a number of things. A good instructor can never have too many tools! :-)

Demo:
http://www.aiuasp.net/QueryTester/


Where I teach (come visit us!):

http://www.aiufl.edu

Last edited Jul 14, 2008 at 8:09 AM by PatFrank, version 15