In only three steps save hours: 1. Connect to a SQL Server. 2. Select tha database. 3. If you are starting a proyect or if you have added tables to the database: Click the 'Generate From Tables' TAB Select the tables and press the generate button. DalAddin will include in your active proyect: · A module with data access routines. · A module with COM+ and error handling routines. · References to COM+, Microsoft XML and ADO. · For each table selected it will include a class with the following methods: o ins[TableName](updatable fields). This method executes a store procedure generated by DalAddin wich inserts a record in the table and if the table has an identity column, it returns it as a result. o del[TableName](PrimaryKey or IdentityColumn). This method executes a store procedure generated by DalAddin wich delete a record from the table. o upd[TableName](TableFields). This method executes a store procedure generated by DalAddin wich updates a record searching for it through the PrimaryKey or IdentityColumn and returns the amount of updated records (1 if it was found or 0 if it was not found). o GetAll(). This method executes a store procedure generated by DalAddin wich returns all the records. o Get[TableName]( PrimaryKey or IdentityColumn). This method executes a store procedure generated by DalAddin wich returns a record looking for it thruogh the primary key or identity column. o Get[TableName]By[KeyColumns]( KeyColumns). It generates a method for each foreign key and another one for each field of the key. o Get[TableName]By[IndexColumns]( KeyColumns). It generates a method for each index. If it is an already started project and you need to add a data method. Click the 'Generate From Tables' TAB Select a Store Procedure and press: · Generate DAL Method Return RS if the store procedure is a select. You will obtain the code of the method to call that Store Procedure. · Generate DAL Method Return Int you will obtain the code of the method to call that Store Procedure. If the Store Procedure has an output parameter it returs it, if not it returns the amount of records affected by the Store Procedure. · Generate BUS Method Return RS. You will obtain the code of the method to call to the routine of the data layer wich executes the Store Procedure. · Generate BUS Method Return Int. You will obtain the code of the method to call to the routine of the data layer wich executes the Store Procedure.
Small, customizable, feature-packed application installer for DOS. The install executable takes only about 70k on disk. The author can customize the installer by simply editing an INI file; there are no scripts to learn. Features include the abil...
Include Barcode ,DBBarcode, QRBarcode and QRDBarcode, Create, view and print barcodes for your applications as easy as typing the code. Simply enter the desired characters and select the type. The barcode will be created!