VB Programing support Access Database Microsoft Office VB.Net & SQL Server nev@NevVB.com.au Sydney, Australia (02) 9453-0456 Contact Details 28/01/2012
Here is a series of questions that provide a background to Visual Basic.Net. The answers highlight the problems and opportunities facing the Visual Basic programmer in using Visual Basic.Net. Note that the number of developers using VB.Net today is roughly the same as for the C# language.
VB.Net is a complete rewrite of Visual Basic 6. The syntax is still almost "Visual Basic" as we know it, but everything else has changed. It now has all the functionality of "C", "C++" or "C#".
VB.Net is not VB6 with some enhancements. It is a completely different Object Oriented language incorporating Encapsulation, Inheritance and Polymorphism. Compatibility with VB6 has been well and truly broken.
Although VB.Net is now Object Oriented, it is still the best language for business-oriented, database management applications. With strict development standards compliance, most of the complexities can be avoided.
Visual Studio.Net incorporates Web projects and Web Services, new areas that need specialisation. ADO.NET is not simply a new Version of ADO, but a complete rewrite. For example, the new printing facility of VB.Net provides enormous power with its functionality (like borders, colours, fonts, etc), but the simplicity of VB6 has been lost.
The latest release, Visual Studio 2010 has many features. Together with Object Orientation, a huge learning curve is involved. It is extremely difficult for the Visual Basic Programming neophyte (and old hands too) to learn everything – especially as VB.Net is so vast and is evolving so rapidly.
The Microsoft Help system, although improved, is not good. There are now Visual Basic examples, instead of only C# examples. There is still too much that is at a low-level and esoteric. Defining how a procedure gets Overloaded in 40 different ways is not my idea of documentation.
Thankfully, there is a very active VB.Net community. The Internet is a great source of information on Visual Basic.Net. The trouble is trying to work out what is current and what has been superseded. Many books on Visual Basic.Net are half-baked, and rushed out to print too quickly.
Visual Basic 2010 with Service Pack 1 is now reasonably stable and acceptable.
The 2010 code improvements, as well as the new functionality, are irrelevant to most Visual Basic Programmers.
Visual Studio 2010 no longer has an Upgrade Wizard – for these reasons:
To get a "clean" version of the code, it is necessary to start a new project from scratch, and use a minimum of the "converted" code.
Microsoft's DataGridView has all the functionality of any third-party software. It is just as easy to use, if not easier.
No, it is not essential to convert to ADO.Net – all the old ADO routines are still available. You should consider the migration to ADO.Net when there is an efficiency problem. That is when:
With the close compatibility with C#, all the new features are getting more and more esoteric. The language is becoming difficult to understand. Visual Basic is no longer the simple programming language that was previously so attractive for business applications.
If tight control of programming standards is not rigorously controlled, the Visual Basic programmers are likely to produce code that is not maintainable. This could prove very costly to a company. The programming standards should include a ban on Object Oriented Programming – besides the encapsulation techniques which are an essential part of Visual Basic programming. The programming standard should also restrict complex or seldom used features.
Maintainability and simplicity go hand in hand.
Visual Studio Installer is still available, but will be discontinued – it has been replaced by the InstallShield LE software. Although the free InstallShield is a Limited Edition, it caters for all the essentials of project deployment. InstallShield is far simpler to use compared to Visual Studio Installer.