各位高手,我是初学者,写了个程序来修改数据库中某个表中的密码,但是总是不成功,总在mrc.Fields(1) = Text2.Text
mrc.Update
mrc.close
这三句报错,谁能帮我看看呀?谢谢啦!
代码如下:
Dim txtSQL, MsgText As String
Dim mrc As ADODB.Recordset
Dim rs As Boolean
rs = True
If Text2.Text = "" Then
MsgBox "密码不能为空! 请输入密码!", vbOKOnly + vbExclamation, "警告"
rs = False
Text2.Text = ""
Text3.Text = ""
Text2.SetFocus
Exit Sub
End If
If Trim(Text2.Text) <> Trim(Text3.Text) Then
MsgBox "密码输入不正确!", vbOKOnly + vbExclamation, "警告"
Text2.SetFocus
Text2.Text = ""
Text3.Text = ""
Else
txtSQL = "update userinfo set password='" & Text2.Text & "' where uid= '" & username & "'"
Set mrc = ExecuteSQL(txtSQL, MsgText)
mrc.Fields(1) = Text2.Text
mrc.Update
mrc.close MsgBox "密码修改成功!", vbOKOnly + vbExclamation, "修改密码"
Me.Hide
End If
mrc.Update
mrc.close
这三句报错,谁能帮我看看呀?谢谢啦!
代码如下:
Dim txtSQL, MsgText As String
Dim mrc As ADODB.Recordset
Dim rs As Boolean
rs = True
If Text2.Text = "" Then
MsgBox "密码不能为空! 请输入密码!", vbOKOnly + vbExclamation, "警告"
rs = False
Text2.Text = ""
Text3.Text = ""
Text2.SetFocus
Exit Sub
End If
If Trim(Text2.Text) <> Trim(Text3.Text) Then
MsgBox "密码输入不正确!", vbOKOnly + vbExclamation, "警告"
Text2.SetFocus
Text2.Text = ""
Text3.Text = ""
Else
txtSQL = "update userinfo set password='" & Text2.Text & "' where uid= '" & username & "'"
Set mrc = ExecuteSQL(txtSQL, MsgText)
mrc.Fields(1) = Text2.Text
mrc.Update
mrc.close MsgBox "密码修改成功!", vbOKOnly + vbExclamation, "修改密码"
Me.Hide
End If
解决方案 »
- 有经验的高手进来看看!
- 初学-怎样使combobox不为空值? 或者是:combo为空值时不给光标下移
- 谁能把这个模板的代码精简一下???
- 请问在VB中调用存储过程如何判断存储过程是否执行成功
- 结帐,请sxs69() ( ) 信誉:104 进来领分,希望以后继续关注我的问题,谢谢了!
- 代码问题?
- 求救,关于PDA开发,随便讨论,来者有分!
- 如何在vb下实现一次加载多张图片,然后一张张看,再分批的卸载,是用控件数组?还是用imagelist?具体的方法,源码!!!!!!!!!!!!!!!急!!!!急!!!!!!
- 如何移动无标题栏窗口?
- 急!!请问怎么实现对DOS可执行文件的调用(在win98-2,VB6.0中文里)
- picturebox PNG 图片透明部分不透明?
- 感恩节散分...
1要改成字段吧?
比如 "ID"
Public gintMode As Integer
Public flagEdit As Boolean
Public UserName As StringSub Main()
login.Show
End SubPublic Function ConnectString() _
As String
'returns a DB ConnectString
ConnectString = "Provider=SQLOLEDB.1;" & _
"Persist Security Info=False;" & _
"UID=sa;PWD=zzq=1861;" & _
"Initial Catalog=HRMIS;" & _
"Data Source=(local)"
End Function
Public Function ExecuteSQL(ByVal SQL _
As String, MsgString As String) _
As ADODB.Recordset
'executes SQL and returns Recordset
Dim cnn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim sTokens() As String
On Error GoTo ExecuteSQL_Error
sTokens = Split(SQL)
Set cnn = New ADODB.Connection
cnn.Open ConnectString
If InStr("INSERT,DELETE,UPDATE", _
UCase$(sTokens(0))) Then
cnn.Execute SQL
MsgString = sTokens(0) & _
" query successful"
Else
Set rst = New ADODB.Recordset
rst.Open Trim$(SQL), cnn, _
adOpenKeyset, _
adLockOptimistic
'rst.MoveLast 'get RecordCount
Set ExecuteSQL = rst
MsgString = "查询到" & rst.RecordCount & _
" 条记录 "
End If
ExecuteSQL_Exit:
Set rst = Nothing
Set cnn = Nothing
Exit Function
ExecuteSQL_Error:
MsgString = "查询错误: " & _
Err.Description
Resume ExecuteSQL_Exit
End Function
'将enter换成tab
Public Sub EnterToTab(Keyasc As Integer)
If Keyasc = 13 Then
SendKeys "{TAB}"
End If
End Sub