Question

ASP从数据库搜索 单条数据

这是一个图书搜索的

SqlDataAdapter da = new SqlDataAdapter();//创建连接对象
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=TDB;Initial Catalog=Library_Management;User ID=sa;Password=123456";
//创建命令对象
SqlCommand selectCmd = new SqlCommand();

string key = TextBox1.Text;
string strsql = "select * from Books where ？？？ ";

请问一下，谁能告诉我where 后边怎么写啊？？
我想啊 string strsql = "select * from Books where Bookname=key "; 为什么不行呢
如果不写where （查询全部）可以成功显示
谢谢啊~

Answer 1

string strsql = "尘岁select * from Books where bookname(你数据表中对应的派培睁字段名)='"&key&"中历'";

Answer 2

string strsql = "select * from Books where Bookname like '%" + key + "%'";
string strsql = "select * from Books where Bookname = '燃尺"皮胡高+key+"'"做圆;

Answer 3

连个分都有啊,多少也得点分吧