我想通过传参数a作为查询条件,在class_info表中查询class_name=a 的记录,得到class_id值,做为函数的返回值,我写了函数代码如下:
Public Function chang(a As String) As String
Dim sql1 As String
Dim Cnn1 As New ADODB.Connection 'ADO连接
Dim Rs1 As New ADODB.Recordset 'ADO记录集
Dim t As String
Rs1.CursorType = adOpenDynamic
Rs1.CursorLocation = adUseClient
Rs1.LockType = adLockOptimistic
Cnn1.CursorLocation = adUseClient
'连接字符串
Cnn1.ConnectionString = "Provider=SQLOLEDB.1;User ID=sa;Pwd=;Data Source=XFTIAN"
Cnn1.Open Cnn1.ConnectionString
Cnn1.DefaultDatabase = "deptMIS" '设置要连接数据库名称
sql1 = "select class_id from class_info where class_name='" & a & "' "
Rs1.Open sql1, Cnn1, adOpenKeyset, adLockOptimistic
t = Rs1.Fields("class_id") chang(a) = t
End Function
请各位高手看看有什么问题.
如何才能实现我想要的功能?
Public Function chang(a As String) As String
Dim sql1 As String
Dim Cnn1 As New ADODB.Connection 'ADO连接
Dim Rs1 As New ADODB.Recordset 'ADO记录集
Dim t As String
Rs1.CursorType = adOpenDynamic
Rs1.CursorLocation = adUseClient
Rs1.LockType = adLockOptimistic
Cnn1.CursorLocation = adUseClient
'连接字符串
Cnn1.ConnectionString = "Provider=SQLOLEDB.1;User ID=sa;Pwd=;Data Source=XFTIAN"
Cnn1.Open Cnn1.ConnectionString
Cnn1.DefaultDatabase = "deptMIS" '设置要连接数据库名称
sql1 = "select class_id from class_info where class_name='" & a & "' "
Rs1.Open sql1, Cnn1, adOpenKeyset, adLockOptimistic
t = Rs1.Fields("class_id") chang(a) = t
End Function
请各位高手看看有什么问题.
如何才能实现我想要的功能?
解决方案 »
- 错误提示:word无法启动转换器mswrd632.wpc
- 为什么5个记录集中,有一个打不开?
- 在ActiveX工程中……->进来看看!有奖问答
- 请问如何实现在datareport表格中,显示多个数据表的查询结果?
- 连接数据库的小问题!
- 如何实现当把鼠标移到一张图片时,这个图片就变成另一个,当鼠标移走时,又恢复原图
- 用VB自带的打包工具打包水晶报表在别的机器上为什么不能用?
- 关于MDI窗体的有模式窗体的调用?
- 我想在MSHFlexGrid中和数据库连接实现这样的查询结果.
- 哪里有WEBBROWER这个控件的帮助?????
- 怎样获取EXE文件的参数
- vb里如何将一个文件拷贝至另外一个目录下,能改名字更好,在线等
t=trim(Rs1.Fields!class_id & "")
另外最好加判断。chang(a) = t
返回的函数的值应该是函数名赋值
chang=t