是Access数据库? 更改所绑定的数据控件的记录源: data1.recordsource = "SELECT Userid, UserNme, string(len(password),"*") AS password FROM yourtable"
如果没有绑定,写入记录时写成string(len(rs!password),"*")就可以了。
是SQL SERVER 2000, strsql = "select User_Id ,User_Account,UserName,string(len(Password),' * ') as Password,UserInfo,Creator from User_Account order by User_Id "提示string没有定义???
Public Function UserList(ByVal strcnn As String) As ADODB.Recordset '显示所有用户帐号 On Error GoTo err_trap: Dim rs As New ADODB.Recordset Dim strsql As String strsql = "select User_Id ,User_Account,UserName,string(len(Password),' * ') as Password,UserInfo,Creator from User_Account order by User_Id "
更改所绑定的数据控件的记录源:
data1.recordsource = "SELECT Userid, UserNme, string(len(password),"*") AS password FROM yourtable"
strsql = "select User_Id ,User_Account,UserName,string(len(Password),' * ') as Password,UserInfo,Creator from User_Account order by User_Id "提示string没有定义???
On Error GoTo err_trap:
Dim rs As New ADODB.Recordset
Dim strsql As String
strsql = "select User_Id ,User_Account,UserName,string(len(Password),' * ') as Password,UserInfo,Creator from User_Account order by User_Id "
rs.CursorType = adOpenStatic
rs.CursorLocation = adUseClient
rs.Open strsql, strcnn
Set UserList = rs
Set rs = Nothing
Exit Function
err_trap:
Set UserList = Nothing
Set rs = Nothing
End Function
这是在class Model中的一段代码??