Search Wiki:
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, Windows Forms development basics, Reporting, and Deployment using Visual Basic 2005.

Watch the Forms over Data Video Series

Please note, these videos were recorded using Visual Studio 2005 but generally apply to Visual Studio 2008. New Visual Studio 2008 videos that demonstrate the differences and new additional capabilities are also available.

Watch the Visual Studio 2008 Series

Download the code!

Discussions plese go here!

And for more information on Windows Forms development you can read my articles here or visit http://www.windowsclient.net.

UPDATE: Read this post if you are not running SQL Express and need to attach the sample databases to an instance of your sql server.
Last edited Dec 19 2008 at 1:40 AM  by BethMassi, version 10
Comments
pruthvishankar wrote  Mar 6 2008 at 8:55 AM  
I am Unable to view the videos can anyone help me out

BethMassi wrote  Mar 6 2008 at 6:01 PM  
Hi,

Most videos are in multiple formats and you can download them to your computer. Otherwise you can install Silverlight and they will play directly on the page.

HTH,
-Beth

NavedAltaf wrote  Mar 9 2008 at 3:37 AM  
Hi,

Thanks for the How Do I series which really helped me to develp applications using VS2005. Now we are migrating
from VB 6.0 to VS2005.

Regards
Naved Altaf
London On

joseph wrote  Mar 26 2008 at 8:25 PM  
Hi,
I am most impressed by your videos, they have really helped me in understanding VB.net. I was wondering how can menus be used to link a number of individual forms so that it can be presented as on package.

Regards
Joseph

BethMassi wrote  Apr 4 2008 at 3:23 AM  
Hi Joseph,

Create a new WindowsForms project and then you can right-click on your project, select Add New Item and select "MDI Parent Form" to get you started. This form contains a menu that you can take a look at how it calls other forms. Basically you can just create a new instance of the form and then call Show from the Click event of the menu.

HTH,
-Beth

p.s. EVERYONE PLEASE DISCUSS HERE: http://code.msdn.microsoft.com/vbvideosdata/Thread/List.aspx

shivaji wrote  Apr 8 2008 at 7:36 AM  
REALLY, THE BEST VIDEOS. THE BEST TEACHER FOR VS2005/SQL SERVER 2005

PL. HELP, HOW TO MAKE DYNAMIC APPLICATION USING VISUAL BASIC 2005/SQL SERVER 2005.

BESLO wrote  Apr 16 2008 at 5:31 PM  
Great video stuff, helps me a lot to learn how to deal with databases in VB 2008.

One question though: Is there a way I can get my current MS Access 2007 forms converted into VB 2K8 forms? This would save me a lot of hassle, especially when I move from the Access database to SQL-Server.

jzthepunisher wrote  Jun 29 2008 at 1:53 AM  
ponganlo en español

DavidZ wrote  Jul 16 2008 at 2:44 AM  
Hi Beth,
I am trying to copy what you did in your "How Do I create A search form?" video. I am using a microsoft access database though. I tried copying the query you had to pick a last name "LIKE @LastName + '%' but I substituted my own column names. It however does not work for me. I do not get the text box that you got in your video, just the fillby button. Is there something specific I should be doing because it is an Access database and not an SQL one? Thanks
David

Logan wrote  Sep 22 2008 at 6:11 PM  
Hi Davidz,

There's no reason to think that the query "LIKE @ LastName + '%' shouldn't work with an access database seeing as SQL is a language that is universal over all data types. It's just a query language used to access, view, and modify stored data, I'd suggest go back to the previous video (number 4 I think) and repeat the steps there, it's possible you missed something earlier on.

Hope this helps,
Logan

tomg wrote  Feb 26 at 1:01 PM  
After looking at your 1 to many data entry form, I have a second form that adds a new row to the first form, but because of the parent\ child relationship, I cant automatically assign parent table ID into Child form, can you advise.

Alexeixx3 wrote  Mar 25 at 8:40 PM  
Beth,
In video 18NTierDataApps, I wonder why you never mentioned adding a reference to northwindentities from the nothwinddal project, or was it added automatically, because in my pc it doesnt add it automatically, and i wondering why it woudnt work

AlexM wrote  May 17 at 5:14 PM  
Hi, I am currently making a web browser and I am finishing up for a big release. I am currently making a history system dependent on the SQL Server Compact 3.5 Local Database (.sdf). I have everything working but one thing. I want it so on the web1_DocumentComplete the URL and time is added to "tblHistory". Please help. Thankyou

Updating...
Page view tracker