Browse by Tags

• DevCenter
• LINQ
• N-tier
• SQL Server
• Visual Basic
• VS2005
• VS2008
• WCF

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 | 8 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 | 19 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 | 31 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 | 39 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 | 14 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 | 23 Comments    

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

Using Data Across Multiple Windows Forms
01 October 07 11:11 AM

Recently I've had more than a few questions about how to handle working with data across multiple forms. If you've watched my Forms over Data video series you know how to create a database , connect to it , save your data properly , and work with data Read More...

Postedby Beth Massi | 18 Comments    

Filed under: Visual Basic, VS2005, Winforms, DevCenter, Article, Data

Attachment(s):MultiFormSample.zip

Resizing Images Stored in SQL-Server
28 August 07 11:35 AM

In SQL-Server we can store images inside database tables directly using the Image column type. And with .NET 2.0 data binding it can automatically convert these images (stored as byte arrays) into System.Drawing.Image classes for you. For instance, say Read More...

Postedby Beth Massi | 21 Comments    

Filed under: Visual Basic, SQL Server, Winforms, Article, Data

Attachment(s):PictureResizing.zip

Building a Secure Login Form (Parameterized Queries Part 2)
06 June 07 10:48 PM

In my first post on parameterized queries I built a simple login form that really was a contrived example meant to showcase how to use the TableAdapter Configuration Wizard to configure a parameterized query. However, since I opened myself up here, I Read More...

Postedby Beth Massi | 22 Comments    

Filed under: Visual Basic, VS2005, SQL Server, Winforms, Article, Data

Attachment(s):LoginClient.zip

Many-to-Many Data Binding
30 May 07 11:25 AM

In my Forms over Data videos series I show you how to create a one-to-many data entry form in video #3. Recently, I've had a few people ask how to create a form that displays a many-to-many relationship so I thought I'd post on how to do that today. You Read More...

Postedby Beth Massi | 18 Comments    

Filed under: Visual Basic, VS2005, Winforms, Article, Data

Creating a Parameterized Query
25 May 07 01:23 PM

I've been asked by a couple readers on how to pass parameters into a SQL statement to your database using the TableAdapters. I actually created a video on how to do this in the context of a search query ( play video | download video | entire series ). Read More...

Postedby Beth Massi | 31 Comments    

Filed under: Visual Basic, VS2005, Winforms, Article, Data

Tips on Related Data Binding and ComboBoxes
25 April 07 10:30 AM

I've been noticing a lot of questions on the forums related to Winforms data binding and the ComboBox and I thought I'd post something up here to help people out. In fact data binding, or what we call “Windows Forms over Data” is a huge, sometimes misunderstood, Read More...

Postedby Beth Massi | 21 Comments    

Filed under: Visual Basic, VS2005, Winforms, Article, Data