Question

C#语言语句的错误？

string sql = "select * from bookInfo where BookType='" + cbo1 + "' BookName like '%" + bookname + " ' BookContent like '%" + bookcontent + "%'";

Answer 1

多个条件之间居然没有关系符号？

追问

"select * from bookInfo where BookType='" + cbo1 + "'and BookName like '%" + bookname + " ' and BookContent like '%" + bookcontent + " '"; 这样吗?

Answer 2

"select * from bookInfo where BookType='" + cbo1 + "' and BookName like '%" + bookname + "%' and BookContent like '%" + bookcontent + "%'";