ASP.NET -> Access Database Queries

[Guest]

Hi. I specifically need to yse MS Access behind a bunch os ASP.NET 2.0 pages.
I'd prefer to have those pages use the MS Access file's QUERIES rather than
accessing the tables directly. So I have two questions:

1. How do I write, for example, an INSERT query in Access so that it takes
parameters?

2. How do I use OleDB stuff from ASP.NET to build the command that uses the
MDB's Query and fills in the MDB Queries parameters?

A very simple example would be MOST appreciated!

Alex

 

[Chirag Shukla]

Hi. I specifically need to yse MS Access behind a bunch os ASP.NET 2.0 pages.
I'd prefer to have those pages use the MS Access file's QUERIES rather than
accessing the tables directly. So I have two questions:

1. How do I write, for example, an INSERT query in Access so that it takes
parameters?

2. How do I use OleDB stuff from ASP.NET to build the command that uses the
MDB's Query and fills in the MDB Queries parameters?

A very simple example would be MOST appreciated!

Alex

1) http://support.microsoft.com/default.aspx?scid=kb;en-us;304352
http://www.meadinkent.co.uk/aquerychoose.htm
http://forums.devarticles.com/micro...49/ms-access-2000-parameter-queries-1096.html
http://www.google.com/search?source...003-36,GGLD:en&q=MS+ACcess+queries+parameters

2)
http://www.aspfree.com/c/a/ASP.NET/Query-Parameters-and-Information-Handling-with-Databases/
http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/VB_DOT_NET/Q_21802486.html
http://www.devcity.net/Articles/34/1/.aspx

Chirag Shukla.