Connection Maker

Database command and code generator designed to help you setup your database apps in minutes.  Code is written for you in seconds.

Version 2.0

• Connects to SQL Server 2005 database from any local directory
  • All versions can be connected to locally using a SQL Server Express Instance
• SQL Server Compact 3.5
• Access   (2007 supported in Version 3.0)
• Supports passwords for SQL Server Compact 3.5 and Access
• Generates connection string to current database directory
• Copy generated code and paste into your application
• Writes statements as you select columns from a list
• Writes SELECT , INSERT, UPDATE and DELETE statements simultaneously including where clauses
• Generate connection strings for published applications, including the current and install paths (executable and data directory)
• Generates public variables, objects and subroutines to perform Insert, Update, Delete commands and the following Select queries:
• Fill a datatable with a dataadapter and show in a datagridview
• Fill a datatable with a dataadapter and show in a datagridview with a bindingsource connected to a navigator
• Fill textboxes with a single record using a datareader
• Check for and store user login information using a datareader
• Read records one at a time using a datareader
• Manually fill a datatable and show in a datagridview
• Manually fill a datagridview
• Generates parameters automatically with data types and maximum character lengths to help secure your code agains sql injection and increase performance for caching in SQL Server
• Generates TextBox and Label names to quickly paste into your control properties inside the Visual Basic IDE
• Works in conjunction with the Drag and Drop features of the strongly typed datasets generated automatically inside Visual Basic.  Create your dataset in Visual Basic IDE, drag your Details view textbox controls or Datagridview to your forms from the data sources explorer then paste in your generated Connection Maker code.  Remove the designer generated data objects at the bottom of your form designer screen and the generated code will handle the rest.
• Generated code can be easily modified for your custom needs

 (enalrge)   (enlarge)

Version 3.0

• All the features of version 2.0
• Access 2007
• Excel 97 to 2007
• Supports passwords for SQL Server Compact 3.5, Access and Excel
• Class generation for data subroutines and functions to return data from passed in sql commands for central data handling for your entire application
• Works in conjunction with our online Database Naming Conflit Tool
  • Generate files from your databases to be read by our online tool to be sure your Table and Column Names do not conflict with Data Provider Reserved Keywords
• Generate where clauses with multiple column support
• Seperate tables showing selected and where clause columns in numbered order
• Add or remove individual selected or where clause columns
• Generates parameter placeholders in commands using names, numbers or question marks

 (enlarge)  (enlarge)

NOTE:  This version does not contain all features yet.  SQL commands for all databases can be created.  The main purpose for the early release is to make available the Database Naming Conflict Tool.