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]
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.