SQL VB ASP Code Generator  ...by NewRAD

SQL VB ASP Code Generator is a powerful multi-purpose tool that lets you effortlessly generate SQL, VB and ASP Code. You can even generate an entire VB application or ASP web application, all derived from the tables in your database with just one click.

Click here to buy == >      Only $199   

It pays for itself the first time you use it to generate an entire VB or ASP application with one click.

No more recreating the same old SELECT, INSERT, UPDATE, and DELETE SQL queries and then having to string them all together in VB or ASP, and then tie in all the hooks that update the user interface. No more time wasted redundantly building the same old edit and grid list screens with all the error handling� Generate a complete or partial VB or ASP app with one click, or simply generate VB forms or .asp files for a single table. It even handles relational lookup fields and fills combo boxes with lookup field data when building edit screens in VB. For building your specific custom queries, there is a point-and-click main screen for building SQL queries manually that makes it easy. No more remembering field names, table names� and much less typing!  ...and much quicker.

Click Here to Download==>   SQL VB ASP Code Generator.msi    Version 4.0.000  ....4.7 MB  

Make sure you Windows language setting are set to English before running it.. This can be done easily in the Control Panel under Regional and Language Settings.

Here's a sample VB application with source code that was derived from an Access database and created with one click. SampleVBApp.zip 

Here's a sample ASP web application that was derived from an Access database and created with one click. SampleASPApp

(The database on the ASP app is currently write protected, so you cannot save or delete records with the SampleASPApp)

The VB code generated is designed for VB 6.0 and ADO.  The ASP Code is ASP 2.0, designed for the same Visual Studio 6 Suite of tools. In the future we hope to add VB.NET and ASP.NET code generation. The program is designed for a 1024 X 768 screen resolution (or greater). It works on Windows 95/98/ME/2000/NT/XP.  The program can access and generate SQL with ANY ODBC database. However, for generating VB and ASP code and applications, the program works best with Microsoft Access and Microsoft SQL Server.

 

SQL VB ASP Code Generator is a powerful collection of tools with many different modes of usage:

As a VB Generator...

 

Generate an entire VB application derived from selected database tables with a few clicks.

Imagine generating every VB form you need for every table in your database with one click.  All you have to do is point to a database and click.  Then just kick back while the generator produces a new VB Project with all of necessary VB forms and VB code that you need to SELECT, LIST, ADD, EDIT, DELETE, and PRINT records for each table in your database.  It produces easy-to-read, error-free VB code that is easy to modify, even for a VB beginner.  It generates all of the necessary embedded SQL statements and VB code, with error trapping on each subroutine.  Error trapping is conditional so it can be globally turned off to make future debugging easier when modifying the generated code.  The generator can design all of your forms based on your data model and data without you having to do a thing. However, you can over-ride many of the generator's defaults to tailor your forms to your situation.

It has many luxurious features that you might not expect, but that can make your life much easier...

It handles relational lookup fields and displays them in dropdown combo boxes. Boolean fields default to check boxes.  It analyzes your data to determine the necessary text box and combo box widths which can be overridden to a fixed width.  All the objects on the form are perfectly centered.  It even looks for "line feeds" in your data in order to determine if a text box's multiline property should be set to "True".  If a field name contains the word "password" it assumes it is a password type of field and will set the PasswordChar property of the text box to "*". 

Generate VB code functions

Sometimes you don't want to generate an entire application. You might just want pieces of VB code to do a specific database function. For example, you might just need a Select function that retrieves a VB recordset and then fills variables (or text boxes) for all of the fields for a given table. The VB Code Functions menu lets you generate VB code containing SQL that will Selete, Insert, Update, or Select and fill a grid for a given table.

 

As an SQL Generator...

