当前位置: 首页 > 图文教程 > 网络编程 > ASP > 一个普通的数据库例子源源程序

ASP
从文本文件中读取信息并存储入数据库
文本搜索
FileSystemObject处理文件
设计 FileSystemObject
处理驱动器和文件夹
用ASP做一个TOP COOL的站内搜索
怎样读取一个文本文件的内容?
在线用表单建立文件夹
filesystemobject组件的用法示例
ASP中文本文件与数据库文件的数据交换(FSO)
读取目录下的所有文件(包括子目录下的所有文件)
ASP中FSO的神奇功能 - FSO不能做到的
ASP中FSO的神奇功能 - 用FSO进行内容管理
ASP中FSO的神奇功能 - 使用FSO进行搜索
ASP中FSO的神奇功能 - 权限许可
ASP中FSO的神奇功能 - 文件读取
ASP中FSO的神奇功能 - 写文件
ASP中FSO的神奇功能 - 简介
读取目录下的文件得到一个数组
奇妙的文件系统对象组件

ASP 中的 一个普通的数据库例子源源程序


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-11-03   浏览: 150 ::
收藏到网摘: n/a

 
     To assist in interfacing with databases. This script can format variables and return SQL formats.
Such as double quoting apposterphies and surrounding strings with quotes, Returning NULL for invalid data
types, trimming strings so they do not exceed maximum lengths. This also has some functions so that you
can open and close databases more conveiently with just one line of code. You can query a database and get
an Array as well with some code.


  
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!



    '**************************************
    ' for :Common Database Routines
    '**************************************
    Copyright (c) 1999 by Lewis Moten, All rights reserved.


code:
Can't Copy and Paste this?
Click here for a copy-and-paste friendly version of this code!



    '**************************************
    ' Name: Common Database Routines
    ' Description:To assist in interfacing w
    '     ith databases. This script can format va
    '     riables and return SQL formats. Such as
    '     double quoting apposterphies and surroun
    '     ding strings with quotes, Returning NULL
    '     for invalid data types, trimming strings
    '     so they do not exceed maximum lengths. T
    '     his also has some functions so that you
    '     can open and close databases more convei
    '     ently with just one line of code. You ca
    '     n query a database and get an Array as w
    '     ell with some code.
    ' By: Lewis Moten
    '
    '
    ' Inputs:None
    '
    ' Returns:None
    '
    'Assumes:This script assumes that you at
    '     least have Microsoft ActiveX Data Object
    '     s 2.0 or Higher (ADODB). This script may
    '     get some getting used to at first until
    '     you go through and study what each routi
    '     ne can do.
    '
    'Side Effects:None
    '
    'Warranty:
    'code provided by Planet Source Code(tm)
    '     (www.Planet-Source-Code.com) 'as is', wi
    '     thout warranties as to performance, fitn
    '     ess, merchantability,and any other warra
    '     nty (whether expressed or implied).
    'Terms of Agreement:
    'By using this source code, you agree to
    '     the following terms...
    ' 1) You may use this source code in per
    '     sonal projects and may co