Dotnetcat » .NET Books » Visual Studio books

Description: Code - The Leading Independent .Net Magazine
Table of Contents:
*) So You Want to Be a Consultant: Risk Management
*) Privacy and the Application Developer
*) Is SharePoint Scalable or Not?
*) PostMortem: A Large Mission-Critical Educational System
*) Practical Messaging Scenarios with WCF 4
*) Incorporating ASP.NET MVC and SQL Server Reporting Services, Part 1
*) ASP.NET MVC & the ADO.NET Entity Framework
*) The Baker’s Dozen: 13 More Examples of Functionality in SQL Server 2008 Integration Services
*) Add Some Spark to Your OData: Creating and Consuming Data Services with Visual Studio and Excel 2010
*) Composite Application Library (Prism) and Silverlight
*) Ask the Doc Detective
*) Managed Coder: The Alphabet of Software Design
For more information, visit www.codemag.com

“As Excel applications become more complex and the Windows development platform more powerful, Excel developers need books like this to help them evolve their solutions to the next level of sophistication. Professional Excel Development is a book for developers who want to build powerful, state-of-the-art Excel applications using the latest Microsoft technologies.”

–Gabhan Berry, Program Manager, Excel Programmability, Microsoft

“The first edition of Professional Excel Development is my most-consulted and most-recommended book on Office development. The second edition expands both the depth and range. It shines because it takes every issue one step further than you expect. The book relies on the authors’ current, real-world experience to cover not only how a feature works, but also the practical implications of using it in professional work.”

–Shauna Kelly, Director, Thendara Green

“This book illustrates techniques that will result in well-designed, robust, and maintainable Excel-based applications. The authors’ advice comes from decades of solid experience of designing and building applications. The practicality of the methods is well illustrated by the example timesheet application that is developed step-by-step through the book. Every serious Excel developer should read this and learn from it. I did.”

–Bill Manville, Application Developer, Bill Manville Associates

The Start-to-Finish Guide to Building State-of-the-Art Solutions with Excel 2007

In this book, four world-class Microsoft® Excel developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors—three of whom have been honored by Microsoft as Excel Most Valuable Professionals (MVPs)—show how to consistently make the right design decisions and make the most of Excel’s most powerful new features. Using their techniques,you can reduce development costs, time to market, and hassle—and build more effective, successful solutions.

Fully updated for Excel 2007, this book starts where other books on Excel programming leave off. Through a hands-on case study project, you’ll discover best practices for planning, architecting, and building Excel applications that are robust, secure, easy to maintain, and highly usable. If you’re a working developer, no other book on Excel programming offers you this much depth, insight, or value.

• Design worksheets that will be more useful and reliable

• Leverage built-in and application-specific add-ins

• Construct applications that behave like independent Windows programs

• Make the most of the new Ribbon user interface

• Create cross-version applications that work with legacy versions of Excel

• Utilize XML within Excel applications

• Understand and use Windows API calls

• Master VBA error handling, debugging, and performance optimization

• Develop applications based on data stored in Access, SQL Server, and other databases

• Build powerful visualization solutions with Excel charting engine

• Learn how to work with VB.NET and leverage its IDE

• Automate Microsoft Excel with VB.NET

• Create managed COM add-ins for Microsoft Excel with VB.NET

• Develop Excel solutions with Visual Studio Tools for Office (VSTO)

• Integrate Excel with Web Services

• Deploy applications more securely and efficiently

The power of SQL Server 2005 Reporting Services is now available for client-side reporting in Visual Studio 2005. Microsoft has added Reporting Services to VS to supersede its Crystal Reports (a Business Objects product used in almost 40,000 companies worldwide) add-in for report development. This hands-on guide takes readers step by step through the design, development, and deployment of a variety of professional reports for Windows, Web, and Mobile clients. It is the most complete single source of information on this important new feature of Visual Studio 2005.

Written for all VS users writing any kind of report, Client-Side Reporting with VS 2005 and SQL Server 2005 is the only book that tells the full story of client-side Reporting Services. Its real-world examples clearly and carefully teach how to use and exploit this powerful and incresingly popular technology.

