Adodc1.CommandType = adCmdText
Dim txtsql As String
txtsql = "select * from user where userid='" & Trim(Text1(0).Text) & "'" & "and password='" & Trim(Text1(1).Text) & "'"
Adodc1.RecordSource = txtsql
Adodc1.Refresh运行时出现from语法错误,哪些高手,指点一下,这个查询语句错在哪里?
Dim txtsql As String
txtsql = "select * from user where userid='" & Trim(Text1(0).Text) & "'" & "and password='" & Trim(Text1(1).Text) & "'"
Adodc1.RecordSource = txtsql
Adodc1.Refresh运行时出现from语法错误,哪些高手,指点一下,这个查询语句错在哪里?
txtsql = "select * from user where userid='" & Trim(Text1(0).Text) & "'" & " and password='" & Trim(Text1(1).Text) & "'"