Yesterday I created a Code Gallery project with a couple videos on WPF data-based app development in Visual Studio 2008. I’m starting a series on WPF directed at LOB developers building data-oriented applications. These videos show how to work with data, they don’t show you how to create fancy UIs.
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 to the client project.
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 Validation with LINQ to SQL Classes
These articles focus on the binding and validation and use a connected model;
Check it out, on the ADO.NET Team blog Faisal Mohamood, a PM on the LINQ to SQL team, posted on the new features you can expect to see added to LINQ to SQL. This includes support for new data types coming in SQL 2008.
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).
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.
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,
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 transactions or the TransactionScope to update your data properly using Visual Studio 2005.
Recently I was sent a question about how to read from a serial port and save the information to a database so instead of following up privately I thought I’d post my answer here. There’s a good article in the MSDN Library that has some hints on how to do this with the System.IO.Ports.SerialPort class.
This how-to video series is dedicated to getting Visual Basic developers productive on areas of data-based Windows Application development. The series starts with the basics of database development with SQL-Server 2005 Express then walks through the details of connecting to and querying databases,