Transcript Slide 1

2 Session Code: OFC304

Integrating Windows Presentation Foundation and Windows Communication Foundation into Your Office Business Applications

Tim Huckaby CEO, InterKnowlogy Microsoft RD & MVP

4

5

About…

● ● ● ● ● InterKnowlogy ( www.InterKnowlogy.com

) Tim Huckaby, CEO ( [email protected]

) Custom App Dev / Consulting / Software & Systems Engineering Firm headquartered in Carlsbad, CA Microsoft Gold Partner managed in SoCal and Redmond Design, Architect, Build and Deploy enterprise class applications Industry Experts: 90% of the company is published Microsoft .NET Application development since 2000!

Microsoft .NET Smart Client pioneers / industry leaders Information Worker Solutions (VSTO & SharePoint) Integration / Messaging, B2B / B2C, Wireless / Mobility Microsoft BizTalk, Web Services, Microsoft Active Directory, Security, SSO, Authorization, Authentication Cutting Edge Solutions on emerging Microsoft technologies Largest Client: Microsoft

6

Session Objectives And Agenda

Designing, Building and Deploying OBAs that leverage WPF and WCF Demos: Document Solutions for Excel and Word Add-in Solutions in Outlook Guidance on how to get immediately effective in VSTO, WPF and WCF VSTO, WPF and WCF…Why?

Guidance on Where to Go Next…

7

VSTO is the Tool for Building OBAs

VSTO e nables developers to leverage Visual Studio and the Microsoft Office platform to build scalable line-of-business solutions in .NET based on Microsoft Office Makes Office a valuable, first-class project type in Visual Studio Enables developers to create & extend Office Business Applications Enables developers to leverage key Office UI features and support collaboration and workflow Provides Office developers with the benefits and advantages of the Visual Studio professional development environment Enables developers to leverage existing programming skills Developers can leverage their company’s current investment in Office 2003 Pro and new investment in 2007 Office system

8

Office Client Development With VSTO

2 Common Application Models Document-Centric Solutions

MyTaskPane MyCode

OM Office Application Solutions (Add-In)

MyMenu MyCode

OM

The Actions Pane

Document Actions task pane Specific task pane available to document customizations (new in Word and Excel 2003+) Actions Pane Programmable object exposed by VSTO 2005 from Excel Workbook and Word Document classes Fully encapsulates an implementation of Ismart Document Provides a Windows Forms-based programming model for accessing the Document Actions task pane

10

VSTO Excel And WPF

Tim Huckaby InterKnowlogy CEO Microsoft RD & MVP

11

What the heck is XAML?

Separates the front-end from the back-end Simple declarative programming language suitable for constructing and initializing .NET Objects Usually the most concise way to represent user interfaces (or other hierarchies of objects) Doesn’t need a compile to render The language that almost all WPF related tools emit

12

Outlook 2007 Form Regions

New technology in Outlook 2007 for enhancing and replacing Outlook’s built-in forms Adjoining and Separate regions for both custom and built-in forms Replacement and Replace-all regions for custom forms Forms Designer in Outlook Many new controls allow duplication of built-in forms; they are themed and support databinding Code behind form regions is implemented via COM add-in

13

VSTO Outlook And WPF

Tim Huckaby InterKnowlogy CEO Microsoft RD & MVP

What the Heck is WPF?

…and why do we need it?

It’s .NET!

All the goodness of Developer Productivity Built on Top of Direct 3D Converted to 3D triangles, textures and other Direct3D objects & then rendered by hardware Benefits of hardware acceleration & perf due to work being off-loaded to GPUs (unlike GDI based systems) Ensures the maximum benefit of new hardware and drivers Software rendering pipeline as fallback Declarative programming Bringing designers directly into application development Ease of deployment Allowing administrators to deploy and manage applications securely

15

VSTO Excel And WPF

AdventureWorks VSTO excel with wpf user control Tim Huckaby InterKnowlogy CEO Microsoft RD & MVP

16

What the Heck is WCF?

Framework for connecting distributed applications Part of .NET 3.0

Enables building SOA applications Implements WS-* standards Single API that supports the capabilities of: .NET Remoting ASP.NET Web Services Enterprise Services (COM+) MSMQ Messaging subsystem at its core SOAP messages Does not necessarily mean XML/Text!

Interoperability with: Enterprise Services ASMX / Web Services 1.0 services Any WS-* compliant web service MSMQ applications

17

VSTO Word, WCF and WPF

Tim Huckaby InterKnowlogy CEO Microsoft RD & MVP

18

Why WCF?

Flexibility

You can change your mind about wire level communication protocols, security model, and many other facets without changing your source code

Maintainability

One API for all forms of remote communication, don’t need to learn multiple technology stacks

Power

All the capabilities of other remoting APIs rolled into one Interoperability and SOA enabled in ways the other technologies never considered

Simplicity

On par with other remoting technologies if you just need simple remote calls Incrementally more complex as you start to take advantage of more complex features Features which the other technologies may not have

Gotchas, Tips & Tricks

Tip:

You are going to need more tools than just Visual Studio .NET when building WPF solutions: Microsoft Expression Blend Microsoft Expression Designer (or it’s competitor) XAML Pad or XAML Cruncher

Gotcha:

when building a VSTO application DO NOT COMPILE IN BLEND – you will “hose” your design time. VSTO apps won’t run from Blend anyway…

Tip:

If you don’t have artistic talent, then don’t try to create WPF styles….there are plenty of WPF Style samples in XAML source on the web to “leverage”.

Gotcha:

if you are going to build outlook Add-Ins then use a VPC…or else you’ll be cleaning the registry from a zillion compiles.

Product Team Blogs

