Question

VB如何写SQL语句

dim sql as string
sql="select * from (表格名字) where id='" & text1.text & "'"
recordset.open conn,1,1,sql
像上面这句，如我写 id name age三个字段对应 text1 text2 text3 如何改下面那句
sql="select * from (表格名字) where id='" & text1.text & "'"

Answer 1

sql="select * from (表格名字) where id='" & text1.text & "' and name='" & text2.text & "' and age="' & text3.text & "' order by id asc"
order by id asc 这句意思是按id升序排列，可写可不写。