Browse by Tags

All Tags » Article » LINQ » DevCenter   (RSS)
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: , , , , , ,
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: , , , , , ,
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: , , , , , ,
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: , , , , ,
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: , , , , , , ,
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: , , , , , , ,
Tally Rows in a DataSet that Match a Condition
27 April 09 07:24 PM
Today I got a question that comes up often in data application programming about how to count rows in a DataSet that matched a condition. The DataSet may be bound to a DataGridView or other list control and it’s tempting to start looking at the control Read More...
Postedby Beth Massi | 8 Comments    
Filed under: , , , , ,
ADO.NET Data Services - Intercepting Queries and Adding Validation
21 January 09 08:53 PM
Last few posts I've been building a WPF client against ADO.NET Data Services, if you missed them: Using ADO.NET Data Services ADO.NET Data Services - Building a WPF Client ADO.NET Data Services - Enforcing FK Associations and a Fix for Deleting Entities Read More...
Postedby Beth Massi | 6 Comments    
Filed under: , , , , , , , ,
Editing Data from Two Tables in a Single DataGridView
15 October 08 06:31 PM
I've had a lot of questions lately on how to display data from two separate tables in the database into a single DataGridView for editing. It sure would be nice if all our data was in a single table, but in reality most of the time it's not. Basically Read More...
Postedby Beth Massi | 24 Comments    
Filed under: , , , , , , ,
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    
Filed under: , , , , ,
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    
Filed under: , , , , ,
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    
Filed under: , , , , ,
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    
Filed under: , , , ,
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    
Filed under: , , , ,
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: , , , , , , , ,
More Posts Next page »

This Blog

Syndication

Bookmark and Share

Add to Technorati Favorites


Your Host:
Me!
NOTE: The opinions expressed here are MY OWN and are not necessarily those of my employer, partners, customers, friends, or family. ALL content presented AS-IS, for entertainment purposes only with ABSOLUTELY NO WARRANTY expressed or implied.
Page view tracker