利用dropdownlist和textbox输入关键字进行模糊查询，在gridview中输出，为什么总是显示有语法错误？

Question

protected void Button1_Click(object sender, EventArgs e)
{
if (TextBox1.Text == "")
{
datacon1.OLEformpk(GridView1, "select * from View_course_profession order by courseid", "courseid");
}
else
{
datacon1.OLEform(GridView1, "select * from View_course_profession where" + DropDownList1.SelectedValue + "like '%" + TextBox1.Text + "%'");

}
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
datacon1.OLEform(GridView1, "select * from View_course_profession where" + DropDownList1.SelectedValue + "like '%" + TextBox1.Text + "%'");
}
}

Answer 1

你设断点调试一下，这个肯定是sql语句的问题，where " + DropDownList1.SelectedValue + " like '%" + TextBox1.Text + "%'" 看下是不是字符串连在一起了

Answer 2

你的查询语句我从来没见过这样子的,where那里放了一个这个DropDownList1.Select
你如果在数据库中有值的话 where value='%"+TextBox1.Text .Trim()+"%';

Answer 3

TextBox1.text 没有值。