Dotnetcat » .NET Books » Office books

With Professional Microsoft Office SharePoint Designer 2007, you can master all aspects of using Share Point Designer in an Enterprise environment to enhance Microsoft SharePoint Products and Technologies. Review key integration points, how to use CSS editing tools to create and modify SharePoint themes, how to supplement SharePoint Designer functionality by using Microsoft Visual Studio, and how to create a rich interactive experience. If you need to connect SharePoint with other enterprise resources or create components to integrate into the SharePoint framework, this book will show you how to accomplish these tasks.

Code - The Leading Independent .NET Resource
Table of Contents:
*) Small Building Blocks
*) Ensuring Quality Code
*) Sandboxed Solutions in SharePoint 2010
*) Starting Your Own User Group
*) ASP.NET MVC and the Spark View Engine
*) Creating Self-Scaling Applications with Azure Services
*) Using the Amazon Web Service SDK for .NET
*) Handling Business-Related Date Tasks in T-SQL
*) Post Mortem - Office 2010 the Movie
*) Developing Database Agnostic Applications with Entity Framework
*) Supercharging ASP.NET MVC with MvcContrib
*) A Practical Use of Indexers
*) Ask the Doc Detective
*) Managed Coder: The Beetle in the Box
For more information, visit www.codemag.com

You know all those hidden techniques and amazing features you spent months discovering in Visual Basic 6? Imagine you could read just one book and regain all of that knowledge. Imagine a book that clearly shows you how to do practically everything you want in .NET – and provides real-life code to get you there. Imagine a book that goes beyond the basics, yet doesn’t get bogged down in detail, a book that will save you hours. That’s what this book is all about; it is the number one book for all your VB.NET code demands.

What better way to kick off a new year than with a major update of the world's most popular productivity suite, Microsoft Office? With Microsoft Office 97 For Windows For Dummies, you can start using all of this product's new features that enable your whole organization to work together as seamlessly as do Word, Excel, Access, and the other applications that comprise Microsoft Office 97.

This book provides a step-by-step guide for developing an ASP.NET 3.5 application using the latest features in Visual Studio 2008. The Problem Design Solution series by Wrox is unique because it describes a large case study and builds an entire solution chapter by chapter for each incremental step. This book uses a wide variety of new features in Visual Studio 2008, explains each in detail, and produces a solution that you can use as a starting point for your own applications.

If you are responsible for designing or developing enterprise-wide applications, departmental applications, portals, or any line of business application, then this book is for you. Many applications have a similar set of features, and this book builds an application with some of the most common features of enterprise applications. Let’s face it: Every application has the same general set of features, but implemented in a different way. A database sits in the back end and you, as the developer, are responsible for enabling users to add, update, select, and delete records. If only it were that simple, no?

The real development work starts when you sit with users and try to understand the business process and why they need a new or improved system in the first place. A lot of companies have departments that use Excel and Access wizards to create small systems that eventually become a lifeline for some part of the business. Usually something bad happens because of the nature of the tool they are using. Senior-level management is called in, project managers are hired, programmers are contracted, and the Project Management Office (PMO) is called to save the world. Suddenly this loosely defined process is high priority and people want documented standard operating procedures, audit reports, more productivity, less people, and of course a system that can do it all, which is where you come in. When you think about it, it’s a pretty daunting task. You’re expected to become an expert in someone else’s business process, flaws and all, and create a system that the company will rely on as the backbone for their existence. OK, maybe I’m exaggerating just a little bit, but when you go looking for that raise you might want to phrase it that way.

This book will give you the tools necessary to build a framework that can be extended to create a solution to solve your company’s problems. The design pattern uses the normal three layers, the user interface (UI), the business logic layer (BLL), and the data access layer (DAL), but also builds the classes in each layer that encapsulate common business rules such as role-based security, workflow, reporting, dynamic menus, data entry, dynamic querying, notifications, exception handling, and auditing. As the book guides you through the complete solution, each business requirement is thoroughly examined and some of the latest enhancements in ASP.NET 3.5 and Visual Studio 2008 are used to implement them in a reusable framework.

Enterprise applications are typically complex, and the teams that build enterprise applications come in all shapes and sizes. Some of the roles include a project sponsor, a project manager, business analysts, an architect, UI developers, middle-tier developers, database developers, and, if you’re really lucky, testers. Just a side note: Users are not testers. If you ever have the pleasure of working with professional testers, you’ll realize how important they are in the process, and how they truly are “quality” assurance engineers. Unfortunately, a lot of companies aren’t willing to invest in professional testers, so the users and/or developers end up assuming that role. This book is mainly focused on the architect and developers, but testers may find it valuable as well to help them understand the plumbing that goes into developing and architecting an enterprise application.

