Dim conn As ADODB.Connection
Dim cmd As ADODB.Command
Dim constr As String
Dim rs As ADODB.Recordset
'创建数据库对象
Set conn = New ADODB.Connection
Set cmd = New ADODB.Command
Set rs = New ADODB.Recordset
'配置连接参数
constr = "Provider=SQLOLEDB.1;Persist Security Info=True;Password=sa;User ID=sa;" & _
"Initial Catalog=VB6.0通用进销存管理系统;Data Source=KNIGHTRCOM"
conn.connectionString = constr
'打开连接
Call conn.Open
Dim sqlQuery As String
sqlQuery = "SELECT * FROM 用户信息 WHERE 登录ID=?"
'指派连接对象实例
cmd.ActiveConnection = conn
cmd.CommandType = adCmdText
cmd.CommandText = sqlQuery
Dim param As ADODB.Parameter
Set param = New ADODB.Parameter
param.Name = "登录ID"
param.Type = adVarChar
param.value = "Admin"
param.size = 100
cmd.Parameters.Append param
Set rs = cmd.Execute(flag)
Debug.Print CStr(flag) + Chr(10)
Exit Sub
Dim cmd As ADODB.Command
Dim constr As String
Dim rs As ADODB.Recordset
'创建数据库对象
Set conn = New ADODB.Connection
Set cmd = New ADODB.Command
Set rs = New ADODB.Recordset
'配置连接参数
constr = "Provider=SQLOLEDB.1;Persist Security Info=True;Password=sa;User ID=sa;" & _
"Initial Catalog=VB6.0通用进销存管理系统;Data Source=KNIGHTRCOM"
conn.connectionString = constr
'打开连接
Call conn.Open
Dim sqlQuery As String
sqlQuery = "SELECT * FROM 用户信息 WHERE 登录ID=?"
'指派连接对象实例
cmd.ActiveConnection = conn
cmd.CommandType = adCmdText
cmd.CommandText = sqlQuery
Dim param As ADODB.Parameter
Set param = New ADODB.Parameter
param.Name = "登录ID"
param.Type = adVarChar
param.value = "Admin"
param.size = 100
cmd.Parameters.Append param
Set rs = cmd.Execute(flag)
Debug.Print CStr(flag) + Chr(10)
Exit Sub
解决方案 »
- 您的参与将给我莫大的鼓励!!!!基础中的基础
- 请教关于VB通过ADO操作MYSQL的相关问题
- 写程序代码的过程中,如何避免将来运行时,资源不足的情况发生?
- 问题
- 求教!如何把在2000下编写的程序在98下运行!
- 我想请教的是,我如何在报表里动态显示相应的图片.具体情况是:我在SQL数据库里建立了一个装服装基本资料的表,表里定义了衣服代码,衣服图片
- 如何获取MSHFLEXGRID或MSFLEXGRID控件中的一个单元格的文本行数
- 初学,哪个大哥来帮我??
- 大家帮个忙,一个有关listview中各项被双击的问题。
- EXCEL vba操作及查询XML文件里面的内容,高手请进讨论。
- 如何添加到文本txt
- 百元求解
rs.CursorLocation=adUseClient
constr = "Provider=SQLOLEDB.1;Persist Security Info=True;Password=sa;User ID=sa;" & _
"Initial Catalog=VB6.0通用进销存管理系统;Data Source=KNIGHTRCOM"
conn.connectionString = constr
cnn.CursorLocation=adUseClient'----------------------------------->在这里指定再试试
'打开连接
Call conn.Open
Rs,open StrSQl,PubConn,1,1
Rs!Field就好了
省事简单明了