Question

C# SQL 关键字 between 附近有语法错误

comm.CommandText = "select * from "+Tablename+"where Row between 2 and 3";
换成comm.CommandText = "select * from " + Tablename + "where Row >= 2 and Row <= 3";又说‘>’附近有语法错误

Answer 1

sql语句错误，where前面缺少空格，把语句改为：
comm.CommandText = "select * from "+Tablename+" where Row between 2 and 3";

Answer 2

comm.CommandText = "select * from "+Tablename+" where Row between 2 and 3";
where 前面加空格

Answer 3

你把你的sql语句输出来看看， 是不是表名和where连起来了。