Please help!!!?

Question

i want to develop an online sales and inventory system for a bookstore. the inventory system is only meant for the staff. i plan to use visual studio .net 2003 using vbscript and ms access for the d/base. can someone please help me with the code to:

1)link access to .net
2)give a sample code for login, add, delete, update and delete
3)should i use windows application or asp.net web application for the inventory system??

Answer 1

hey hi there! pretty interesting question... i've built an inventory management system for the company im working and here are some of the things you should take note before starting:
-number of users accessing
-platform the users are accessing from (MAC,WINDOWS,LINUX)

now to answer your questions:
for:
1)- I didnt use access as my database, but instead i used mysql. I have the connection string for linking ASP.NET using vbscript to connect to a mysql database. i can give you my code for that..

2) - yes i have functions to add, delete and update my inventory management system so i can pass you the source code as well. pls dont have high expectation of my codes as i did it in a quick time frame

3) - like what i asked you, what are the platforms your users will be accessing the system from? if you code in windows application, MAC and linux users will suffer. however in ASP.net, all can access as long as they have a browser. it does not matter wat browser they use, they can still obtain the functionality, only the display may matter (a button in IE may look diff in a MAC safari web browser)

hope that helps.. e-mail me: [e-mail] if you need the source code...

Answer 2

What do you mean by VB Script, I think you are going to use VB to do this?

Further Since it is a online sales system, depending on your deployment structure and need of users I would decide between a Windows or a Web Application, but the word ONLINE means it is a Web Application.

Use Forms Authentication for Login and what do you mean by add, delete , update is it for the Database?If so I am sure you can accomplish this by using ADO.

Answer 3

Take a look at the Duwamish examples from MSDN. This sounds like a large Microsoft sample application that is somewhat similar to what you are intending to develop.

Here is a link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dwamish7/html/vtoriDuwamishBooks70.asp