Browse by Tags

All Tags » Data » Article » DevCenter   (RSS)
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 | 10 Comments    
Filed under: , , , , , , ,
Enabling Remote SQL Express 2008 Network Connections on Vista
17 September 08 07:30 PM
Today I spent way too long trying to enable remote network connections on my SQL 2008 Express database running on my Vista development machine so I thought I'd post the steps here. Please note that these settings may NOT be appropriate for your production Read More...
Postedby Beth Massi | 7 Comments    
Filed under: , , , ,
Editing Tabular Data in WPF - Building a WPF Grid
15 September 08 07:12 PM
In my last post on WPF I showed how you could use a Winforms DataGridView on a WPF form in order to edit data in a tabular style. Today I'll show you how you can customize the WPF ListView in order to edit data without having to use any Winforms controls Read More...
Postedby Beth Massi | 8 Comments    
Filed under: , , , , ,
Editing Tabular Data in WPF Using the Winforms DataGridView
04 September 08 04:09 PM
A pretty common requirement of any business application is to be able to edit data in a "spreadsheet" or tabular style. Usually we use some sort of data grid to do this. When building WPF applications in Visual Studio 2008 you'll notice right away that Read More...
Postedby Beth Massi | 6 Comments    
Filed under: , , , , ,
Better Data Editing Features in WPF with SP1
19 August 08 08:09 PM
One of the things I was really missing from WPF when I started to dig into data binding was feature consistency between the BindingListCollectionView and the Winforms BindingSource I had grown to love. The BindingListCollectionView provides the navigation, Read More...
Postedby Beth Massi | 10 Comments    
Filed under: , , , , ,
Displaying Data Validation Messages in WPF
27 June 08 03:57 PM
As you can probably tell from my last couple posts I've been working with WPF in different data scenarios. Yesterday I was playing with data validation in WPF and .NET 3.5 which is pretty slick. In this article I'll walk through how to hook up validation Read More...
Postedby Beth Massi | 7 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: , , , , , , , ,
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 | 13 Comments    
Filed under: , , , , , , , ,
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 | 28 Comments    
Filed under: , , , , , , , ,
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 | 37 Comments    
Filed under: , , , , , ,
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 | 54 Comments    
Filed under: , , , , , ,
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 | 16 Comments    
Filed under: , , , , , ,
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 | 25 Comments    
Filed under: , , , , , ,
The New TableAdapterManager in Visual Studio 2008
07 January 08 07:41 PM
In my previous post on TableAdapters and Transactions I showed a couple techniques on how to perform hierarchical updates inside a transaction when you have multiple related DataTables in your DataSet. The example I gave here shows how to use database Read More...
Postedby Beth Massi | 40 Comments    
Filed under: , , , ,
Attachment(s):NorthwindTransaction2008.zip
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 | 54 Comments    
Filed under: , , , , , ,
Attachment(s):ImportExportExcel.zip
More Posts Next page »
Page view tracker