logo JavaScript Menu

DalAddin

Author: ARSoft

DalAddin 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.
..

download buy



Related:
Search:

JavaScript Menu
Deluxe Menu


Bootstrap Progress bar Animation
Bootstrap Slider Template
Bootstrap Clearfix Grid
Bootstrap Label Input
Bootstrap Header Styles
Bootstrap Switch Working

New generation of DHTML & JavaScript Menus!
Download JavaScript Menu Deluxe! * Truly cross-browser
* Cross-frame
* CSS support
* Cool styles and effects
* Support for keystrokes
* Movable and floating

Download! Buy Now!


Vista Web Buttons & Menus


Create superior Vista/XP/Mac-style web buttons and menus in a few clicks!
XP Web Buttons
Download! Buy Now!


DVD-Cloner


A super easy and power ripper software to copy dvd movies to dvd-r, dvd-rw ,dvd+r, dvd+rw, dvd-ra...

download buy

ImTOO DVD Ripper


ImTOO DVD Ripper is a DVD ripping tool easy to use with high ripping speed. It can backup your fa...

download buy

WinTasks 5 Professional


Most computers users are willing to spend hundreds of dollars on expensive hardware to get a syst...

download buy