Visual Basic Power Packs also included with Visual Studio 2010

If you’re like me and used to having line & shape controls, PrintForm and a handy DataRepeater as part of your toolbox then you’ll be excited to know that these controls are also going to be installed with Visual Studio 2010. On Friday, Yunfeng Dong mentioned on the VS Data team blog that the VB… Read more

Using TableAdapters to Insert Related Data into an MS Access Database

I’ve posted before about how to use TableAdapters to update parent-child (master-detail) relationships against SQL server. It’s pretty straightforward and Visual Studio generates all the code for you to properly insert, update and delete your data. However if you’re using MS Access then there’s one thing that Visual Studio doesn’t do because it’s not supported… Read more

Tally Rows in a DataSet that Match a Condition

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 to see if you can coax it into returning… Read more

Editing Data from Two Tables in a Single DataGridView

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 the problem is that we want… Read more

Data on the Smart Client Talk at Bay.NET UG

Last night I spoke to SF Bay.NET user’s group on Data Binding in Winforms and WPF, focusing on Line-of-Business (LOB) application scenarios. I showed how you can use the same data sources with Winforms and WPF, walking through binding scenarios with DataSets, custom object collections and some LINQ to SQL classes. I showed the common… Read more

LINQ to SQL N-Tier Smart Client – Part 3 Database Transactions

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 to SQL N-Tier Smart Client – Part 2 Building… Read more

LINQ to SQL N-Tier Smart Client – Part 2 Building the Client

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 our middle-tier built it’s time to add the service reference… Read more

LINQ to SQL N-Tier Smart Client – Part 1 Building the Middle-Tier

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 (Master-Detail) Forms with LINQ to SQL Simple… Read more

Simple Validation with LINQ to SQL Classes

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 and I showed how to work with… Read more

One-To-Many (Master-Detail) Forms with LINQ to SQL

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 use a couple Combobox lookup lists as well). I’ll show you… Read more