I'm working on my first (and fairly small) web-application. One thing I'll need to do however is pull data from an Oracle database and display it (several records, 10 or so columns) to the user...maybe with a datagrid?
Anyway, I've been told the best way to connect to a database is to scrap the ASP.NET controls and do everything via code, specifically VB.NET.
I can't find any examples on an ASP site connecting to Oracle using VB.Net. I know your supposed to put your connection string inside the web.config file but I'm not sure how to reference that connection from the VB code. I'm also not sure how to execute a query and populate the datagrid on my page.
Any examples on ASP.NET data access with VB.NET (using the method listed above) would be appreciated.
Thanks.
...
Go to the complete details ...