请教各位啊，上面的那个多条件查询怎么实现啊，就是搜索的条件用逗号隔开

[ 本帖最后由 growingbird 于 2010-4-6 10:26 编辑 ]

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

   //查询
        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+"'";


这样可以吗？

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

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

 //查询
        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;

        }