一个空格导致错误~~~~
第一条:GridView1.DataSource = bc.GetDataSet("select * from chengji_chaxun_view where "
+ DropDownList1.SelectedValue + " Like '%" + TextBox1.Text + "%'", "chengji_chaxun_view");
第二条:GridView1.DataSource = bc.GetDataSet("select * from chengji_chaxun_view where"
+ DropDownList1.SelectedValue + " Like '%" + TextBox1.Text + "%'", "chengji_chaxun_view");
第二条语句执行的时候会出现“关键字 'Like' 附近有语法错误”
原因是什么呢?看看这两条语句就明白了:
第一条:select * from chengji_chaxun_view where xxxx=yyyy (Correct! )
第二条:select * from chengji_chaxun_view wherexxxx=yyyy (Incorrect!)
+ DropDownList1.SelectedValue + " Like '%" + TextBox1.Text + "%'", "chengji_chaxun_view");
第二条:GridView1.DataSource = bc.GetDataSet("select * from chengji_chaxun_view where"
+ DropDownList1.SelectedValue + " Like '%" + TextBox1.Text + "%'", "chengji_chaxun_view");
第二条语句执行的时候会出现“关键字 'Like' 附近有语法错误”
原因是什么呢?看看这两条语句就明白了:
第一条:select * from chengji_chaxun_view where xxxx=yyyy (Correct! )
第二条:select * from chengji_chaxun_view wherexxxx=yyyy (Incorrect!)