Dim cn As New Connection
Dim rs As New Recordset
Dim data As String
data = "select username from use where password = '" & Trim(Text1.Text) & " '"
cn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=ll;Data Source=LLUO"
cn.CursorLocation = adUseClient
rs.Open data, cn, adOpenDynamic, adLockOptimistic
谢谢了
Dim rs As New Recordset
Dim data As String
data = "select username from use where password = '" & Trim(Text1.Text) & " '"
cn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=ll;Data Source=LLUO"
cn.CursorLocation = adUseClient
rs.Open data, cn, adOpenDynamic, adLockOptimistic
谢谢了
data = "select username from [user] where [password] = '" & Trim(Text1.Text) & " '"
不过,建议楼主不要将保留字作为表名与字段名来使用