Connecting to Db in visual studios 2005
ASP.NET
1
Posts
1
Posters
0
Views
1
Watching
-
dim myConn as String ="Provider=Microsoft.JET.OLEDB.4.0;Data Source=C:\\\\Nwind.mdb;" dim myQuery as String = "Insert into Customers(CustomerID,CompanyName) Values ('aaaaa', 'aaaaa')" dim cn as new OleDbConnection(myConn) cn.Open() dim cmd as new OleDbCommand(myQuery, cn) cmd.ExecuteNonQuery() cn.close()
Howcome the above doesn't work in visual studios 2005? When i try to make a OleDbConnection type it doesn't exist and I even tried inherits System.Data.OleDb and I don't see an OleDb in there. Has this been removed from the 2005 version and if so how do it now via code? Basically what i'm wanting to do it make a database connection so i can check authentication thru a login.apsx file but i'm stuck at this step. thanks for the help in advance. Win32newb "If I wrote a book like I code. It would be one page thick and contain only one word (DUH!)"