在线求助白送分

[wxb1224]

txtsql = "select * from guye where number='&Text1.Text& '"
这么写对不对否则怎么写

[md2d]

txtsql = "select * from guye where number='" & Text1.Text & "'"
你写的漏了两个"号，加上就好了

[rained]

字符串要用引号引着，变量不需要引号，它们之间用“&”或“+”连接

[xzp1030]

mysql:
txtsql = "select * from guye where number='" & Text1.Text & "'；"