Tengo este codigo para conectarme a una base de datos... me da error
Imports System
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.HtmlControls
Imports System.Data
Imports System.Data.OleDb
Public Class pruebanet
Inherits page
Dim ConnectionString As String= "Provider=SQLOLEDB.1;" & _
"Data Source = ***;" & _
"Initial Catalog = ***;" & _
"User Id = ***;" & _
"Password = ***l"
Dim MyConnection As New OleDbConnection(ConnectionString)
Dim Mycommand As New oleDbCommand ("Select * from tabla", Myconnection )
Dim MyReader As OleDbDataReader
MyConnection.Open
MyReader = MyCommand.ExecuteReader ()
MyReader.Read
lstNames.Items.Add(MyReader("Nombre"))
MyReader.Close
MyConnection.Close
End Class
el error es el siguiente
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC30188: Declaration expected.
en la linea 25 la cual es
MyConnection.Open
estoy siguiendo paso a paso un libro de ASP.NET y de verdad alli me quedo trancadoooooo
por favor ayudenme.
los datos de la base de datos obiamente los quite...