This book is for the intermediate to senior level developer or system architect. It would be helpful if you have experience with Visual Studio, the .NET Framework, ASP.NET, and C# because that is what the samples are written in, but the design pattern could be used in any language. The book is focused on enterprise applications, but the pattern could be used for any type of application that has a web front end and connects to a database. The application framework built in this book provides a foundation that can be extended to meet the specific business needs of your organization.

The sample application in this book is built using Visual Studio 2008, ASP.NET 3.5, C#, and SQL Server 2005. Each chapter goes into great detail, with plenty of code samples, and uses some of the new features in Visual Studio 2008 and the language enhancements in the .NET Framework 3.5. The solution includes examples for technologies such as LINQ to SQL, master pages, custom controls, GridViews, business objects, data objects, and Crystal Reports. Some of the language enhancements discussed include LINQ, extension methods, partial methods, automatic properties, anonymous types, lambda expressions, and object initializers.

Of course, I realize that the code is what most developers are interested in, and each chapter provides numerous examples.

The Problem Design Solution series is just that. Each chapter has three sections with a description of the problem to be addressed, the design considerations for choosing a solution for the problem, and the solution that ultimately addresses the problem. The solution includes the bulk of the code. Each chapter builds upon the previous chapter, and it is recommended that you read them in order. The base classes that are described in the first few chapters are critical to an understanding of the rest of the book. Later chapters build upon the base classes and extend their functionality in all three layers of the application.

Explore InfoPath 2003—and transform the way you manage business information and deliver results! This guide expertly reviews InfoPath features and capabilities—including the latest updates from Microsoft Office Service Pack 1—demonstrating how to create easy-to-use forms to capture data from spreadsheets, text files, databases, XML Web Services, and even e-mail in reusable XML format. Whether you’re streamlining your invoicing system, managing performance appraisals, or collecting feedback from users or customers, you’ll discover how to quickly connect the people and information you need—with no XML expertise or advanced programming required.Covers Microsoft Office 2003 Service Pack 1!

Discover how to:

• Use InfoPath forms to capture and validate user input—without writing code
• Design form features, from basic controls and views to digital signing options
• Send forms to shared servers, websites, form libraries, or e-mail
• Easily reuse captured XML data in other applications, such as Microsoft Word or Excel
• Develop front-end forms that interoperate with back-end databases such as Microsoft SQL Server and with Web Services
• Use your programming skills to customize forms with the InfoPath 2003 Toolkit for Visual Studio .NET
• Generate special purpose XML documents, such as Really Simple Syndication (RSS) 2.0 filesGet ready-to-use InfoPath forms on CD!

CD features:

• Sample InfoPath business forms to adapt for your own use
• Files for all the book’s examples
• Fully searchable electronic version of the book

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

A must-have guide that covers all the new features of Visual Studio 2010

Visual Studio allows you to create and manage programming projects for the Windows platform, and the new 2010 version has undergone a major overhaul comprised of significant changes. Written by an author team of veteran programmers and developers, Professional Visual Studio 2010 gets you quickly up to speed on what you can expect from the newest version of Visual Studio.

This book's first section is dedicated to familiarizing you with the core aspects of Visual Studio 2010. Everything you need is contained in the first five chapters, from the IDE structure and layout to the various options and settings you can change to make the user interface synchronize with your own way of doing things.

From there, the remainder of the book is broken into 11 parts:

• Getting Started: In this part, you learn how to take control of your projects and organize them in ways that work with your own style.
• Digging Deeper: Though the many graphical components of Visual Studio that make a programmer's job easier are discussed in many places throughout this book, you often need help when you're in the process of actually writing code. This part deals with features that support the coding of applications such as IntelliSense, code refactoring, and creating and running unit tests In the latest version of the .NET framework, enhancements were added to support dynamic languages and move towards feature parity between the two primary .NET languages, C# and VB. This part covers changes to these languages, as well as looking at a range of features that will help you write better and more consistent code.
• Rich Client and Web Applications: For support building everything from Office add-ins to cloud applications, Visual Studio enables you to develop applications for a wide range of platforms. These two parts cover the application platforms that are supported within Visual Studio 2010, including ASP.NET and Office, WPF, Silverlight 2 and ASP.NET MVC.
• Data: A large proportion of applications use some form of data storage. Visual Studio 2010 and the .NET Framework include strong support for working with databases and other data sources. This part examines how to use DataSets, the Visual Database Tools, LINQ, Synchronization Services and ADO.NET Entity Framework to build applications that work with data. It also shows you how you can then present this data using Reporting.
• Application Services: Through the course of building an application you are likely to require access to services that may or may not reside within your organization. This part covers core technologies such as WCF, WF, Synchronization Services and WCF RIA services that you can use to connect to these services.
• Configuration and Internationalization: The built-in support for configuration files allows you to adjust the way an application functions on the fly without having to rebuild it. Furthermore, resource files can be used to both access static data and easily localize an application into foreign languages and cultures. This part of the book shows how to use .NET configuration and resource files.
• Debugging: Application debugging is one of the more challenging tasks developers have to tackle, but correct use of the Visual Studio 2010 debugging features will help you analyze the state of the application and determine the cause of any bugs. This part examines the rich debugging support provided by the IDE.
• Build and Deployment: In addition to discussing how to build your solutions effectively and getting applications into the hands of your end users, this part also deals with the process of upgrading your projects from previous versions.
• Customizing and Extending Visual Studio: If the functionality found in the previous part isn't enough to help you in your coding efforts, Microsoft has made Visual Studio 2010 even more extensible. This part covers the automation model, how to write add-ins and macros, and then how to use a new extensibility framework, MEF, to extend Visual Studio 2010.
• Visual Studio Ultimate: The final part of the book examines the additional features only available in the Premium and Ultimate versions of Visual Studio 2010. In addition, you'll also learn how the Team Foundation Server provides an essential tool for managing software projects.