Generate SQL Queries Automatically You can automatically generate SQL for Select, Insert, Update, and Delete queries for a given table/field. You can even automatically generate a multi-table Select statement that retrieves all the lookup fields in the other tables based on the "ID field" in the main table, and it does all the necessary joins.  There are also menu items for generating SQL to help you Add or Drop a table or field. For the really common SQL tasks like Select, Count, Count By [field], or Count By [field] Descending, there are four hot buttons handle those operations with a single click.

Generate SQL Queries Manually  using a Point-and-Click interface.  For custom queries that need to be created by hand, there is a point-and-click main screen that shows all the tables, fields, SQL commands and operators. Simply click on the SQL commands, fields, tables, etc. and build your custom query with ease. ...and much faster than without this product. 

Automatically copy and paste SQL to and from VB (or ASP).   When your are finished building your SQL query, you can click on the "Copy SQL To VB" button and it will automatically convert the SQL to "SQL embedded in VB code" ready to paste into your custom VB application. 

No more remembering or typing field names, table names, SQL commands and operators, etc.

Much Less Typing!!!

No Learning Curve. Point to a database, click and go.

Store Your SQL Queries and Results  for a given session for later retrieval.

Print SQL Queries and Results

 

As an ASP Generator...

Generate an entire ASP web-based application derived from your database tables with a few clicks. 

When you run the newly created ASP application, it will display a main HTML page with a link for each table in your database. Click on a link for a given table and the ASP app will display a list of records for that table, with Add, Edit, Delete links for each record. Edit a record, delete one, add a new record, etc. It's all there. All generated with one click. 

As an HTML Generator...

Generate HTML files for data input screens for all the fields in a given table. Generally, this would only be used when you do not want to generate an entire ASP application to handle the back-end of processing the data a user enters in to the html page. Maybe you need to interface with another website and they are handling the back-end.

 

Other Features....

Text Parser Tool

The Text Parser Tool is very powerful and incredibly handy. It has a lot of different features and can be used in a lot of different situations.It is mainly made to parse data out of a text file. That is, to pull a list of substrings out of a list of strings. It can also add data or delete data to each line of text. It can do a "Search and Replace".  It can add line numbers to your text.  It can even "Flip Sides of Equal Sign" which can sometimes be handy with VB code. 

The Text Parser Tool is particularly handy for parsing out HTML source code from a web page. For example, say you wanted to get a list of all the URL links out of a web page. You would just have it remove everything to the left of "http://" and then from "> to the right of the line (or to the left or right, inclusive or exclusive, for whatever text you enter).  Parsing out HTML source code from a web page is a very common use.  Another use would be getting a list of objects, say jpg files, from a website's HTML source code. The size of text is limited to 32K by the limits of the VB text box control.

This tool eliminates the inhumane repetitive manual tasks needed to be done when parsing text by hand.

 

Password Vault

Store passwords in an encryped text file .

These days, a person might have 20 different websites or databases that they access, each with a different user login and password. To log on to a website or database, the user has to remember the website/URL or database name, the user login, and the password. And then type it all in perfectly, sometimes in 3 three times or less, or it might lock you out of the system until your password is reset. It all adds up to a bunch of energy, memory, and stress that needs to be eliminated. Password Vault eliminates all of that.

Password Vault is great for keeping all your user logins and passwords in one safe place.  It takes all the stress out of remembering all of your website URLs, database names, user logins, and passwords.  With the Password Vault you only have to remember one password. That's it!  It frees up all that RAM in your head, and even better, you can relax. No more worrying about forgetting how to access your data, and no more worrying about someone else getting into your secure data because the passwords were written down somewhere, or on your hard drive, but not encrypted.  Another benefit is that you can copy and paste your user logins and passwords so you do not have to type them, or worry about typing them incorrectly.

There is no back door, so if you forget your password, then you cannot access your encrypted text. But at least now you only have to remember one password that lets you read your encrypted text file.  Size of the decrypted text is limited to 32K by the limits of the VB text box control.  It uses very strong unbreakable encryption.

Extras Included....

