A Visual SQL Query Designer (Code project)

A Visual SQL Query Designer (Code Project)

If some of your customers asks you to gain access to SQL data directly from NAV (as other systems with integrated query editors..) can use this nice tool to run SQL queries (or others T-SQL statements…).
This tools recalls some typical features of SQL Studio Management studio like Visual SQL Query Designer; currently is available in 2 releases (VB.NET and C #), i tested the C# solution that works well.

Tool is under “CPOL Licence”

“Source Code can be modified to create derivative works”, …  you can modify the solution’s source to create derivates. For example you can create a class for NAV .NET integration or create an addin for RTC Client, the tool also can be used directly by calling him from Wshell in NAV (.EXE); you can however also pilot the numbers of records extracted etc. etc. .. nice tool anyway.

Tool features

“This article describes the implementation of a QueryDesignerDialog class that allows users to create SQL queries based on a given OLEDB connection string.

Code Download

• Download demo project – 47.7 KB
• Download source (C#) – 83.7 KB
• Download source (VB) – 79.8 KB

Source http://www.codeproject.com/Articles/43171/A-Visual-SQL-Query-Designer