vb- can't load data into data grid from Access db

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi everyone,

(Visual Basic) I am having a problem loading data into data grid on my form
in Visual Studio from an Access db. Here is the line of code:

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
DsStudent1.Clear()
OleDbDataAdapter1.Fill(DsStudent1)



When I try to run it I get:

An unhandled exception of type 'system.Data.OleDb.OleDbException
occured in system.data.dll

That last line of code is highlighted in debug mode

I've got my connection, adapter, and dataset.i have tested my connection and
it works. I have set the data source and data members correctly to my ds.
When I go to Preview Data, then click fill data set, it works fine. Just
won't load to form. Tried using a button instead but still nothing. I am
pretty positive that my steps to connect are right.

Could it have something to do with the MSDE? I can't so much locate it on my
machine. I thought I had it but after looking, couldn't find it, so I
downloaded it from microsoft. But still no luck. Then had to enable file and
printer sharing and tried again. Looked in services under administrative
tools for a stand in of a SQL server instance, but didn't even see one? I bet
it is something easy, but I have spent sooooo many hours trying to figure it
out

Quick replies are so very much appreciated. Thanks sooooooooooo much

~C

.

Quantcast