DropDownList选择条件,第二个页面上的GridView显示内容,出错了
using System;using System.Text;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Data.SqlClient;
public partial class ConnectoSQLServer : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string Key = Convert.ToString(Request.QueryString["Key"]);
StringBuilder sb = new StringBuilder();
sb.Append(" select * from hotleDescripble '%");
sb.Append(Key);
sb.Append("%'hotleCity'%");
sb.Append(Key);
sb.Append("%'");
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "server=localhost;database=hotel;uid=sa;password=sa;";
conn.Open();
SqlCommand cmd = new SqlCommand(sb.ToString(), conn);
SqlDataReader da = cmd.ExecuteReader();
this.GridView1.DataSource = da;
this.GridView1.DataBind();
da.Dispose();
conn.Close();
}
我在第一个页面上有一个DropDownList,在DropDownList中选择一个值“上海”,然后点搜索,然后跳转到第二个页面,在第二个页上用GridView显示搜索结果,可是
提示出错:第 1 行: '%上海%' 附近有语法错误。 --------------------编程问答-------------------- 是不是SQL语句少了WHERE --------------------编程问答-------------------- --------------------编程问答-------------------- string Key = Request.QueryString["Key"]=null?"":Convert.ToString(Request.QueryString["Key"]);
sb.Append(" select * from hotleDescripble where hotleCity like '%");
sb.Append(Key);
sb.Append("%'");
sqlparameter参数化
补充:.NET技术 , C#