Browse by Tags

• Data
• DevCenter
• Dynamic Programming
• Entity Framework
• N-tier
• Office
• Visual Basic
• VS2005
• VSTO
• WCF
• Winforms
• WPF
• XML

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 | 5 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

Filtering Entity Framework Collections in Master-Detail Forms
16 July 09 05:18 PM

Last post I talked about how to get WPF data binding to work with master-detail entity collections. I had a couple readers ask me how they could filter the child collection instead of bringing them all down so in this post I’d like to show how you could Read More...

Postedby Beth Massi | 2 Comments    

Filed under: WPF, LINQ, VS2008, DevCenter, Article, Entity Framework

Using the WPF ObservableCollection with EF Entities
08 May 09 03:29 PM

The ObservableCollection is a special WPF collection that provides proper notifications to the UI when items are added, removed, or the list is refreshed because it implements INotifyCollectionChanged . It’s common to use this collection (or inherit from Read More...

Postedby Beth Massi | 12 Comments    

Filed under: Visual Basic, WPF, LINQ, VS2008, DevCenter, Article, Data, Entity Framework

Data Binding WPF Lookup Combobox Values to EF Entities
30 April 09 07:57 AM

It’s extremely common to have to hook up lookup tables on your data entry forms in order to populate foreign keys in a database. I’ve talked about how to do this in Winforms and WPF with Datasets and LINQ to SQL before: How Do I: Create a Lookup Combobox Read More...

Postedby Beth Massi | 5 Comments    

Filed under: Visual Basic, WPF, LINQ, VS2008, DevCenter, Article, Data, Entity Framework

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    

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

LINQ to SQL N-Tier Smart Client - Part 3 Database Transactions
16 April 08 12:03 PM

In my previous posts this week I showed how to build a simple distributed application with a Windows client, a WCF hosted middle-tier and a data access layer that used LINQ to SQL: LINQ to SQL N-Tier Smart Client - Part 1 Building the Middle-Tier LINQ Read More...

Postedby Beth Massi | 20 Comments    

Filed under: Visual Basic, LINQ, VS2008, Winforms, DevCenter, WCF, Article, Data, N-tier

LINQ to SQL N-Tier Smart Client - Part 2 Building the Client
14 April 08 11:03 AM

In my last post we built the service and data access layer for our LINQ to SQL N-Tier application. In this post we'll walk through building a very simple Windows client form that works with our middle-tier. Adding the Service Reference Now that we have Read More...

Postedby Beth Massi | 14 Comments    

Filed under: Visual Basic, LINQ, VS2008, Winforms, DevCenter, WCF, Article, Data, N-tier

LINQ to SQL N-Tier Smart Client - Part 1 Building the Middle-Tier
12 April 08 09:01 AM

In my previous posts on LINQ to SQL I showed how to build LINQ to SQL classes and set up the data binding in your Windows applications. If you missed them: Related Data Binding and ComboBoxes with LINQ to SQL Creating Lookup Lists with LINQ to SQL One-To-Many Read More...

Postedby Beth Massi | 42 Comments    

Filed under: Visual Basic, LINQ, VS2008, Winforms, DevCenter, WCF, Article, Data, N-tier

Simple Validation with LINQ to SQL Classes
25 February 08 05:04 PM

In the last few posts on LINQ to SQL I've showed how to set up an object model using the O/R designer and how to handle a couple data binding scenarios with Comboboxes here and here . Last post on this topic we implemented a one-to-many data entry form Read More...

Postedby Beth Massi | 50 Comments    

Filed under: Visual Basic, LINQ, VS2008, Winforms, DevCenter, Article, Data

One-To-Many (Master-Detail) Forms with LINQ to SQL
19 February 08 03:11 PM

In previous posts this month I showed how to use LINQ to SQL classes with a couple different Combobox data binding scenarios. (You can read those articles here and here .) Today I'm going to show you how to create a one-to-many data entry form (and we'll Read More...

Postedby Beth Massi | 61 Comments    

Filed under: Visual Basic, LINQ, VS2008, Winforms, DevCenter, Article, Data

Creating Lookup Lists with LINQ to SQL
07 February 08 09:00 AM

In yesterday's post I showed you how to bind LINQ to SQL classes to a Combobox in order to filter records on a one-to-many form. Today I want to show you how how you can use a Combobox as a lookup list in order to edit values on a record. We'll be building Read More...

Postedby Beth Massi | 23 Comments    

Filed under: Visual Basic, LINQ, VS2008, Winforms, DevCenter, Article, Data

Related Data Binding and ComboBoxes with LINQ to SQL
06 February 08 02:07 PM

In a previous post I showed how to set up related data binding using ComboBoxes against DataSets and a loyal reader asked how this would be done using LINQ and Visual Studio 2008. I assume he meant LINQ to SQL in this case, because remember LINQ can be Read More...

Postedby Beth Massi | 35 Comments    

Filed under: Visual Basic, LINQ, VS2008, Winforms, DevCenter, Article, Data

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    

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

Attachment(s):ImportExportExcel.zip