Foreword by Beth Massi
Senior Program Manager, Microsoft Visual Studio

Visual Basic 2010 Unleashed is the most comprehensive, practical reference to modern object-oriented programming with Visual Basic 2010. Written by Visual Basic MVP Alessandro Del Sole, a long-time leader of the global VB community, this book illuminates the core of the VB language and demonstrates its effective use in a wide variety of programming scenarios.

Del Sole covers both Visual Basic 2010 Professional Edition for professional developers and the Express Edition for hobbyists, novices, and students. Writing for VB programmers at all levels of experience, he walks through using VB 2010 for data access, user interface development, networking, communication, and many other tasks. For those moving from structured languages–including VB 6–he offers detailed guidance on building effective object-oriented code. He also demonstrates how to make the most of Microsoft’s underlying .NET platform to write more robust and powerful software.

This book’s broad coverage includes advanced features such as generics and collections; a thorough introduction to the Visual Studio 2010 IDE and Visual Studio Team System; a full section on data access with ADO.NET and LINQ; practical overviews of WPF and WCF; coverage of web and cloud development with Silverlight and Azure; and advanced topics such as multithreading, testing, and deployment.

• Understand the Visual Studio 2010 IDE, .NET Framework 4.0, and the anatomy of a VB 2010 application
• Debug VB applications and implement error handling and exceptions
• Build efficient object-oriented software with classes, objects, namespaces, and inheritance
• Work with advanced object-oriented features, including interfaces, generics, delegates, events, and collections
• Organize, create, and improve classes with the Visual Studio Class Designer
• Access data with LINQ–including LINQ to Objects, SQL, DataSets, Entities, XML, and Parallel LINQ
• Build modern Windows applications with WPF controls, brushes, styles, and templates
• Develop web-centric applications using ASP.NET, Silverlight, and Windows Azure Services cloud computing
• Create and consume WCF services and WCF Data Services
• Use advanced .NET 4.0 platform capabilities, including assemblies, multithreading, parallel programming, P/Invoke, and COM interoperability
• Perform advanced compilations with MSBuild
• Localize and globalize VB 2010 client applications

Alessandro Del Sole, Microsoft MVP for Visual Basic, is well-known throughout the global VB community. He is community leader on the Italian VB Tips and Tricks website that serves more than 41,000 developers and a frequent contributor and blogger at MSDN’s Visual Basic Developer Center. He is the author of three books about .NET development with Visual Basic.

ON THE WEB:

Download all examples and source code presented in this book from informit.com/title/9780672331008

Category: Microsoft Programming

Covers: Visual Basic 2010

User Level: Intermediate

Now in its 4th Edition, this book shows C# developers how to use Visual Studio and ADO.NET to develop database applications the way the best professionals do. You'll learn how to:

• quickly create Windows and web applications by dragging-and-dropping data controls in Visual Studio 2010


• code your own presentation, business, and database classes with ADO.NET 4 to build 3-layer applications...the route the professionals take for flexibility and control


• display and manipulate data in web applications by using ASP.NET data controls designed specifically for that purpose, like GridView and DetailsView


• work with XML-specific features of ADO.NET to read, write, and manipulate XML data in your applications


• use Visual Studio's Report Designer and ReportViewer control to create and display reports in both Windows and web applications


• use LINQ to SQL instead of standard SQL so you can query databases using C# constructs


• create Entity Data Models so you can use LINQ to Entities to work with business objects, like invoices, while the Entity Framework handles the database details

Practice exercises at the end of every chapter and complete database applications throughout help you master every skill along the way. And Murach's distinctive "paired-pages" format...where each skill is presented with examples and advice in a single 2-page spread...is great for both targeted learning and reference.