Eric Carter: .NET4Office http://blogs.msdn.com/eric_carter/ Peter Torr: Office Development, Security, Randomness… http://blogs.msdn.com/ptorr/ Eric Lippert: Fabulous Adventures in Coding http://blogs.msdn.com/EricLippert Paul Stubbs: Office Development with .NET http://blogs.msdn.com/pstubbs/ VSTO Team Blog http://blogs.msdn.com/vsto/

Newsgroups

VSTO microsoft.public.vsnet.vstools.office

MSDN Forums: VSTO http://forums.microsoft.com/MSDN/ShowForum.as

px?ForumID=16&SiteID=1 .

Additional Information

MSDN Developer Centers VS.NET and Office Development http://msdn.microsoft.com/vstudio/office/ Office Development http://msdn.microsoft.com/office Hands-on Labs for VSTO 2005 http://www.microsoft.com/downloads/details.aspx?FamilyID=f2323aaf fe87-4203-9ed8-72466566e105&displaylang=en VSTO 2005 Web casts http://msdn.microsoft.com/office/understanding/vsto/multimedia/default.a

spx

Resources

VSTO Forum http://forums.microsoft.com/msdn/ShowForum.aspx?For

umID=16 VSTO-related blogs VSTO-related Blog Search – http://search.live.com/macros/pstubbs/vsto Office Zealot Site – http://www.officezealot.com/VSTO/bloghome.aspx

For More Information

Visit the VSTO Developer Center http://msdn.microsoft.com/office/tool/vsto/default.aspx

VSTO Help documentation on MSDN http://msdn2.microsoft.com/library/d2tx7z6d(en us,vs.80).aspx

Office Object Model Reference

Excel Object Model Reference http://msdn.microsoft.com/en-us/library/bb149081.aspx

Outlook Object Model Reference http://msdn.microsoft.com/en-us/library/bb176619.aspx

PowerPoint Object Model Reference http://msdn.microsoft.com/en-us/library/bb251394.aspx

Visio Automation Object Model Reference http://msdn.microsoft.com/en-us/library/aa730930.aspx

Word Object Model Reference http://msdn.microsoft.com/en-us/library/bb244515.aspx

Summary

VSTO is the key enabler for the .NET stack to build Office Business Applications ● Connect documents to live business data ● ● Provide structure using XML Schemas Provide deeper UI integration using the Document Actions task pane ● Integrated design-time experience ● Developer productivity through programming model enhancements ● All the power of Visual Studio and the .NET Framework WPF and WCF are natural additions to your Enterprise Office Business Applications ● Custom, Integrated, Professional-looking Uis within the Office Client applications ● Distributed Office Applications that are Flexible, Powerful, Simple & Maintainable

Tim Huckaby, InterKnowlogy More info on InterKnowlogy: www.InterKnowlogy.com

Contact me: Tim Huckaby E-mail : [email protected]

or [email protected]

Phone: 760-444-8640 Blog : http://blogs.InterKnowlogy.com/TimHuckaby About Tim Huckaby CEO, InterKnowlogy Microsoft ® Regional Director – Southern California Microsoft ® .NET Partner Advisory Council Founder / Member Microsoft ® MVP - .NET

Microsoft ® Surface Partner Advisory Council INETA Speaker – International .NET Users Group Association Windows and .NET Magazine Advisory Board Member .NET Developers Journal Magazine Advisory Board Member Author / Speaker

31

Video Title

32

Customer Title

Name Title Company

33

Demo Title

Name Title Company

34

Demo Title

Name Title Company

35

Partner Title

Name Title Company

36

Announcement Title

37

PowerPoint Template Subtitle color

Example of a slide with a subhead Set the slide title in “title case” Set subheads in “sentence case” Generally set subhead to 36pt or smaller so it will fit on a single line The subhead color is defined for this template but must be selected; In PowerPoint 2007, it is the fourth font color from the left

38

PowerPoint Guidelines

Font, size, and color for text have been formatted for you in the Slide Master Use the color palette shown below See next slide for additional guidelines Hyperlink color: www.microsoft.com

Sample Fill Sample Fill Sample Fill Sample Fill Sample Fill Sample Fill Sample Fill Sample Fill Sample Fill Sample Fill

39

Slide for Showing Software Code

Use this layout to show software code The font is Consolas, a monospace font The slide doesn’t use bullets but levels can be indented using the “Increase List Level” icon on the Home menu To use straight quotes " instead of smart quotes ”, do this: 1.Click on the Office Button in the upper left corner 2.At the bottom of the menu, choose PowerPoint Options 3.From the left pane, select Proofing 4.Click on the AutoCorrect Options button 5.Select the AutoFormat As You Type tab, and deselect “Straight quotes” with “smart quotes”. Then Click OK.

40

Table Format

Column 2 Table Title Column 3 Column 4 Column 1 Column 5

41

Bar Chart Example

Название диаграммы

Series 1 Series 2 Series 3 4,4 4,3 2,4 2 2,5 2 3,5 1,8 3 4,5 5 2,8 Category 1 Category 2 Category 3 Category 4

42

Pie Chart Example

10% 9%

Chart Title

23% 58% 1st Qtr

43

Resources for Developers

www.microsoft.com/teched Tech·Talks Tech·Ed Bloggers Live Simulcasts Virtual Labs http://microsoft.com/msdn Developer’s Kit, Licenses, and MORE!

Related Content

Hands-on Labs (session codes and titles) Interactive Theater Sessions (session codes and titles) Hands-on Labs (session codes and titles) Hands-on Labs (session codes and titles)

Track Resources

Resource 1 Resource 2 Resource 3 Resource 4

1 Year

Subscription!

Complete an evaluation on CommNet and enter to win!

49 © 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.

The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.