Wednesday, June 3, 2009

A Master/Detail Design in VB.Net

Here is a link of an article and a source code on how to implement a Master/Detail Form in .Net -

I included a complete documentation on how to design the application. I used a 3rd party control for the project which can be downloaded on this link - http://www.codeproject.com/KB/architecture/MultiColumnFlatCombo.aspx

I hope you can get a grasp with this application for you to make a Master/Detail design on your project in the future.

Happy coding .Net Developers!!!

A project that I developed for a company I previously worked in Dubai, U.A.E.










Here is a project that I developed for a retail company I used to work in Dubai, U.A.E. The project requires a report to consolidate sales from the different retail shop across U.A.E. and other Gulf Countries. I desgined this application in VB.Net as front-end and SQL Server as back-end. Business Objects Crystal Report Designer was used to design the reports. The application involves a sales report by providing details on Daily Sales, MTD, YTD, and a chart and other summary details. It is very complex though but I was still able to design it. I included in the application some charting reports for business analysis. Some of the screenshot of the project is shown above.

The application was designed using 3-tier or n-tier application design that is separating the presention layer or user interface, business logic and data access layer, and the database management layer.
The Advantages/Disadvantages of N-tier Design
The advantages of N-Tier system design are multifold. The list below shows some of the advantages.
1. You can modify the business logic without making changes to either the user interface or the database.
2. If built correctly, the business logic object can be used by multiple user interfaces
3. Isolates the knowledge required in any given tier to that tier
Some of the disadvantages are;
1. The system design is more complex with increase in the line of codes
2. Memory footprint of the application is increased

Davao City....

Davao City, Philippines is one of the coolest and calmest city in the Philippines to live. If you want to live and stay in this city, here is a link of my friend's real estate site of Davao - www.davao-real-estate.com.