linking access to asp.net

[ashley.s]

Hello All,
I have an access database with several menus and reports. What I want is put that on an asp.net site so that everyone can access it. Can you please give me some guidelines?

[sapator]

Basically you will have to rewrite a lot of stuff, especially on the controls side.
You better tell us more on what u use.

[jdogg]

There is alot that needs to be written, first you need to get a connection string for the database you are using. then you need to make a new connection, open the connection, run the commands that you want, and when your done, close the connection.

The MSDN site is pretty helpful on the subject

http://msdn.microsoft.com/en-us/library/ax3wd0k9.aspx

[gep13]

Hello,

Take a look at the links in my signature regarding ADO.Net. This is what you will use to create a connection between your Access Database and your ASP.Net application.

Gary

[ashley.s]

Hello All,
Thank you for your reply. In the access database, there is a switchboard (menu) and this switchboard leads to different reports and forms. So i was thinking whether it is possible to put this on a website so that everyone can access. I am a vb beginner. So can that be done with asp.net? Just like I am going to through the access database through MS access, is it possible to go through it using asp.net? I hope I can explain myself well. I really need your help

[jdogg]

Not quite sure what you mean when you say go through...my take on it is you would like to be able to view that on your webpage? If that's what you mean then yes you can, once you establish the connection with the DB, you can code in query's with VB that will run when user performs a certain action. not sure about switchboards though, never used them myself, but it should be possible. Not sure how to write the selection for VB as I am new to it as well. I know for C# it goes like this:

String selectionString = "SELECT * FROM table_name"; you can add specific columns and add where clauses just like in SQL. it has been awhile since I have written queries in asp.net right now I have the query written in SQL using SQL Developer which I link to the project I am running. but you should be able find lots of examples using google.

[sapator]

If i understand switchboard correctly you may wan to take a look at asp TabContainer.Don't expect "forms" to be make as per winforms.You will probably have to use CSS to design them proper.What else,err, Access, well Access is bad for your health, you can use sql express.Also be ware that with every page postback you will loose any stored values unless you store them first.
I suggest you do a basic read on asp.net because there isn't really a key point that will help you.You better leave your application for now a do a basic read.

[gep13]

Hello All,
Thank you for your reply. In the access database, there is a switchboard (menu) and this switchboard leads to different reports and forms. So i was thinking whether it is possible to put this on a website so that everyone can access. I am a vb beginner. So can that be done with asp.net? Just like I am going to through the access database through MS access, is it possible to go through it using asp.net? I hope I can explain myself well. I really need your help

Put simply, no. You wouldn't want ASP.Net to go through MS Access. ASP.Net, using ADO.Net will communicate directly with the underlying .mdb file, which is actually what stores the Relational Data that is your Database.

As sap has mentioned, you are not going to get anything for "free" when you port your application database into ASP.Net. You are going to have to take control of creating the displays for the data that you might have got for "free" when you used MS Access.

Gary