I wrote this book from the perspective of a programmer wanting to learn how to integrate reports within a .NET application. I've been working with Crystal Reports since Visual Basic 3 and it's always been difficult to find technical information on report writing.
I spent a year and a half researching what .NET programmers need to successfully create, implement and deploy a Crystal Reports application. I even put the book on the internet for everyone to read for free all of last year. This generated an incredible number of emails from programmers telling me what they liked, disliked, and what was missing from the book. I learned that there are two distinct types of .NET programmers using Crystal Reports.
The first type of programmer doesn't have much experience with Crystal Reports and wants a series of tutorials to help them build reports from scratch. For this programmer I wrote 13 chapters which teach you everything about adding reports to ASP.NET and Windows applications. It starts with the basics of building reports to adding charts, crosstab reports, sorting and grouping, subreports and using the formula editor with Basic syntax and Crystal syntax.
The second type of programmer has been using Crystal Reports for years and is mostly concerned with how to do technical runtime customization of reports. For this programmer I researched and diagrammed the undocumented report object models. I included dozens of examples in both VB.NET and C# to show you how to modify reports, manipulate different data sources (XML, ADO.NET, ODBC, OLE DB, stored procedures with parameters), modify formulas and report parameters, and integrate .NET with the RAS and RDC.
The dozens of emails I received when the book was online were instrumental for doing a major revision of many chapters before publishing the book in hardcopy format. Since releasing the book I continue to receive more emails from people. They regret that the free book isn't online anymore, but understand that it couldn't last forever and that the hardcopy version is even better. I hope you like it and that it helps you achieve your reporting goals.
September 2004 Update: Due to high demand, I did a second printing of the book. I took advantage of this opportunity to go through the book and remove all grammatical errors. The content is the same, but the typos have been corrected.

Including a tutorial on how to use data structures and algorithms and a reference for implementation using VB.NET and the .NET Framework Class Library, this is the first Visual Basic.NET book to provide a comprehensive discussion of the major data structures and algorithms. Michael McMillan presents arrays and arraylists, linked lists, hash tables, dictionaries, trees, graphs, sorting and searching as well as more advanced algorithms, such as probabilistic algorithms and dynamic programming in an object-oriented fashion. Finally, the professional or student VB.NET programmer has a dedicated reference instead of having to translate material on C++ or Java.

Get practical information for developing applications with the Microsoft .NET Compact Framework 2.0—straight from mobile-development experts. This definitive guide delivers the proven techniques, real-world insights, and extensive code samples you need to bring information access to any Windows-based mobile device.

Discover how to:

• Design a user interface that is optimized for smart devices
• Add functionality by using Windows® Mobile APIs
• Organize and persist data stored on a device
• Establish network connections and respond to changes in network state
• Synchronize mobile devices with data stored on backend servers
• Implement authentication, symmetric encryption, and asymmetric encryption algorithms
• Optimize application performance for resource-constrained devices
• Interoperate with native code by using PInvoke and COM interop
• PLUS—Get an introduction to .NET Compact Framework 3.5 and Microsoft Visual Studio® code name “Orcas”

PLUS—Get Microsoft Visual C#® and Visual Basic® code samples on the Web

A step-by-step guide for brand-new Office developers who want to explore programming with VSTO. This book contains complete step-by-step instructions and simple explanations about VSTO programming of entire Office applications. It covers the concepts of VSTO, VSTO architecture, its features, and versions using practical examples, to help beginners and intermediate developers develop real-world Office applications. Separate chapters cover programming InfoPath, Word, Excel, Outlook, and PowerPoint. This book is aimed at .NET developers, familiar with C#, who want to get to grips with programming Office 2007. The book will also be useful for those of you who already have experience with VBA and programming Office, but are ready to take the next step into the more powerful world of Office programming with VSTO.

A complete and practical guide to delivering content-rich community-driven websites based on the freely available ASP.NET Community Starter Kit from Microsoft. Aimed at experienced ASP.NET developers with responsibility for delivering robust and feature-rich websites, fast and effectively. First the book gives you a clear understanding of the architecture of the application. Then, it walks you through the implementation process, outlining choices and techniques. Having mastered the standard application, youll learn how to customize and extend the framework to deliver customer features and to integrate with other applications. This book has been written for ASP.NET developers with a sound grasp of C# and access to Visual Studio .NET. This book uses the Visual Studio. NET version of the ASP.NET Community Starter Kit.