Hi Everyone,

All I want to do is open a access database by constructing a connection string. Then I will need a command object. I also want to use the DataAdapter to fill an object Dataset that will in turn populate a gridview control. My question is in an asp.net application where I will be using vb.net where do I put this code in the aspx file or the aspx.vb file? Also are the ADO classes or namespaces that I will need automatically imported in to my application or do I need to manually code this? I have placed code from numerous examples into the aspx.vb file and it never works. Any help with this would be greatly appreciated. And long winded answer's are welcomed because I'm thinking there is a lot I need to know before I really understand what is going on in ASP.Net.

There are many, many tutorials on the Internet regarding data access in ASP.NET, run a Google.

In short, you need a firm understand of how the ASP.NET runtime actually handles ASPX and Code behind files, once you get that, you will have answered part of your question.

As for the ADO.NET classes, the tutorials will tell you what namespaces to import etc.

What code have you tried? Why did it not work? In my opinion though, I would suggest not "running before you can walk". Get an understanding of HOW ASP.NET works, then make it work how YOU want it to :)

Rob
http://cantgrokwontgrok.blogspot.com