VS2005中提示System.Data.SqlClient.SqlException: 第 1 行: '=' 附近有语法错误。怎么回事

Question

protected void Page_Load(object sender, EventArgs e)
{

this.Title = "显示书籍详细信息";
//连接和打开数据库
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=localhost;database=book;integrated security=true";
conn.Open();
//执行SQL语句命令
string sql = "select book_id,book_picture,book_name,book_price,book_note,ISBN_num,book_factory from books where book_id=" + Request["bh"];
SqlDataAdapter da = new SqlDataAdapter(sql, conn);

DataSet ds = new DataSet();
da.Fill(ds, "books");

DataList1.DataSource = ds.Tables["books"];
DataList1.DataBind();
conn.Close();

}

Answer 1

不知道你的数据库是结构怎么样！
如果　book_id　是　字符传形的

把下面的这句
string sql = "select book_id,book_picture,book_name,book_price,book_note,ISBN_num,book_factory from books where book_id=" + Request["bh"];
改为

string sql = "select book_id,book_picture,book_name,book_price,book_note,ISBN_num,book_factory from books where book_id='" + Request["bh"]+"'";

追问

我的book_id是VARCHAR类型的，但是还有一个程序，代码和这个一样，就是字段和表名不一样，运行就能成功，怎么回事？

追答

那我的解答是正确的给分吧

Answer 2

是不是Request["bh"]为空啊？
改成这样
string sql = "select book_id,book_picture,book_name,book_price,book_note,ISBN_num,book_factory from books"+Request["bh"]?"":(" where book_id="+ Request["bh"].ToString().Trim());