i am creating an online sales and inventory system as a project for college...sales system will be online while the inventory system is a windows application tht's only for the staffs' usage...i am using visual studio .net 2003 (VBScript) programming language and MS Access xp pro...i want to know how to link access to .net. I also want to know if i use the windows application for inventory subsystem and use the ASP.Net web application...how do i link both systems to each other?? Please help!!URGENT!!
2006-07-20 02:21:46 · 3 answers · asked by braich_gal 3 in Computers & Internet ➔ Programming & Design
ASP.Net web application is used for the online sales subsystem
2006-07-20 02:24:21 · update #1
The access database is the common object for both. The database will have all of your data. You can connect both to the access database via a connection string. The connection string will look similar to this:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\USER\My Documents\db1.mdb;Persist Security Info=False
You will be using a connection object in both applications and the connection string will link it to the database.
So the linkage will be that your applications can access the same tables.
2006-07-20 02:32:10 · answer #1 · answered by Anonymous · 0⤊ 0⤋
I do not have experience with ASP.Net, but I can tell you the basics of how to link Visual Studio .net to MS Access. You have to use Access first and create tables for your database. You should also enter all of the information for your inventory into the database at this point too. Then save the database and a .mdb file should be created. Now you need to load Visual Studio and the project you are working on. On the left side you will see the tool to add connections to your project. Add a connection and use oledb as your connection method. You now have to create a dataset. That option is on the left side in your tools. There is more to do after that depending on how you want your program to behave. I recommend buying a book. The one I have is called Advanced Visual Basic .NET, ISBN# 0-13-089367-6. The book also has information on using ASP.NET. What you are attempting to do is not as easy as you would think it would be. It took me several frustrating nights to start to get the hang of creating a connection to an Access database that worked correctly. Good luck!!
2006-07-20 09:49:18 · answer #2 · answered by believer 3 · 0⤊ 0⤋
For the most part to connect to a database in .NET you use ADO.NET and to accoplish a conection you can use the following using the 'popular' "Northwind" Database
<%@ Import Namespace="System.Data.OleDb" %>
do not forget the namespace as it is required to work with DB objects like Access.
to access the data from a query bind the data to repeater like the following: