Browse by Tags

All Tags » Data » Visual Basic » VS2005   (RSS)
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: , , , , ,
Attachment(s):MultiFormSample.zip
Forms Over Data Video Series - Two More Videos Released
01 August 07 04:34 PM
I just released two more videos ( #15 , #16 ) in the Forms Over Data video series . One is on understanding data binding and how it works from database all the way to the controls you see on forms. We talk about the relationship between the TableAdapter, Read More...
Postedby Beth Massi | 75 Comments    
Filed under: , , , , ,
Attachment(s):FormsOverDataCode15-16.zip
TableAdapters and Transactions
11 July 07 02:34 PM
In my last post I showed you how to save related parent-child DataTables in proper update, insert and delete order by controlling how the TableAdapters saved the rows. In this next post I'll demonstrate how we can do this inside a database transaction. Read More...
Postedby Beth Massi | 23 Comments    
Filed under: , , ,
Attachment(s):NorthwindTransaction.zip
Working with TableAdapters and Related DataTables
10 July 07 02:28 PM
This past couple weeks I've been asked to help out a few people in the community work through a couple snags they were having with respect to the TableAdapters and how they should work in a multi-user application when updating related parent-child tables. Read More...
Postedby Beth Massi | 25 Comments    
Filed under: , , ,
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 | 24 Comments    
Filed under: , , , , ,
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 | 26 Comments    
Filed under: , , , ,
Working with a Local Data File in VS
29 May 07 05:23 PM
Visual Studio 2005 made some big improvements in the way applications work with data, from BindingSources to the Data Sources Window all the way to a free version of SQL-Server called SQL-Server Express . I've had a few customers get stuck on using SQL-Server Read More...
Postedby Beth Massi | 16 Comments    
Filed under: , , , ,
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 | 34 Comments    
Filed under: , , , ,
Reading from a Serial Port and Saving to a Database
05 May 07 09:14 AM
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 Read More...
Postedby Beth Massi | 6 Comments    
Filed under: , , , ,
Attachment(s):ReadFromSerialPort.zip
Visual Basic How-To Video Series is Online
04 May 07 11:48 AM
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 Read More...
Postedby Beth Massi | 15 Comments    
Filed under: , , , , , ,
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 | 23 Comments    
Filed under: , , , ,
SQL Server Express Video Series
03 April 07 11:25 AM
If you're new to SQL Express , Reporting Services , or databases in general, you'll want to check out the SQL Server Express video series up on www.asp.net . I just finished watching them myself. These videos walk you through all the free tools you get Read More...
Postedby Beth Massi | 2 Comments    
Filed under: , , ,
Page view tracker