Voice Email Program:  Big Voice Email  (Free Version) (for promotional purposes).

Generic Calculator and NotePad programs for slightly quicker access than finding them in Windows Accessories.

If you are an SQL and/or VB programmer, this may become your favorite and most relied upon development tool. This program is especially useful for consultants who have to learn databases quickly, and create a bunch of queries quickly to do so.  

SQL VB Code Generator allows you to create queries at blazing speeds, execute them, and then page back and forth quickly between queries so you can quickly analyze the data.  You can then print your SQL queries and results, or store them for later recall.  

You can also automatically generate Visual Basic code from the SQL you click to create. And then copy and paste the SQL back and forth to and from VB. So your SQL strings in VB are automatically written for you when pasting to VB, and automatically parsed out to leave pure SQL for pasting back into SQL VB Code Generator for more testing and development. 

But what's really impressive is that you can also generate an entire VB application derived from the tables in your database, with just a few clicks.  It will even generate an entire ASP web application derived from the tables in your database.  Of course it will not produce a complex custom app, but it can eliminate about 90% of all the repetitive mundane task in VB and ASP.  It can certainly handle all of your forms for your application's "Code/Description" support tables and many of your other tables that just need forms that do straight-foward data capture. 

It speeds up your development time by light years and takes the drudgery out of programming.

There is no need to let your boss or fellow programmers at work know you have this program.  ;)

SQLVB ASP Code Generator can display up to 100 rows of your query results. We may increase this in the future but large queries would take up a lot of memory and slow things down. The real focus of this program is to create SQL queries quickly and move between lots of queries quickly.  It was built by and for consultants who have to learn their customer's data quickly, churn out hundreds of SQL queries, and build applications at warp speed.  Speed is what SQLVB Code Generator is all about.

You can change the case of all elements (table names, field names, etc.) to upper or lower case to match the style of any existing code.

You can copy your query results in the grid to an Excel spreadsheet (tab delimited) or to a text file with fixed-width columns.

You can filter which tables in a database you want to see.

Quickly create and excute regular "SELECT" queries, or action queries like INSERT, DELETE, CREATE TABLE, etc.

Use "built-in" SQL queries to create common, recurring SQL queries with one click.nbsp; 

SQLVB ASP Code Generator takes the work out of programming SQL and VB Code.

 

Main Screen:

The user can simply click on the database tables and fields, and SQL commands, etc., and quickly build a query without spelling errors. Or for certain basic queries such as list, count, or descending count, the user can just select the desired table and field and then select from an assortment of pre-programmed queries.  The very common "descending count" query below was created by selecting the desired table and field, and then clicking on the "Desc Count" button.  

Functionality limitations : The Free Version has exactly the same features as the licensed version, except you can only view the VB code generated from your tables and you cannot generate entire ASP apps.  You CAN, however, generate entire VB apps but they are compiled and the source is deleted.  The source code is also made unreadable before compiling to protect it. You can also convert SQL code to VB code with the free version. 

The free version is great for creating and auto-generating SQL queries, quickly paging through different queries and the resulting recordsets, and converting SQL to VB code with a single click. You never really even have to buy it.  But we hope you will find it so indespensible that you will. 

Plus if you buy it, you can automatically generate VB code and ASP code to build entire applications at ridiculous speeds.

 

Purchasing SQL VB ASP Code Generator

For immediate activation, click on the "Buy Now" button to purchase it with your credit card through a secured connection at PayPal .  That will create a software license for you in our database referencing your PayPal email address.

...after purchasing it...

To activate your copy...

Run the program, click on the "Support" menu, then click the "Activate License" menu item. Then type in your email address for PayPal.  The program will contact our server to look for an unused license that matches your PayPal email address. If it finds it, it will activate your license and you will have full functionality.

Click here to buy == >      Only $199   

 

Additional Screen Shots  

(Be sure to check out the examples of SQL and VB code generated below.) 

 

