Microsoft provides 101 samples to help you get started with Visual Studio 2005. You can find code projects (in C# / VB) related to different categories: data access, web development, windows forms, Visual Studio Tools for Office (VSTO), tablet PC, and .NET Compact Framework.
===== For more information =====
~ 101 samples for Visual Studio 2005
Bob Beauchemin has just spent a few days in TechEd Hong Kong, giving a few talks on various aspects of SQL Server 2005 and some topics related to .NET development. He has also offered a full-day pre-conference seminar on SQL Server 2005 features like T-SQL enhancements, T-SQL vs SQLCLR, tuning, etc.
To me, the topic about "Next generation data access in .NET application with ADO.NET vNext" is exciting, while Bob has just offered a summary of ADO.NET vNext on his blog "What is ADO.NET vNext anyway?" right after his talk! [;)] More information about ADO.NET vNext can also be found at MSDN "Next-generation data access: making the conceptual level real", while Community Technology Preview is available for download at ADO.NET vNext CTP August 2006.