I'm new to .NET (started playing this morning).<BR><BR>Although I've created a very simple class from one of the examples on 4guys, I can't seem to use the OleDb stuff correctly.<BR><BR>I'm following the example in the SDK:<BR>Public Sub ReadMyData(myConnString As String)<BR> Dim mySelectQuery As String = "SELECT OrderID, CustomerID FROM Orders"<BR> Dim myConnection As New OleDbConnection(myConnString)<BR> Dim myCommand As New OleDbCommand(mySelectQuery, myConnection)<BR> myConnection.Open()<BR> Dim myReader As OleDbDataReader<BR> myReader = myCommand.ExecuteReader()<BR> ' Always call Read before accessing data.<BR> While myReader.Read()<BR> Console.WriteLine(myReader.GetInt32(0).ToString() + ", " _<BR> + myReader.GetString(1))<BR> End While<BR> ' always call Close when done reading.<BR> myReader.Close()<BR> ' Close the connection when done with it.<BR> myConnection.Close()<BR>End Sub<BR><BR>However, when I try and compile I get "Type not defined" for OleDbConnection, OleDbCommand and OleDbDataReader. I am importing System and Microsoft.VisualBasic. I have tried importing the System.Data.OleDb namespace by name and it does nothing to help.<BR><BR>I've installed MDAC 2.7 as I thought this may be the problem. There a chance that I've installed the framework and don't have the OleDb drivers needed?!<BR><BR>I also would like to know how to get access to the Response/Request objects. I have found something on the HTTPResponse object, which I assume is correct. However, there are no working examples of writing to the browser from within a subroutine inside a class. Anyone know of any?<BR><BR>I'm quite proficient in VB/ASP, and wish to keep coding ASP.NET in VB rather than C#.<BR><BR>Anyone help?!<BR><BR>Craig.
OleDb
- Thread starter Szgzjtqsy
- Start date