小弟在vb访问数据库时遇到以下问题:
Dim conn As adodb.connection
Set conn = New adodb.connection
dim cmd as adodb.command
set cmd=new adodb.command
dim rst as adodb.recordset
set rst=new adodb.recordset
conn.connectiongstring= "Provider=SQLOLEDB;User ID=sa;Password=;database=gaojianchuli;Data Source=(local)"
conn.Open
cmd.commandtext = "select* from zuozhe where '"
cmd.execute
.......
在编译的时候出现"用户定义类型未定义"的错误提示
小弟认为是ado的问题,就重新装了mdac,以前在asp中可以顺利的访问,亟待高手赐教,小弟不胜感激!!!
Dim conn As adodb.connection
Set conn = New adodb.connection
dim cmd as adodb.command
set cmd=new adodb.command
dim rst as adodb.recordset
set rst=new adodb.recordset
conn.connectiongstring= "Provider=SQLOLEDB;User ID=sa;Password=;database=gaojianchuli;Data Source=(local)"
conn.Open
cmd.commandtext = "select* from zuozhe where '"
cmd.execute
.......
在编译的时候出现"用户定义类型未定义"的错误提示
小弟认为是ado的问题,就重新装了mdac,以前在asp中可以顺利的访问,亟待高手赐教,小弟不胜感激!!!
Set conn = New adodb.connection
dim rst as adodb.recordset
set rst=new adodb.recordset
conn.connectiongstring= "Provider=SQLOLEDB;User ID=sa;Password=;database=gaojianchuli;Data Source=(local)"
conn.Open
rst.open "select* from zuozhe ",conn,adOpenForwardOnly
这样就可以了!
dim cmd as new adodb.command
dim rst as new adodb.recordsetconn.connectiongstring= "Provider=SQLOLEDB;User ID=sa;Password=;database=gaojianchuli;Data Source=(local)"
conn.Open
cmd.commandtext = "select* from zuozhe"
cmd.execute如果這樣不行的話﹐那就是沒有引用
Microsoft ActiveX Data Objects 2.x Library項目﹐
請用lang_ch77(飞狐) 的方法引用項目就可以了
dim rst as adodb.recordset
sql = "select * from zuozhe where 条件“
rs.open sql,conn
你就可以打开表了
如果要对表进行添加。修改,删除,操作
rs.open sql,conn,adOpenKeyset, adLockPessimistic