Question

ASP.NET站内搜索功能实现（求助）

我想实现一个简单的标题搜索的 SQL语句应该怎么写呢 假如输入框的id为TextBox4 select * from view_news where view_news like title='%+"TextBox4.text"+"; 应该如何去写呢

Answer 1

string key=this.TextBox4.Text; string sqlstr="Select * From view from view_news where title like '%"+key+"%' "; 注意下like后面的符号顺序。

Answer 2

string str = "select * from view_news where title like '%"+TextBox4.Text+"%'"; 这样