关于RecordSet的一些使用方法

本文详细介绍了使用ADO RecordSet对象进行数据库操作的方法,包括创建记录集、添加字段、打开记录集、添加新记录、更新记录及查找记录等关键步骤。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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

 

DataType EnumValueAccessSQLServerOracle
adBigInt20 BigInt (SQL Server 2000 +) 
adBinary128 Binary
TimeStamp
Raw *
adBoolean11YesNoBit 
adChar129 CharChar
adCurrency6CurrencyMoney
SmallMoney
 
adDate7DateDateTime 
adDBTimeStamp135DateTime (Access 97 (ODBC))DateTime
SmallDateTime
Date
adDecimal14  Decimal *
adDouble5DoubleFloatFloat
adGUID72ReplicationID (Access 97 (OLEDB)), (Access 2000 (OLEDB))UniqueIdentifier (SQL Server 7.0 +) 
adIDispatch9   
adInteger3AutoNumber
Integer
Long
Identity (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
Numeric
Decimal
Integer
Number
SmallInt
adSingle4SingleReal 
adSmallInt2IntegerSmallInt 
adUnsignedTinyInt17ByteTinyInt 
adVarBinary204ReplicationID (Access 97)VarBinary 
adVarChar200Text (Access 97)VarCharVarChar
adVariant12 Sql_Variant (SQL Server 2000 +)VarChar2
adVarWChar202Text (Access 2000 (OLEDB))NVarChar (SQL Server 7.0 +)NVarChar2
adWChar130 NChar (SQL Server 7.0 +) 
DataType EnumValueAccessSQLServerOracle
adBigInt20 BigInt (SQL Server 2000 +) 
adBinary128 Binary
TimeStamp
Raw *
adBoolean11YesNoBit 
adChar129 CharChar
adCurrency6CurrencyMoney
SmallMoney
 
adDate7DateDateTime 
adDBTimeStamp135DateTime (Access 97 (ODBC))DateTime
SmallDateTime
Date
adDecimal14  Decimal *
adDouble5DoubleFloatFloat
adGUID72ReplicationID (Access 97 (OLEDB)), (Access 2000 (OLEDB))UniqueIdentifier (SQL Server 7.0 +) 
adIDispatch9   
adInteger3AutoNumber
Integer
Long
Identity (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
Numeric
Decimal
Integer
Number
SmallInt
adSingle4SingleReal 
adSmallInt2IntegerSmallInt 
adUnsignedTinyInt17ByteTinyInt 
adVarBinary204ReplicationID (Access 97)VarBinary 
adVarChar200Text (Access 97)VarCharVarChar
adVariant12 Sql_Variant (SQL Server 2000 +)VarChar2
adVarWChar202Text (Access 2000 (OLEDB))NVarChar (SQL Server 7.0 +)NVarChar2
adWChar130 NChar (SQL Server 7.0 +) 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值