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
Database programming
2515
Database programming
http://particletree.com/features/database-simplicity-with-class
Database programming is like a confused little monkey. Puddlin? on the floor and screaming at the walls, it?s a tedious little thing that?s prone to memory leaks and lots of errors and mistakes. To the dismay of anyone hoping to avoid a headache, database programming is ridiculously redundant and incredibly boring. Because web development loves its little monkey sooooo much, it?s unfortunately here to stay.
ASP > Tips and Tutorials > Database-related
Oct 10, 2006
Ryan Campbell
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Database programming: |
|||
Other links at ASP > Tips and Tutorials > Database-related
We can use several providers to open DBF files usind ADODB. Basic way is to use ODBC data source (DSN or DSNless), there is several samples published on web. But how to open DBF files without ODBC? There are two other OLEDB providers, using which you can work with DBF files. One of them is Microsoft.Jet.OLEDB.
Key property to work with DBF files is "Extended Properties" - there is no much info about this parameter in documentation. This parameter has similar meaning as connect parameter in DAO OpenDatabase method. First work is to open connection to DBASE IV files:
Key property to work with DBF files is "Extended Properties" - there is no much info about this parameter in documentation. This parameter has similar meaning as connect parameter in DAO OpenDatabase method. First work is to open connection to DBASE IV files:
Category:
Shuffling a recordset so that it can be displayed in random order is very useful when programming dynamic Web pages. A database table containing a list of supported vendors or links to advertisers may need to be displayed in a different order each time so that none complain about always being last on the list.
Category:
sample code below and edit the tables to match yours.
You can store images in a Database to later access them. To do that,
you have to use the following code to get the image from the database.
You can store images in a Database to later access them. To do that,
you have to use the following code to get the image from the database.
Category:
To database or not to database? What to do with uploaded files on server-side? This article contains performance tests of several store-file methods in server-side ASP.
We test store files to disk, to MDB file using ADO recordset, to MS SQL 2000 using ADO recordset and to MS SQL 2000 using SQL UPDATETEXT command
We test store files to disk, to MDB file using ADO recordset, to MS SQL 2000 using ADO recordset and to MS SQL 2000 using SQL UPDATETEXT command
Category:
The answer is shown below. All I had to do was create an object, and use "expando properties" to fill it with recordsets. The function DBGetNamedRecords takes the name of the recordset and the SQL to fill it.
Category:
Main Category
185
2034
801
286
174
1803
1129
909
1161
7393
70
905
59
2200
174
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: 19263
Categories: 1275
Registered Users: 735
Mailing List Subscribers: 2043
Unique Outgoing Hits: 228329
Pagerank Statistics
PHP News