Answered by:
A Good Book

Question
-
Hi,
I am new to VB.Net and am of a generation that prefers books to browsing the net. My specific interest is building data centric applications i e applications with a windows front end and a database back end, either in Access or SQL. My existing programming languages are VB6 and SQL. I have access to Visual Studio 2005 and 2010, and have found the former more reliable so far.
Could someone please recommend a book that will give me worked examples of the various data tools packaged with visual studio. i have already bought books that show me how to access and manipulate data using code, but I want to understand the existing toolkit in detail before I go down this route.
thanks
Neil_W
Neil_W- Moved by Cindy Meister MVP Wednesday, April 20, 2011 6:57 AM not vsto-related (From:Visual Studio Tools for Office)
Tuesday, April 19, 2011 7:16 PM
Answers
-
This one is worth a good look:
http://www.amazon.com/Programming-Microsoft-Visual-Basic-Reference/dp/0735613753
- Marked as answer by Liliane Teng Thursday, May 5, 2011 10:56 AM
Wednesday, April 20, 2011 8:55 AM -
Neil,
Who writes about DAO as new is telling fairy tales.
Dao is a connected way of accessing. In this time big solutions are not anymore for 1000 users but for a multiple of that.
Those cannot use the connected way, ADO.Net is the main current provider (not ADO what is a complete different taste more an better way of DAO, but slower).
However, with SQL server the main direction is currently Linq to EF, not that I like it, it is in my opinion not full grown.
The newest one is this one, however look at it, but don't try to understand it direct, you'll get the idea that you become crazy, and you are probably not.
http://msdn.microsoft.com/en-us/data/aa937723
In this forum most persons are dealing with AdoNet in the way as it is done with DataSet, DataTables, DataAdapters and the newest one TableAdapterManager.
You can start with the latest one if you start; the most is done by drag and drop.
http://msdn.microsoft.com/en-us/library/bb384426.aspx
The development about that one is going on in a straight line in a way that it becomes every year better since 2002.
Success
Cor- Marked as answer by Liliane Teng Thursday, May 5, 2011 10:57 AM
Wednesday, April 20, 2011 2:01 PM
All replies
-
Hi Neil
VSTO is a specific technology for creating Office Add-ins or Excel/Word documents with "code-behind". So this is not the right place to be asking your question :-) I'm going to move your message to a VB.NET forum...
Cindy Meister, VSTO/Word MVPWednesday, April 20, 2011 6:56 AM -
Neil,
In the time of VB6 I used books, however, currently there is so much available on Internet while the intelicense in VB (help when you are typing and even automatically suggesting complete sentences if you make mistake or don't know something) that reading a book is not the best way.
In the time of VB6 I once 've read a book which covered completely all that could be done with VB.
That is currently impossible with the newer VB versions.
In VB6 there where not 2 completely different presentation layers for desktop, there where not 3 presentation layers for the web, there where not 5 or more complete different ways to access a database, there was not anything for phone or other mobile device. There was no internet conectivity in the way it is used currently. And much more.
That does not fit in one book.
The VB program language between VB6 and VB10 is not so much changed. (Most that was in VB6 is still in VB10 with some slight chances to do more OOP and to keep things more consistent).
The main difference is however .Net, a kind of uniform way of handling things using the Windows OS systems.
If you want to read something to learn the current environment, then go to the library and find a book which gives you an impression of .Net.
If you know that, then you can forget things as the VB6 IISClass where very quick bugs where not solved for (that IISClass looks very much as a base for Net), recordsets, Ado, Dao and all those in fact all those seperate created ways of doing things.
If you have the basic principle of .Net developing, then forget books and start to read on MSDN, it sometimes takes you by hand in an endless repositry of courses, samples etc.
Success
CorWednesday, April 20, 2011 8:27 AM -
This one is worth a good look:
http://www.amazon.com/Programming-Microsoft-Visual-Basic-Reference/dp/0735613753
- Marked as answer by Liliane Teng Thursday, May 5, 2011 10:56 AM
Wednesday, April 20, 2011 8:55 AM -
Thanks for that Cindy. Given my age and general decrepitude, I get confused with forums, so any steer is helpful.
Neil
Neil_WWednesday, April 20, 2011 10:45 AM -
Hi Cor,
Many thanks for the comprehensive reply. I think the fact that there are so many ways of doing the same thing is one of my problems. I am currently going back to basics with an Access database and Windows front-end, and teetering on the edge of integrating this application with Sage (Accounts software). I will keep you posted on developments, if I may.
Clearly you know what you're talking about. I read recently that ADO was developed by Microsoft as a stopgap pending the release of ASP.Net, and that Microsoft are now tending to go back to DAO technology. Do you have view on this?
Neil
Neil_WWednesday, April 20, 2011 10:51 AM -
Neil,
Who writes about DAO as new is telling fairy tales.
Dao is a connected way of accessing. In this time big solutions are not anymore for 1000 users but for a multiple of that.
Those cannot use the connected way, ADO.Net is the main current provider (not ADO what is a complete different taste more an better way of DAO, but slower).
However, with SQL server the main direction is currently Linq to EF, not that I like it, it is in my opinion not full grown.
The newest one is this one, however look at it, but don't try to understand it direct, you'll get the idea that you become crazy, and you are probably not.
http://msdn.microsoft.com/en-us/data/aa937723
In this forum most persons are dealing with AdoNet in the way as it is done with DataSet, DataTables, DataAdapters and the newest one TableAdapterManager.
You can start with the latest one if you start; the most is done by drag and drop.
http://msdn.microsoft.com/en-us/library/bb384426.aspx
The development about that one is going on in a straight line in a way that it becomes every year better since 2002.
Success
Cor- Marked as answer by Liliane Teng Thursday, May 5, 2011 10:57 AM
Wednesday, April 20, 2011 2:01 PM -
Thanks Cor,
Your crack about going crazy is instantly recognized - how many times have I found myself asking just that question or , even worse, am I just bone stupid. The application is growing apace, but I still doing the easy stuff just now.
Neil
Neil_WWednesday, April 20, 2011 2:32 PM