Browse by Tags

• ADO.NET Data Services
• Article
• Community
• Data
• DevCenter
• LINQ
• OBA
• SharePoint
• Visual Basic
• VSTO
• WPF

Merging Text & Photos into a Word Document using Open XML SDK
24 September 09 02:55 PM

Yesterday I posted about how we could create a letter generator (mail merge) that took data from a database to create a Word 2007 document using the System.IO.Packaging class. I showed how to take data from Northwind using a single LINQ query to create Read More...

Postedby Beth Massi | 0 Comments    

Filed under: LINQ, VS2008, DevCenter, Article, XML, Office, VSTO

Mail Merging Into a Single Word Document Using XML Literals
23 September 09 04:18 PM

With the release of Microsoft Office 2007 we can work with a much simpler, standard, XML format called Open XML which opens the door for many types of applications that cannot work via COM. What if you needed to build a scalable web service that processes Read More...

Postedby Beth Massi | 18 Comments    

Filed under: Visual Basic, LINQ, VS2008, DevCenter, Article, XML, Office

DevProConnections Article: Taking Advantage of LINQ and XML in Microsoft Office 2007
17 August 09 10:05 AM

This month I have an article on DevProConnections: Taking Advantage of LINQ and XML in Microsoft Office 2007 In this article, I talk about how a lot of applications that need to take advantage of Microsoft Office can do so without going through COM. Many Read More...

Postedby Beth Massi | 0 Comments    

Filed under: Visual Basic, LINQ, VS2008, DevCenter, Article, XML, Office

Using Windows Presentation Foundation in Office Clients
10 August 09 05:31 PM

I was cleaning up my desk today and in the piles of mail and gobs of paper I found the SDN Magazine “Women in Technology” issue 101 that featured an article I wrote that was released in print back in May. Well, I just noticed today that near the end of Read More...

Postedby Beth Massi | 5 Comments    

Filed under: WPF, VS2008, DevCenter, Article, XML, Office, ADO.NET Data Services, VSTO, OBA

dnrTV: Showing off the Open XML SDK and LINQ
07 April 09 03:05 PM

Yesterday Carl posted another dnrTV show with yours truly . This time I’m talking about the Open XML SDK , something that I’ve written and spoken about many times . In this episode I show how to use Word 2007 content controls and map them to custom XML Read More...

Postedby Beth Massi | 5 Comments    

Filed under: Visual Basic, VS2008, Community, DevCenter, XML, Office, VSTO

OBA Part 3 - Storing and Reading Data in Word Documents
12 February 09 05:55 PM

In my last few posts we've been building a simple Office Business Application (OBA) for the new Northwind Traders. If you missed them: OBA Part 1 - Exposing Line-of-Business Data OBA Part 2 - Building and Outlook Client against LOB Data In this post I'm Read More...

Postedby Beth Massi | 6 Comments    

Filed under: Visual Basic, VS2008, DevCenter, Article, XML, Office, Data, ADO.NET Data Services, SharePoint, OBA

Quickly Import and Export Excel Data with LINQ to XML
30 October 07 08:00 PM

One really handy thing to do with relational data is to import and export it to Excel. This can be a total snap using LINQ to XML in Visual Basic 2008. For example, let's say I want to import data from an Excel spreadsheet into a local database file like Read More...

Postedby Beth Massi | 73 Comments    

Filed under: LINQ, VS2008, DevCenter, Article, XML, Office, Data

Attachment(s):ImportExportExcel.zip