Using SQL VB ASP Code Generator

Easy as 1-2-3.

1. First Open a Database

SQL VB ASP Code Generator is layed out to show from left to right list boxes with your databases, tables, and fields, and then SQL commands and operators, etc. 

When running SQL VB Code Generator, it should automatically display a database list on the far left list box.  If you have any 32-Bit ODBC Data Source Names (DSN's) already set up on your PC then they should be in the list.  There are also ODBC Database Drivers in the list  that can be clicked on.  For example, you should see "Microsoft Access Database" in the list. If you click on that and then point to an MS Access database ".mdb" file, then it will display the tables for that database.  If you want to select an Access database for which there is not an ODBC DSN set up for already,

2. Click on SQL commands, databases, tables, and fields to create an SQL statement.

When you double-click at database, it displays the tables in that database. When you double-click a table, it displays the fields in that table.  From there, just start clicking on SQL commands, fields, tables, etc. until your query is built.  Or you can use some of the built-in SQL query generators for some of the repetitive simple queries like list records, or get a "group count by". 

3. Click on "Execute SQL" button

When you finish building your SQL statement in the main text box, then click the "Execute SQL" button.

If it is an action query like "INSERT, UPDATE, or DELETE", then it will display the number of records affected in the grid below.

If it is a regular query like a SELECT or SELECT COUNT(*), it will display the recordset results, complete with field headings, in the grid. 

You can right-click on the grid to copy the selected cells to an Excel spreadsheet (columns are tab-delimited), or a text file (like with NotePad), with fixed-widths for each column, for displaying with a fixed-width font, like Courier.

 

Advanced Features

Copy SQL to VB Code

Now that you have created an SQL statement in the text box, you can hit the "Copy SQL to VB" button and it will automatically convert it to a VB string and copy it to the clipboard so it is all ready for pasting into the VB program you are creating. 

For example, if you create the following query:

SELECT State, Count(*)
FROM Publishers
GROUP BY State
ORDER BY Count(*) DESC

Then click on the "Copy SQL to VB" button and the following code:

strSQL = "SELECT State, Count(*) "
strSQL = strSQL & "FROM Publishers "
strSQL = strSQL & "GROUP BY State "
strSQL = strSQL & "ORDER BY Count(*) DESC "

...will be copied to the Windows clipboard ready for you to paste into your VB program.

 

...and yes, you can do reverse.

Paste From VB Code To SQL

Say you need to debug an SQL query inside your VB code.  If the SQL string inside your VB code is in the format below, simply copy that VB code to the clipboard.

strSQL = "SELECT State, Count(*) "
strSQL = strSQL & "FROM Publishers "
strSQL = strSQL & "GROUP BY State "
strSQL = strSQL & "ORDER BY Count(*) DESC "

Then click on the "Paste From VB Code To SQL" menu item under the Edit menu and the following code:

SELECT State, Count(*)
FROM Publishers
GROUP BY State
ORDER BY Count(*) DESC

...will be pasted into the SQL text box in the SQL VB Code Generator program.

Now you can modify and test the SQL string in the convenience of the SQL VB Code Generator environment.  When you have the SQL query debugged, simply click on the "Copy SQL to VB" button and it will convert it back to VB and copy it to the clipboard, ready for pasting into the VB program you are working on. 

This back and forth copy and paste ability can save you a ton of time.

 

SQL Generators

A "generator" is what we are basically calling a button or menu item you click on and code will be created (or generated) based on the table and field that are selected in the list boxes. Currently, the following simple SQL generators are the only ones, but more will be added soon. 

List Records - lists the first 100 records in the selected table.

SELECT TOP 100 *
FROM Publishers

Count - gives the record count in the selected table.

SELECT Count(*)
FROM Publishers

Count By - gives the record count grouped by the selected field on the selected table.

SELECT State, Count(*)
FROM Publishers
GROUP BY State
ORDER BY State

Count By Desc - gives the record count grouped by the selected field but displayed in descending order.

SELECT State, Count(*)
FROM Publishers
GROUP BY State
ORDER BY Count(*) DESC

 

VB Code Generators

The same examples below of VB code generated may be better viewed here as a text file with a fixed-width courier font:

View Examples of VB Code Generated  (fixed with courier font)

 

Select - Creates a Select query to select a record from the selected table, based on the field selected, in this case the field PubID, and then fills a visual basic form with the results. The text boxes should have the same name as each field in the table but with a "txt" prefix.  For example: the data "Address" field in the database would get inserted into the in the text box named "txtAddress" on a VB form .           

            strSQL = "SELECT * FROM Publishers "
            strSQL = strSQL & "WHERE PubID = " & gPubID

            strSQL = strSQL & "ORDER BY PubID

            gRS.Open strSQL, gDb

            If Not gRS.EOF Then

                        gRS.MoveFirst

                        txtName = gRS("Name")

                        txtCompany Name = gRS("Company Name")

                        txtAddress = gRS("Address")

                        txtCity = gRS("City")

                        txtState = gRS("State")

                        txtZip = gRS("Zip")

                        txtTelephone = gRS("Telephone")

                        txtFax = gRS("Fax")

                        txtComments = gRS("Comments")

            End If 

            Set gRS = Nothing

 

Insert - Creates an Insert query that inserts a record into the selected table and then fills the record with values from text boxes on a visual basic form.  

                strSQL = "INSERT INTO Publishers(Name, [Company Name], Address, City, State, "

                strSQL = strSQL & "VALUES ("

                strSQL = strSQL & "'" & Pad(txtName) & "', '" & Pad(txtCompany Name) & "', '" & Pad(txtAddress) & "', "

                strSQL = strSQL & "'" & Pad(txtCity) & "', '" & Pad(txtState) & "', '" & Pad(txtZip) & "', "

                strSQL = strSQL & "'" & Pad(txtTelephone) & "', '" & Pad(txtFax) & "', '" & Pad(txtComments) & "') "

                strSQL = StringReplace(strSQL, "'',", "Null,")

                strSQL = StringReplace(strSQL, "'')", "Null,")

                gDb.Execute strSQL

 

Update - Creates an Update query that updates a record in the selected table and then fills the record with values from text boxes on a visual basic form.  

                strSQL = "UPDATE Publishers SET "

                strSQL = strSQL & "Name = '" & Pad(txtName) & "', Company Name = '" & Pad(txtCompany Name) & "', "

                strSQL = strSQL & "Address = '" & Pad(txtAddress) & "', City = '" & Pad(txtCity) & "', "

                strSQL = strSQL & "State = '" & Pad(txtState) & "', Zip = '" & Pad(txtZip) & "', "

                strSQL = strSQL & "Telephone = '" & Pad(txtTelephone) & "', Fax = '" & Pad(txtFax) & "', "

                strSQL = strSQL & "Comments = '" & Pad(txtComments) & "' "

                strSQL = strSQL & "WHERE PubID = " & gPubID

                strSQL = StringReplace(strSQL, "'',", "Null,")

                strSQL = StringReplace(strSQL, "'' ", "Null ")

      gDb.Execute strSQL

 

Insert / Update creates code typically underneath a "Save" button on an Add/Edit VB Form.  If in "Add Mode" then it will do an Insert into the table.  If the user is in "Edit Mode" instead, then the code will Update the existing record based on the field selected, in this case "PubID".

                On Error GoTo ErrorSave

                OpenConnection App.Path & "\" & App.Title & ".mdb

                If gAddMode = True Then

                                strSQL = "INSERT INTO Publishers(Name, [Company Name], Address, City, State, "

                                strSQL = strSQL & "VALUES ("

                                strSQL = strSQL & "'" & Pad(txtName) & "', '" & Pad(txtCompany Name) & "', '" & Pad(txtAddress) & "', "

                                strSQL = strSQL & "'" & Pad(txtCity) & "', '" & Pad(txtState) & "', '" & Pad(txtZip) & "', "

                                strSQL = strSQL & "'" & Pad(txtTelephone) & "', '" & Pad(txtFax) & "', '" & Pad(txtComments) & "') "

                                strSQL = StringReplace(strSQL, "'',", "Null,")

                                strSQL = StringReplace(strSQL, "'')", "Null,")

                                gDb.Execute strSQL

                Else

                                strSQL = "UPDATE Publishers SET "

                                strSQL = strSQL & "Name = '" & Pad(txtName) & "', Company Name = '" & Pad(txtCompany Name) & "', "

                                strSQL = strSQL & "Address = '" & Pad(txtAddress) & "', City = '" & Pad(txtCity) & "', "

                                strSQL = strSQL & "State = '" & Pad(txtState) & "', Zip = '" & Pad(txtZip) & "', "

                                strSQL = strSQL & "Telephone = '" & Pad(txtTelephone) & "', Fax = '" & Pad(txtFax) & "', "

                                strSQL = strSQL & "Comments = '" & Pad(txtComments) & "' "

                                strSQL = strSQL & "WHERE PubID = " & gPubID

                                strSQL = StringReplace(strSQL, "'',", "Null,")

                                strSQL = StringReplace(strSQL, "'' ", "Null ")

                                gDb.Execute strSQL

                End If

                CloseDb

                frmList.FillGrid

                Unload Me

                Set frmAddEdit = Nothing

ResumeSave:

                Exit Sub:

ErrorSave:

                MsgBox "Error No: " & Err & " " & Error

                Resume ResumeSave

                Resume 0

 

FillGrid - Creates a Select query based on the table selected in the list box, and then creates the additional VB code needed to fill the grid with queries results.               

On Error GoTo ErrorFillGrid

                CenterForm Me

               

                OpenConnection App.Path & "\" & App.Title & ".mdb

               

                strSQL = "SELECT * FROM Publishers "

                strSQL = strSQL & "ORDER BY PubID

                gRS.Open strSQL, gDb

                Grid1.Cols = gRS.Fields.Count

                If Not gRS.EOF Then

                                gRS.MoveFirst

                                Grid1.Rows = gRS.RecordCount + 1

                                Grid1.Row = 1

                                Grid1.Col = 0

                                Grid1.RowSel = Grid1.Rows - 1

                                Grid1.ColSel = gRS.Fields.Count - 1

                                Grid1.Clip = StringReplace(gRS.GetString, Chr(13) & Chr(10), "")

                End If

               

                For N = 0 to gRS.Fields.Count - 1

                                Grid1.TextMatrix(0, N) = gRS.Fields(N).Name

                Next

               

                Grid1.ColWidth(0) = 800

                Grid1.ColWidth(1) = 4000

                Grid1.ColWidth(2) = 4000

                Grid1.ColWidth(3) = 4000

                Grid1.ColWidth(4) = 4000

                Grid1.ColWidth(5) = 4000

                Grid1.ColWidth(6) = 4000

                Grid1.ColWidth(7) = 4000

                Grid1.ColWidth(8) = 4000

                Grid1.ColWidth(9) = 4000

               

                For N = 0 To Grid1.Cols - 1

                                Grid1.ColAlignment(N) = flexAlignLeftCenter

                Next

               

                Grid1.AllowUserResizing = flexResizeColumns

               

                Set gRS = Nothing

                CloseDb

               

ResumeFillGrid:

                Exit Sub:

ErrorFillGrid:

                MsgBox "Error No: " & Err & " " & Error

                Resume ResumeFillGrid

                Resume 0

Support

For Installation Instructions, etc., click here for Support

 Have questions?    Contact Us

newrad.com