I'm a fairly experienced developer - I have spent many years working in a proprietary language (within a commercial ERP package). I am starting a project, for which I am using vb.net. This project is going to be an ERP like application – one that manages a good portion of a businesses activities. Having limited experience with any language except the one I work in (which I cant use for this project), I have spent the last 2 or more months investigating just how I’m going to go about it – reading various books on ado.net, vb.net (and C#, but that is another story) and MS SQL Server 2005 programming. While these books have offered plenty of examples of dealing with specific issues (And there are plenty of examples on the net dealing with specific issues), I’m have not found an example which ties it all together.
This has made my investigations very slow and painful. Every step of the way I’m having to investigate what the best approach is, and how to do it.
This brings me to my question/request. I’m after an example (with source code) of a database application written in vb.net. It doesn’t have to be much – just enough to cover most of the basics which someone is likely to use in a database application, such as:
- Use of a single connection throughout the application (preferably made by the Data Sources interface in visual studio)
- Use of bound forms (both detailed and list), created by the drag-and-drop method (from Data Sources)
- Code querying/updating data in the database
- Error handling/Data validation
- Ability to select the database at run time
If anyone can point me to any such example (Well, one that has a number of these anyway), I’d much appreciate it.