如题:
判断Adodc1.Recordset!xm_code 中是否有text1.text的内容
类似于
str1 = "select * from zd_sf where xm_code = '"& Text1.Text &"'"
Rs.Open str1, Cn, adOpenKeyset, adLockOptimistic
If Rs.RecordCount > 0 Then
判断Adodc1.Recordset!xm_code 中是否有text1.text的内容
类似于
str1 = "select * from zd_sf where xm_code = '"& Text1.Text &"'"
Rs.Open str1, Cn, adOpenKeyset, adLockOptimistic
If Rs.RecordCount > 0 Then
if rs.state<>adstaetclosed then rs.close
Rs.Open str1, Cn, adOpenKeyset, adLockOptimistic
If Rs.RecordCount > 0 Then
msgbox "有"
else
msgbox "无"
end if
rs.close
if rs.state<>adstaetclosed then rs.close
Rs.Open str1, Cn, adOpenKeyset, adLockOptimistic
If Rs.RecordCount > 0 Then
msgbox "有"
else
msgbox "无"
end if
rs.close
如果包含字母的话,可以把字母都转换为大写或小写
用存储过程吧
利用类似于instr(1,Adodc1.Recordset!xm_code,text1.text)>0的方法不能解决吗