菜鸟问题送高分 在线等待

[vbokonly]

利用 TEXT1 COMBO1 和ADODC1 查询数据库 部分代码如下

IF TEXT1.TEXT <>"" AND COMBO1.TEXT="姓名" then
adodc1.recordsource="select * from kehu where xingming ="text1.text"" '提示没有结束语句
END IF
请大家帮忙看一下是怎么回事， 语句那有问题

[nixnybf69]

set datagrid1.datasource=adodc1

[laviewpbt]

adodc1.recordsource="select * from kehu where xingming =text1.text"
text1.text本身就是字符串。

[a97191]

adodc1.recordsource="select * from kehu where xingming ='"& text1.text &"'"
adodc1.refresh

[of123]

adodc1.recordsource="select * from kehu where xingming ='" & text1.text & "'"

[vbokonly]

多谢大家
还有我想把查出的数据在DATAGRID1中显示 请问怎么写
一会加分

[zjlang]

adodc1.recordsource="select * from kehu where xingming =" & "'" & text1.text & "'"

[lindy730]

adodc1.recordsource="select * from kehu where xingming = '" & Trim(text1.Text) & "'"