RE:Codigo para conectarme a ado.net
Hola yo utilizo este codigo, y espero que te sirva.
Imports System.Data.OleDb
Public dbDataAdapter As OleDb.OleDbDataAdapter
Public dbconexion As New OleDbConnection()
Public dbDataSet As DataSet
Public strconexion As String
strconexion = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Archivos de programa\Nombre_Base_Datos.mdb"
dbconexion = New OleDbConnection(strconexion)
dbconexion.Open()
dbDataAdapter = New OleDbDataAdapter("Select * from
Nombre_TABLA ", dbconexion)
Dim CB As OleDbCommandBuilder = New
OleDbCommandBuilder(dbDataAdapter)
dbDataSet = New DataSet()
dbDataAdapter.Fill(dbDataSet, "NOMBRE_TABLA")
dbconexion.Close()