The microsoft ones in thier "Step By Step" Range (they have pictures of tools on the front) are very good, ive used them for C#, SQL, Windows Server.
Get step by step. Its a very good range, for introducing yourself to a language and has excellent source code examples and good writing style.
wrox is the best.
Personally I can't stand any Step By Step book that MS puts out. However, I do like the "Programming ASP.NET 2.0" book from Microsoft Press, and I agree with waterfall-- WROX books ROCK. Professional ASP.NET 2.0 is OUTSTANDING, in my opinion. Both books contain information in VB and C#, and they cover the entire "lifespan" of a page that you develop.