Hi everyone, I am new so

(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. 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

Hi there.. i dont have a clue about your problem.. everything looks ok.. but you are in the wrong forum.. try reposting in the .net forum!

HTH

Gonzalo

Hi,

what you need to do is have a data control on the page and have all that linked up and then put a msFlexGrid on the page and make shore that the recordset is set to see the data control this will work garunteed if it is still wrong then i'll give you the vb project

I hope it goes well,
Apocolypse