OK, let me preface the issue I am going to describe by saying I am a total noob to programming. I've been taking a class in VB.NET where we were using VB2008 but I couldn't get it to install on my Win7 system so I downloaded VB2010 Express. I already had MS Office Access installed and working.

OK, I start taking this class. The textbook is "Clearly Visual Basic" for VB2008. Every time I start working on a project Visual Studio pops the conversion wizard to upgrade the project for use on my platform. I've had no problem, other than my own learning curve, getting the projects I downloaded from the author's site to work. Until I hit the chapter where we start using databases, the one chapter I am most interested in learning.

I open the downloaded project, convert it, go through the fairly simple steps to set up a DataGridView on a form. I went through the connection wizard to set up the new database connection, selected my data source and configured it by the instructions. I tested the connection, no problem so far. I used the connection string for Access by the book, checked the boxes in the proper table and away we went. All the code produced and the objects in the tray look right, everything seemed exactly as it should. But it doesn't work.

When I run the project I get the form to pop up, it shows the column headings for all the fields in the records, but no data appears at all. Zero records according to the BindingNavigator. I can do a Data Preview and see all the records just fine, but my form does not display any of them.

I'm lost, no idea how to troubleshoot this. I opened a couple of other projects from this chapter and seem to have the exact same problem with them. My code is below:
vb.net Code:
  1. ' Name:         Raye Industries Project
  2. ' Purpose:      Display the records stored in a database
  3. ' Programmer:   <your name> on <current date>
  4.  
  5. Public Class frmMain
  6.  
  7.     Private Sub TblEmployBindingNavigatorSaveItem_Click(sender As System.Object, e As System.EventArgs) Handles TblEmployBindingNavigatorSaveItem.Click
  8.         Me.Validate()
  9.         Me.TblEmployBindingSource.EndEdit()
  10.         Me.TableAdapterManager.UpdateAll(Me.EmployeesDataSet)
  11.  
  12.     End Sub
  13.  
  14.     Private Sub frmMain_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
  15.         'TODO: This line of code loads data into the 'EmployeesDataSet.tblEmploy' table. You can move, or remove it, as needed.
  16.         Me.TblEmployTableAdapter.Fill(Me.EmployeesDataSet.tblEmploy)
  17.  
  18.     End Sub
  19. End Class
As you can see, this is diapers-grade programming, and I've been through the whole routine three times with the same result, so I don't think I am doing anything wrong. There seems to be some problem running VB2008 stuff on VB2010 when you have database access. Any advice or suggestions is greatly appreciated.

Thanx in advance,
CC