VB_Net_Maker creates VB.Net file to access a Data Base (Oracle, Access, SQL Server, other sources) from ASPX pages.
It generates a file containing a class for each table of the Data Base, with Sub class or an arraylist of sub classes for each foreign key, according to the direction of this key, Property for each column of the table, Methods Update, Delete, Search, Insert, Function List which returns Array, Order and Criteria SubClasses. In option, join classes for foreign keys.
Choose one table, and this generator builds a template of Aspx and Aspx.Vb files, with 4 sections: Labels and DropDown Lists for each field of the Primary Key, Form with a label and a text box for each field of the table, and a drop down list for each field associated with a foreign key (n-1), grid for the whole table, with select button, grid for each Foreign Key 1-n. All information is linked together. Buttons Ok (update and insert), Cancel and delete are added with behind code.
VB_Net_Maker includes few complementary tools to help you in the building of your projects.
A Data Browser allow you to browse the contents of each table of your Database, using many criteria, a nice tool which allows you to change the dates and hours of files (For example, you can align all dates of several files at today), a powerfull tool allows you to make many changes in text files with the same extension, in a folder.
These changes are like replace a string by another, add or remove lines with criteria, only count lines with criteria. The count result can be exported into Excel. The changes script is saved. You can also concatenate all files in one. A screen allow you to browse the structure of your Database, regarding ADO Schema criteria. |