Though this breakdown of the Visual Studio feature set provides the most logical and easily understood set of topics, you may need to look for specific functions that will aid you in a particular activity. To address this need, references to appropriate chapters are provided whenever a feature is covered in more detail elsewhere in the book.

Professional Visual Studio 2010 is for all developers new to Visual Studio as well as those programmers who have some experience but want to learn about features they may have previously overlooked.

If you are familiar with the way previous versions of Visual Studio worked, you may want to skim over Part I, which deals with the basic constructs that make up the user interface, and move on to the remainder of the book where the new features found in Visual Studio 2010 are discussed in detail. While you may be familiar with most of Part I, it is worth reading this section in case there are features of Visual Studio 2010 that you haven't seen or used before.

If you're just starting out, you'll greatly benefit from the first part, where basic concepts are explained and you're introduced to the user interface and how to customize it to suit your own style.

Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook is the definitive book on VSTO 2008 programming, written by the inventors of the technology. VSTO is a set of tools that allows professional developers to use the full power of Microsoft Visual Studio 2008 and the .NET Framework to program against Microsoft Office 2007.

This book delivers in one place all the information you need to succeed using VSTO to program against Word 2007, Excel 2007, and Outlook 2007, and provides the necessary background to customize Visio 2007, Publisher 2007, and PowerPoint 2007. It introduces the Office 2007 object models, covers the most commonly used objects in those object models, and will help you avoid the pitfalls caused by the COM origins of the Office object models. Developers who wish to program against Office 2003 should consult Carter and Lippert’s previous book, Visual Studio Tools for Office.

In VSTO 2008, you can build add-ins for all the major Office 2007 applications, build application-level custom task panes, customize the new Office Ribbon, modify Outlook’s user interface using Form Regions, and easily deploy everything you build using ClickOnce.

Carter and Lippert cover their subject matter with deft insight into the needs of .NET developers learning VSTO, based on the deep knowledge that comes from the authors’ unique perspective of living and breathing VSTO for the past six years. This book

• Explains the architecture of Microsoft Office programming and introduces the object models
• Covers the main ways Office applications are customized and extended
• Explores the ways of customizing Excel, Word, and Outlook, and plumbs the depths of programming with their events and
  object models
• Introduces the VSTO programming model
• Teaches how to use Windows Forms and WPF in VSTO and how to work with the Document Actions Pane and application-level task panes
• Delves into VSTO data programming and server data scenarios
• Teaches ClickOnce VSTO deployment

This is the one book you need to succeed in programming against Office 2007.

C# and Visual Basic .NET Code samples for download can be found here: http://www.informit.com/store/product.aspx?isbn=0321533216

For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.

Master the How and Why of Office 2003! Students master the "How and Why" of performing tasks in Office and gain a greater understanding of how to use the individual applications together to solve business problems.

An accessible and step-by-step approach to using VB.NET and XML enterprise application development

XML is a tool for interacting with, describing, and transporting data between machines across networks and across the Internet-perfectly suited for Microsoft's .NET plan to fully integrate the Internet into distributed computing. By using real-world and fully-functional examples, this book quickly brings Visual Basic programmers and developers up to speed on XML for enterprise application development. The authors include an overview of XML and how it works with VB.NET, then explain how to use it to manipulate data in distributed environments.

Companion Web site at www.vb-helper.com features the complete working code for all the examples built in the book.

Microsoft Technologies
.NET Platform: The next big overhaul to Microsoft's technologies that will bring enterprise distributed computing to the next level by fully integrating the Internet into the development platform. This will allow interaction between any machine, on any platform, and on any device.

Visual Basic.NET: The update to this popular visual programming language will offer greater Web functionality, more sophisticated object-oriented language features, links to Microsoft's new common runtime, and a new interface.

ASP.NET: A programming framework (formerly known as Active Server Pages) for building powerful Web-based enterprise applications; can be programmed using VB.NET or C#.

C#: Microsoft's new truly object-oriented programming language that builds on the strengths of C++ and the ease of Visual Basic; promises to give Sun's Java a run for its money.