关于RecordSet的一些使用方法

Dim RsSet Rs=Server.Createobject("ADODB.RecordSet")Rs.Fields.Append "字段名",字段类型,字段长度，字段属性'字段长度，字段属性可选，如果不设置则默认从“字段类型”继承Rs.OpenRs.addNewRs("字段名")="值"Rs.UpdateRs.Fielter="字段名='字段值'"Rs.Find "条件表达式",跳过多少行,向前搜索还是向后搜索，开始行'条件表达式和Rs.Fielter一样'跳过多少行：指从“开始行开始”，根据“向前搜索还是向后搜索”，跳过的行数'向前搜索还是向后搜索，值为adSearchForward（1），adSearchBackward（-1）'开始行，开始的行数。

字段类型可以写数字，参考表请参考http://www.w3school.com.cn/ado/ado_datatypes.asp

 

DataType EnumValueAccessSQLServerOracleadBigInt20 BigInt (SQL Server 2000 +) adBinary128 Binary
TimeStampRaw *adBoolean11YesNoBit adChar129 CharCharadCurrency6CurrencyMoney
SmallMoney adDate7DateDateTime adDBTimeStamp135DateTime (Access 97 (ODBC))DateTime
SmallDateTimeDateadDecimal14  Decimal *adDouble5DoubleFloatFloatadGUID72ReplicationID (Access 97 (OLEDB)), (Access 2000 (OLEDB))UniqueIdentifier (SQL Server 7.0 +) adIDispatch9   adInteger3AutoNumber
Integer
LongIdentity (SQL Server 6.5)
Int
 Int *adLongVarBinary205OLEObjectImageLong Raw *
Blob (Oracle 8.1.x)adLongVarChar201Memo (Access 97)
Hyperlink (Access 97)TextLong *
Clob (Oracle 8.1.x)adLongVarWChar203Memo (Access 2000 (OLEDB))
Hyperlink (Access 2000 (OLEDB))NText (SQL Server 7.0 +)NClob (Oracle 8.1.x)adNumeric131Decimal (Access 2000 (OLEDB))Decimal
NumericDecimal
Integer
Number
SmallIntadSingle4SingleReal adSmallInt2IntegerSmallInt adUnsignedTinyInt17ByteTinyInt adVarBinary204ReplicationID (Access 97)VarBinary adVarChar200Text (Access 97)VarCharVarCharadVariant12 Sql_Variant (SQL Server 2000 +)VarChar2adVarWChar202Text (Access 2000 (OLEDB))NVarChar (SQL Server 7.0 +)NVarChar2adWChar130 NChar (SQL Server 7.0 +) DataType EnumValueAccessSQLServerOracleadBigInt20 BigInt (SQL Server 2000 +) adBinary128 Binary
TimeStampRaw *adBoolean11YesNoBit adChar129 CharCharadCurrency6CurrencyMoney
SmallMoney adDate7DateDateTime adDBTimeStamp135DateTime (Access 97 (ODBC))DateTime
SmallDateTimeDateadDecimal14  Decimal *adDouble5DoubleFloatFloatadGUID72ReplicationID (Access 97 (OLEDB)), (Access 2000 (OLEDB))UniqueIdentifier (SQL Server 7.0 +) adIDispatch9   adInteger3AutoNumber
Integer
LongIdentity (SQL Server 6.5)
Int
 Int *adLongVarBinary205OLEObjectImageLong Raw *
Blob (Oracle 8.1.x)adLongVarChar201Memo (Access 97)
Hyperlink (Access 97)TextLong *
Clob (Oracle 8.1.x)adLongVarWChar203Memo (Access 2000 (OLEDB))
Hyperlink (Access 2000 (OLEDB))NText (SQL Server 7.0 +)NClob (Oracle 8.1.x)adNumeric131Decimal (Access 2000 (OLEDB))Decimal
NumericDecimal
Integer
Number
SmallIntadSingle4SingleReal adSmallInt2IntegerSmallInt adUnsignedTinyInt17ByteTinyInt adVarBinary204ReplicationID (Access 97)VarBinary adVarChar200Text (Access 97)VarCharVarCharadVariant12 Sql_Variant (SQL Server 2000 +)VarChar2adVarWChar202Text (Access 2000 (OLEDB))NVarChar (SQL Server 7.0 +)NVarChar2adWChar130 NChar (SQL Server 7.0 +)