Browse by Tags

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    
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 | 5 Comments    
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    
MSDN Magazine - Dynamic Data Entry With XML Literals
01 October 08 06:49 PM
Check out the latest news on the VB Dev Center . I'm finally headlining myself ;-) I'm in the October issue of MSDN Magazine . I've been managing the content for the Basic Instincts column for a little over a year now where we rotate writers from the Read More...
Postedby Beth Massi | 11 Comments    
Accessing Open XML Document Parts with the Open XML SDK
30 July 08 07:30 PM
About a month ago the Open XML SDK 1.0 (June 08 update) was released . The SDK provides strongly typed document part access to Word 2007, Excel 2007 and PowerPoint 2007 documents. The SDK has been a CTP for a while, but last month version 1.0 was finally Read More...
Postedby Beth Massi | 4 Comments    
Article: Sharpening Your Axis with Visual Basic 9
30 June 08 02:12 PM
In the July/August issue of CoDe Magazine there's an article I wrote with Avner Aharoni (the Program Manager on XML literals) called Sharpening Your Axis with Visual Basic 9 . (They just opened up online access to even non-subscribers today!) I highly Read More...
Postedby Beth Massi | 2 Comments    
Dynamic Data Entry with WPF and LINQ
24 June 08 03:29 PM
In my last post on this subject I explored creating WPF UI's dynamically using XML literals. The one part that bugged me a bit was that even though the UI was dynamic, we were using a fixed object model of our customer (using LINQ to SQL classes). I wanted Read More...
Postedby Beth Massi | 22 Comments    
Dynamic UI with WPF and LINQ
12 June 08 04:51 PM
Lately I've been getting my hands deep into WPF with my line-of-business (LOB)/data-based application mind set. I'm taking a different approach to the technology resisting the urge to put on my amateur-designer hat and instead purely focus on data, data-binding, Read More...
Postedby Beth Massi | 42 Comments    
Quickly Changing Values of XML Elements Using LINQ
09 May 08 06:33 PM
I've had many questions lately on how you can query for a specific node in an XML document (or fragment) and change it's value using LINQ. (This must mean that people are really starting to use this stuff so I'm pretty excited.) This is really easy to Read More...
Postedby Beth Massi | 10 Comments    
Querying HTML with LINQ to XML
25 April 08 04:00 PM
Often times we need to parse HTML for data. Sure in a perfect world everything would have a nice service or API wrapped around it but as we all know this is not always the case. Many times we're left with parsing files or "screen scraping" to get the Read More...
Postedby Beth Massi | 13 Comments    
Mail Merging with Word, LINQ and XML Literals in VB
06 December 07 05:50 PM
I've mentioned before that you can use XML literals in VB 9 to do text merging so I figured it should be pretty easy to do some mail merging in Word the same way. Word 2007 (and Excel, etc) now uses a standard XML format called Office Open XML to describe Read More...
Postedby Beth Massi | 20 Comments    
Attachment(s):WordMailMerge.zip
Northwind Meets Virtual Earth - Generate VE Maps with LINQ
03 December 07 03:48 PM
With Visual Basic 9 and LINQ you can easily create XML from multiple data sources including relational data, other XML sources or any other queryable object. Since most modern systems interact with each other in some form of XML the possibilities are Read More...
Postedby Beth Massi | 11 Comments    
Visual Studio Tip of the Day Browser
07 November 07 02:14 PM
I'm sitting here with writer's block on an article I'm supposed to be writing so in order to coax the technical writing muse I decided to write an application I've been meaning to do for over a month. If you didn't know, on Sara's blog she has a category Read More...
Postedby Beth Massi | 10 Comments    
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 | 69 Comments    
Attachment(s):ImportExportExcel.zip
Embed Code and Avoid Underscores in Your Multiline Strings
23 October 07 12:03 PM
One of the things I most dearly missed from FoxPro when I moved to VB.NET was the ability to easily dump a bunch of text (multi-line string literals) into the editor easily and embed code (text-merge). FoxPro has a keyword TEXT...ENDTEXT for this and Read More...
Postedby Beth Massi | 25 Comments    
More Posts Next page »

This Blog

Syndication

Page view tracker