Web Application with an MS Access Database

Question

Good day

I'm trying to create a web application in MS Visual Studio 2010 Ultimate. The web application must also access (select, insert) a MS Access Database. I have made a normal windows form application in Visual Studio with an access database but I have no idea how to to that in a web application. I must use a MS Access database. I am using Office 2013 and C# as my Visual studio language.

Can anyone please help me with some steps to set up this database connection?

Thank you in advance!

Answer 1

Take a look at this Walkthrough: Creating a Web Page to Display Access Database Data.

This is a good place to start. You can ignore/substatute "Visual Web Developer tool", Visual studio Ultimate has this built into it.

Mike

Answer 2

Thank you very much that was what I was looking for!

Another question: How can I select items from the gridview and add them to another table? The app I am making must list products sold by a business to the customer and the customer must then select  the items he wants to buy. These items must then be added to the table (shopping basket). But the item must remain in the gridview (database) so that the customer can click on it again and then increase the quantity in the basket table.

Any ideas? I'm really struggling to work with the databases in an website application. I have only worked with it in normal windows form applications..