strCond =“ 存貨名稱=’DropDownList1.SelectedItem.ToString()‘”;string strCommand = "select * from xiaoshou where "+strCond;不報錯 查詢到 直接空白 請問語句上是哪里出問題了 感覺是DropDownList1.SelectedItem.ToString() 的值類型??謝謝幾位的回答 但是我試了還是篩選顯示不出來,難道不是這里的問題??后面的程序:string strCommand = "select * from xiaoshou where "+strCond;SqlDataAdapter myAdapter = new SqlDataAdapter(strCommand, myConnection);DataSet mySet = new DataSet();myAdapter.Fill(mySet, "存貨名稱");GridView1.DataSourceID = null;GridView1.DataSource = mySet.Tables["存貨名稱"].DefaultView;GridView1.DataBind();麻煩再幫我看一看strcond的定義是: string strCond = "";
添加回答
舉報
0/150
提交
取消