CheckedComboBoxEdit 多选时，值与值之间会多出一个空格

测试代码：

public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            List<string> list = new List<string>();
            list.Add("小明");
            list.Add("小红");
            list.Add("小李");
            this.checkedComboBoxEdit1.Properties.DataSource = list;
        }

        private void checkedComboBoxEdit1_EditValueChanged(object sender, EventArgs e)
        {
            if (this.checkedComboBoxEdit1.Text != "")
            {
                this.textEdit1.Text = this.checkedComboBoxEdit1.Text;
                this.textEdit2.Text = string.Format("select * from tableA where name in ('{0}')", this.checkedComboBoxEdit1.Text).Replace(",","','");
            }
        }
    }

效果：

 

对checkedComboBoxEdit的多值进行SQL查询时，查询中使用IN语句，IN里面第一个条件后面的所有条件的前面都会多出一个空格，导致查询不正确

需将空格去掉再传入SQL查询：

Replace(",","','") 改为  Replace(", ","','")