多项条件的搜索框如何实现？？？ - 编程论坛

#2

hebingbing2010-04-06 10:43

select * from 表 where 编号 in（输入框中的内容）
对了，别忘了把中文下的逗号换成英文下的

#3

growingbird2010-04-06 11:11

   //查询
        private void serch_Click(object sender, EventArgs e)
        {

               char[] sep = { ',', '，' };

                string sqlsel = "";
                String[] rets = pronumber.Text.Trim().Split(sep);

  sqlsel = "select pronumber,proinfo,probackinfo,id from sys_product  where pronumber in '"+rets+"'";

这样可以吗？

#4

growingbird2010-04-06 11:26

sqlsel = "select pronumber,proinfo,probackinfo,id from sys_product where pronumber in '" + pronumber.Text.Trim().Split(sep) + "'";
我是这样写的
可是总提示错误的 System.String[]' 附近有语法错误。

#5

growingbird2010-04-06 15:15

我今天自己在网上请教高人问题解决了，贴上来给大家共享吧
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

//查询
        private void serch_Click(object sender, EventArgs e)
        {

            char[] sep = { ',', '，' };
            StringBuilder strbSql = new StringBuilder();
            strbSql.Append("select pronumber,proinfo,probackinfo,id from sys_product  where ");
            string[] strKeys = pronumber.Text.Trim().Split(sep);

            foreach (string item in strKeys)
            {
                if (item.Trim().Length > 0)
                {
                    strbSql.AppendFormat("pronumber ='{0}' or ", item.Trim());
                }
            }
            string strSql = strbSql.ToString().Substring(0, strbSql.ToString().Length - 4);
          //  MessageBox.Show(strSql);

            string sqlsel = strSql;
            DataTable dt = bangding(sqlsel);

            cmAmend = (CurrencyManager)BindingContext[dt];

            this.dataGridView1.DataSource = dt;

        }