ASP.NET SQL Query Tester 1.0

Rating: No reviews yet
Downloads: 864
Released: Jul 10, 2008
Updated: Jul 12, 2008 by PatFrank
Dev status: -not yet defined by owner-

Recommended Download

Source Code ASPQueryTester.zip
source code, 173K, uploaded Jul 10, 2008 - 864 downloads

Release Notes

ASP.NET Query Tester 1.0
by Pat Frank
IT Instructor, American InterContinental University, South Florida
July 10, 2008
Email: pfrank@aiufl.edu
Support: http://www.codeplex.com/sqlquerytester
Demo: http://www.aiuasp.net/QueryTester/
School Web Site: http://www.aiufl.edu

Instructions:
- Extract archive and open as a Web project in Visual Studio 2008
- Adjust connection strings to match locations and security for your online databases
- Upload site to preferred location
- Query 'till the cows come home (for cows, see version 2.0) ;^D

Notes:
- The program is presently set to execute on copies of Northwind and Pubs out
of the App_Data folder, which I did not include because I don't know their
copyright status and they're kinda large anyway. If you drop a Northwind and
Pubs in there, the program will run right out of Visual Studio. Otherwise
you'll have to set the connection strings and upload it to see it work at all.

- Instructions for adding additional databases are given as comment in the
code-behind in default.aspx.vb.

- The way I did the database diagrams was to make them the usual way in Server
Explorer, then zoom in to 100%, then right-click in the white space and select
"copy to clipboard". Then I just went to Paint, pasted, and saved as JPEG.

- Although this project was done in Visual Studio 2008, and it
is set to .NET Framework 3.5, I don't think I used anything that wouldn't
survive a rollback to 2.0 through a target framework change in Properties.
I've not tested this, however, and feedback is welcome.

- If you're wondering why I made 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! :-)

Namasté!

Reviews for this release

No reviews yet for this release.