I got syntax error: OleDbConnection not defined. Needs help Thanks.

Imports System.Data
Public Class Form1
Dim myConn As OleDbConnection = New OleDbConnection();
myConn.ConnectionString="Provider=Microsoft.Jet.OL EDB.4.0;Data Source=C:\vbcl\My1.acdb;"
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim YesNo As DialogResult
YesNo = MessageBox.Show("Do you want to save this file?", _
"Are you sure?", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question)
'Select YesNo
End Sub
End Class

you need to define the connection inside a function or sub routines. AFAIK you cannot define the connection parameters in a global variable

Can you please give me an example

public function afunction() as boolean

myConn.ConnectionString="Provider=Microsoft.Jet.OL EDB.4.0;Data Source=C:\vbcl\My1.acdb;"
end function

dim myCnn as new conenction 'not to sure the declaration for this you may need to go with dim myconn as object

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
myConn.ConnectionString="Provider=Microsoft.Jet.OL EDB.4.0;Data Source=C:\vbcl\My1.acdb;"
Dim YesNo As DialogResult
YesNo = MessageBox.Show("Do you want to save this file?", _
"Are you sure?", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question)
'Select YesNo
End Sub

you may need to set the connection
you may find it better to examine the connection object and see if it is valid, and if not initialise it correctly. the on line documentation is pretty good for this sort of problem

ok. Thanks

Check your import again. Also, make sure you don't have the "client framework" selected as your project version. For some bizarre reason projects will sometimes default to using the client framework instead of the full 3.x-4 framework. The client version is greatly pared down, I'm not sure if everything from System.Data is included or not.

healdem is also correct. Once it stops complaining about not knowing what an OleDbConnection is, it will start complaining about you trying to manipulate private fields/members outside of a method or event. You'll probably want to set that connection string either in the form's constructor (winforms) or onload (asp.net)


Noticed one more thing: I don't think VB likes you using semicolons as line delimiters. It's been a while since I switched to C#, but it could be complaining about that as well.