Question

',' 附近有语法错误。

异常详细信息: System.Data.SqlClient.SqlException: ',' 附近有语法错误。

源错误:

行 34:
行 35: DataSet ds = new DataSet();
行 36: adp.Fill(ds, "jiudianqiantai");
行 37:
行 38:
36行出错。

源代码如下：
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn= new SqlConnection("server=LENOVO-307F1ED4;Initial Catalog=酒店信息数据库;User ID=sa;Password=hu12345");

string sql="select id,newcount,roomtype from jiudianqiantai where roomtype='"+DropDownList1.SelectedItem.Value+"',hstate='0'";
SqlDataAdapter adp = new SqlDataAdapter(sql, conn);
SqlParameter prams = new SqlParameter("@roomtype", SqlDbType.Char);
prams.Value = this.DropDownList1.Text;

adp.SelectCommand.Parameters.Add(prams);

DataSet ds = new DataSet();
adp.Fill(ds, "jiudianqiantai");

foreach (DataRow dr in ds.Tables["jiudianqiantai"].Rows)
{
Response.Write("<li>" + dr["id"] + "--房间消费："
+ dr["newcount"] +"--房间类型:" +dr["roomtype"] +"<br/>");
}

Answer 1

string sql="select id,newcount,roomtype from jiudianqiantai where roomtype='"+DropDownList1.SelectedItem.Value+"',hstate='0'";
改成string sql="select id,newcount,roomtype from jiudianqiantai where roomtype='"+DropDownList1.SelectedItem.Value+"' and hstate='0'";试试（,改成 and )

以上，若还有疑问，可以Hi我~