Deutsch


CodeGenerator xp

Productivity tool for Multitier-Applications with Visual Basic 6.0, COM+, SQL Server 7 / 2000
 


How to setup the demo-project

1. Extract Zip

Download the DemoProject.zip-File and extract it to a directory of your choise. The .zip-file contents are splitted in the following directories:

  Client\ VB6 client using the CodeGenerator XP code
  Client\Include\ Compiled version
  Client\Resources\ Icon of VB6 sample
  Component\ Business Layer Component generated with CodeGenerator XP
  Component\Include\ Compiled Version
  Database\ SQL Server 2000 Database generated with CodeGenerator XP

2. Restore the Database

Open the SQL Server Management Console, navigate to your SQL Server, right click on 'Databases' and choose 'All Tasks', 'Restore Database'. Then, follow the instructions on screen to restore the media 'PersonenDB' of the Database\-Directory.

Note, that you only have to declare the fields of 'TPersonen'. All the rest (Triggers and Stored Procedures) are entirely generated by CodeGenerator XP. In the supplied database, everything is already done for you.

3. Change the Business Layer Component to connect to your server

Open the project named 'ipsPersonen.vbp' in the Component\-Directory. Change the 'Data Source=ipsDB'-Statement in 'fnConnection.sGetConnectionString'. Insert your servername in place of 'ipsDB' and recompile 'ipsPersonen.dll'.

Note, that all code in 'General.cls' is generated entirely by CodeGenerator XP based on the definitions of the Stored Procedures in the 'Personen'-Database. It is simple, to move your Business Layer Component to a COM+-Server now!

4. Use the Client to test your application

 Load the 'Personen.vbp' in the
Client\-Directory and run it. The client demonstates the use of your generated Business- and Database-Layer.

 

Conclusion

 Everything you have to do in your multitier application, is:

  • Design your Database Tables

  • Generate the Triggers and Stored Procedures with CodeGenerator XP

  • Generate your Business Layer Component with CodeGenerator XP

  • Use the Business Layer Component in your VB- or ASP-Client

See how easy developing complex applications is now?

 

Screenshots?

Click here, to find out, how you use CodeGenerator XP.

 

CodeGenerator xp

You'll find the CodeGenerator XP in selected stores or from iPS & Co. starting
from Sfr. 69.-[1]

To buy CodeGenerator XP, just write sales@inlive.org.
 

  


 

[1]
  
Single workstation licence (1 licence) Sfr. 99.-
   Multi workstation licences (2 – 5
licences) Sfr. 89.- / licence
  
Multi workstation licences (6 – 10 licences) Sfr. 79.- / licence
  
Multi workstation licences (>= 11 licences) Sfr. 69.- / licence

back / zurueck