我在模块中声明Ado联接,在程序中向数据库中添加数据,为何总是不成功,请各位高手看看为什么?
Public MyVS(0 to 4) as string
Public MYV(0 to 4) as double
Public MyCon as Adodb.Connection
Public MyRS as Nes Adodb.Recordset
public MyCom as new adodb.command
public strsql as string
set mycon=new adodb.connection
my connectionstring="provider=microsoft.jet.oledb.3.51" &_
"data source=" & app.path & "\data\line.mdb"
mycon.open
strsql="select*from 测试数据"
myrs.cursorlocation=aduseclient
set myrs=mycon.execute(strsql))
或myrs=mycon.openresuleset(strsql)
myrs("第一次结果")=myv(0)
或myrs("第一次结果")=myvs(0))
结果总是提示错误,要么是数据类型不匹配,要么是提供者不支持。不知为什么,请你给看看。
Public MyVS(0 to 4) as string
Public MYV(0 to 4) as double
Public MyCon as Adodb.Connection
Public MyRS as Nes Adodb.Recordset
public MyCom as new adodb.command
public strsql as string
set mycon=new adodb.connection
my connectionstring="provider=microsoft.jet.oledb.3.51" &_
"data source=" & app.path & "\data\line.mdb"
mycon.open
strsql="select*from 测试数据"
myrs.cursorlocation=aduseclient
set myrs=mycon.execute(strsql))
或myrs=mycon.openresuleset(strsql)
myrs("第一次结果")=myv(0)
或myrs("第一次结果")=myvs(0))
结果总是提示错误,要么是数据类型不匹配,要么是提供者不支持。不知为什么,请你给看看。
Public MYV(0 to 4) as double
Public MyCon as Adodb.Connection
Public MyRS as Nes Adodb.Recordset
public MyCom as new adodb.command
public strsql as string
set mycon=new adodb.connection
my connectionstring="provider=microsoft.jet.oledb.3.51" &_
"data source=" & app.path & "\data\line.mdb"
mycon.open
strsql="select*from 测试数据"myrs.cursorlocation=aduseclient
myrs.Open "select * from 测试数据", mycon, adOpenDynamic, adLockOptimisticmyrs("第一次结果")=myv(0)
myrs.Open strsql, mycon, adOpenDynamic, adLockOptimisticmyrs.fields("第一次结果")=myv(0)myrs.update
my connectionstring="provider=microsoft.jet.oledb.4.0" &_
"data source=" & app.path & "\data\line.mdb"
Set m_Cn = New ADODB.Connection
m_Cn.Open my_connectionstring
strSql="insert into table(field) values('aa') "
mycon.execute(strsql)