NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Adding records to the database with ASP
2630
Adding records to the database with ASP
http://www.stardeveloper.com/asp_addrec_1.asp
No matter what kind of site you have got, you will need your ASP pages to access databases. ASP makes it easier to work with databases by providing support for ADO ( Activex Data Objects ). You already know how to build DSN ( Data Source Name ) and then access database, if you don't then you might want to check out my tutorial on Accessing Databases via ASP.
ASP > Tips and Tutorials > Database-related
Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Adding records to the database with ASP: |
|||
Other links at ASP > Tips and Tutorials > Database-related
This article shows how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. You may already have experience using ADOX or SQL-DMO to accomplish this, but please keep in mind that the method displayed here is meant to be simple enough that anyone with ADO experience can use it. (ADOX and SQL-DMO will be addressed later.)
Category:
Active Server Pages allow us an easy means of querying and updating a database from a webpage. This article describes the basics of using this technique in a nutshell. The examples given here utilize a Microsoft Access database, but the principles elucidated apply equally well to ASP integration with other databaes. (Access has been selected because it is widely familiar, easy to use, and adequate for many small to medium-sized projects.)
Category:
Displaying an Access or SQL Server database is as easy as entering the variable names and the name of the table into the fields below. Copy the output code into an asp document on your web server and your db is ready to be displayed on the web. The DSN connection requires that you register the DSN for the db prior to executing the code. (Note: G.I.G.O Garbage In Garbage Out applies here, be certain all table elements entered appear in your db. Table elements must be entered in the select field * will not work here.)
Category:
Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.
Category:
This article is an overview of SYSTEM DSN's, DSN-LESS Connections, and any permissions that may need to be set on the server.
This article only applies to using Access Database's.
I have written this article because these issues appear to be a very confusing for people just learning ASP
This article only applies to using Access Database's.
I have written this article because these issues appear to be a very confusing for people just learning ASP
Category:
Main Category
199
2044
829
286
175
1801
1439
913
1177
7568
70
917
59
2238
175
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 19871
Categories: 1275
Registered Users: 764
Mailing List Subscribers: 2047
Unique Outgoing Hits: 231000
Pagerank Statistics
PHP News