|
| Submitted on: |
11/17/2003 6:27:24 AM |
| By: |
Shannon Harmon
|
| Level: |
Intermediate |
| User Rating: |
By 25 Users |
| Compatibility: |
ASP (Active Server Pages) |
| Views: |
26492 |
|
(About the author) |
|
|
|
Demonstrate how to use ADO and ASP, includes Paging, Editing, Searching, Stored Procedures with MS Access and more.
|
 |
| |
|
 Download code
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
- Re-scan downloaded files using your personal virus checker before using it.
- NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
|
Terms of Agreement:
By using this code, you agree to the following terms...
- You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
- You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
- You may link to this code from another website, but ONLY if it is not wrapped in a frame.
- You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
|
Other 3 submission(s) by this author
|
|
Report Bad Submission
|
Your Vote
|
| |
Other User Comments
|
 11/17/2003 6:31:25 AM: Shannon Harmon
Original less complicated example can be found here.
http://www.pscode.com/vb/scripts/showcode.asp?txtCodeId=7079&lngWId=4
(If this comment was disrespectful, please report it.)
|
11/18/2003 1:33:30 PM:
Thank you very much for sharing this great learning tool with PSC community,this code really helps me a lot,I gave you a 5.
(If this comment was disrespectful, please report it.)
|
11/20/2003 2:02:10 AM:
this example is very good .. i like it alot.. its very clean.. howvever it seems complicated..., the code and all those queries in the db... abit more advanced than your previous example. nevertheless an excellent example, and thanks for sharing your code with us.. i gave u a five
(If this comment was disrespectful, please report it.)
|
11/20/2003 2:30:51 AM: Shannon Harmon
I realize that it is probably a bit more advanced and I probably should have written actual documentation breaking everything down before posting it. I'll get the SQL Scripts and documentation together this weekend.
(If this comment was disrespectful, please report it.)
|
12/24/2003 5:29:38 AM:
COOL !!! ;o)
(If this comment was disrespectful, please report it.)
|
2/4/2004 5:03:39 PM: Ed Ruth
Wow! That's great stuff. 5 Stars defintely.
(If this comment was disrespectful, please report it.)
|
2/8/2004 3:04:42 PM:
Awesome! Beautiful code.
Are the MS SQL Scripts out yet?
Thanks.
(If this comment was disrespectful, please report it.)
|
3/21/2004 7:50:01 AM:
Thanks for free codes.
(If this comment was disrespectful, please report it.)
|
4/17/2004 6:53:57 PM:
really thankful, i was just searching for how to establish a database connection..and this exampleeeeee!!!!!!
gave me a lot moreeeeee
i was just writing queries in my asp page, but this example shows how to use access queries, this is what i am very much happy about, now i need not have to see whether i have closed the queries correctly, in my asp page,, thank u a lot
(If this comment was disrespectful, please report it.)
|
5/25/2004 9:42:35 AM: Joaquim Ponte
five for u.
(If this comment was disrespectful, please report it.)
|
8/12/2004 1:25:08 PM:
nice code!
thanks for sharing it'
im sure this will help not only
me but also those who have trouble
in ASP's
thanks! a lot. . . . 101010000111
(If this comment was disrespectful, please report it.)
|
4/14/2005 2:55:10 PM: priyank modi
hey its looks really nice
i am also a programmer of this site and like ur project very much.
priyank modi
(If this comment was disrespectful, please report it.)
|
10/18/2005 10:24:41 PM: Aeric
Great example. Thank you very much. I hope I can learn more about CSS to make it look nicer. I try to modify your coding to suit my need but i have a problem. I changed the database Categories table from autonumber ID field to CatID field with Text type which is a primary key field. Then i can't insert new records. Can you please email to me the code?
(If this comment was disrespectful, please report it.)
|
11/8/2005 3:32:45 AM: Aeric
Thanks Shannon for last reply. I have another problem now. For the stored procedure in Update function,
The following line is to post a TEXT value to the Database:
.Parameters.Append .CreateParameter("pDescription", adVarWChar, adParamInput, 255, m_strDescription)
The Text data type has limit size of 255 characters in MS Access. If I want to use Memo data type, what should I change?
(If this comment was disrespectful, please report it.)
|
3/2/2006 10:38:59 AM: Oscar Oliva
This is an excellent work. Thank you for your code, because I learn many things from your sample code. I don't have formal schooling in programming but the excellent work of members like you are greatly helping others to learn programming. I have use some of your sample in the website that I created.
(If this comment was disrespectful, please report it.)
|
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
To post feedback, first please login.
|
