--sql言语的一般问题?

[Tomgus]

string idn=this.TextBox1.Text;
sql="select id,cardid,name,paw,nickname from reg when id like '%"+idn+"%'";

网页上办错:'when' 附近有语法错误

[Englishgenius]

where 不是when

[eshusheng]

似乎应该是"where"?

[szhuk]

sql="select id,cardid,name,paw,nickname from reg where id like '%"+idn+"%'";

[付长松_华为云MVP]

ID is int!!

[szhuk]

如果是ID是numeric型最好不要这样做
sql="select id,cardid,name,paw,nickname from reg where id like "+idn;

[szhuk]

呵呵，不好意思
sql="select id,cardid,name,paw,nickname from reg where id = "+idn;

[batisituta]

1.when改为where
2.sql="select id,cardid,name,paw,nickname from reg where id like %"+idn+"%";