sql server/vb references

Question

sql server/vb references

achowe

SSCrazy

Points: 2075
More actions
November 17, 2003 at 7:18 am

#176945

Im beginning a project to create a vb application with an sql server back end...does anyone know of any good references/books/websites, preferably with some good worked examples of code etc....
Cheers Guys
If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

johnsonj SSCrazy Points: 2159 More actions · Answer 1

These aren't specifically SQL Server, but I like gotdotnet.com, codeproject.com, and 4guysfromrolla.com -- some interesting articles and info.

I still haven't found a really good book that I like for .NET programming.

Joe Johnson

NETDIO,LLC.

Joe Johnson
NETDIO,LLC.

achowe SSCrazy Points: 2075 More actions · Answer 2

Thought about Vaughns book but ive heard it doesnt have many examples......but this is the only one people keep recommending. Have you have any experience of it?

quote:
Bill Vaughn's Hitchhiker's Guide to Visual Basic and SQL Server[/b] is considered the "bible." If you're using VB.NET, though, try Dobson's Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET.
--Jonathan

If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

Jonathan SSC-Insane Points: 20427 More actions · Answer 3

Bill Vaughn's Hitchhiker's Guide to Visual Basic and SQL Server is considered the "bible." If you're using VB.NET, though, try Dobson's Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET.

--Jonathan

Jonathan SSC-Insane Points: 20427 More actions · Answer 4

quote:
Thought about Vaughns book but ive heard it doesnt have many examples......but this is the only one people keep recommending. Have you have any experience of it?

I have it somewhere. I read it when this stuff was new to me; can't remember being stymied by a lack of examples, though. There are a lot of examples in the ADO online help docs, MS Knowledge Base, MSDN, etc.

--Jonathan

Allan1 SSC-Addicted Points: 446 More actions · Answer 5

I'm assumiing that you're programming with Visual Basic 6.0 (not VB.NET).

Bill Vaughan's book is a good reference. If you are going with ADO, I'd recommend "ADO Programming in Visual Basic 6", by Steven Holzner. Good examples and explanations.

Two other books that I'd recommend are "Pure Visual Basic" (subtitled "A Code-Intensive Premium Reference"), from SAMS [just as advertised]; and "Visual Basic Annotated Archives" (sorry, I don't remember the pubisher). [Examples with detailed explanations for each section of code - which (the code) is usually repeated in the explanation].

On the negative side, all of these books are at least 2-3 years old, so they may be harder to find. On the plus side, they may be cheaper when you do find them. [No, I'm not selling mine! [:-)] ]

Allan

Frank Kalis SSC Guru Points: 111183 More actions · Answer 6

Hi Andrew,

piggy-backing on Jonathan. MSDN has a lot of examples that work with PUBS or NORTHWIND db's. I'm sure you'll find tons and tons of code on the web, but IMHO that's all you need. The rest is practice, practice and practice!

The only book for VB I have is Dan Appleman's 'Guide to the Win32 API', but that's for other reasons..

The only site for VB I'll recommend is http://vbaccelerator.com/home.htm, but that's not suited for a beginner, I guess.

...and, once again, if you got stuck, come back and ask. There is massive VB knowledge here on the forum

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

dbuchan SSCrazy Points: 2328 More actions · Answer 7

Here's some sites I have found useful (remarkably, some of them are Msoft's)

Msoft VB Support Centre: http://support.microsoft.com/default.aspx?scid=fh;EN-AU;vbb

Msoft ADO code examples: http://msdn.microsoft.com/library/en-us/ado270/htm/mdaexamples_vb01.asp

MSoft VB Reference Documentation: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon98/html/vbstartpage.asp

VBNET good examples, How To's: http://www.mvps.org/vbnet/index.html?code/network/

Tips on writing ADO for SQL: http://www.sql-server-performance.com/visual_basic_performance.asp

Cheers,

DB

The systems fine with no users loggged in. Can we keep it that way ?br>