C# 下拉框 Conbobox

        //筛选数据旧
        string comboboxnameold=null; 
       //筛选数据新
        string comboboxnamenew; 
​        //加载conbobox数据
​         My_Conbobox();
​
​        //定时器定时刷新时间（获取选择数据）
        private void timerclock_Tick(object sender, EventArgs e)
        {
            //每秒查询1次
            timerclock.Interval = 1000;
            //查询实时时间
            time1.Text = DateTime.Now.ToString("HH:mm:ss");
            time2.Text = DateTime.Now.ToString("yyyy/MM/dd");
            //当选择框数据改变时，重新查询数据
            if (comboboxnameold != comboboxnamenew)
            {
                GetData();
                comboboxnameold = comboboxnamenew;
            }
        }
​
        //查询选择框数据,存储过程根据数据进行筛选
        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            comboboxnamenew = comboBox1.Text;
        }
​
        //选择框 选项
        public void My_Conbobox()
        {
            DynWebService BHWS = new DynWebService();
            string sql11 = "SELECT  distinct t9.fname 已派工设备 FROM M_Task_001 t1 inner join ERP1_ICMO t2  on   t2.FInterID=T1.FInterID LEFT join (select t1.FBillNo ,min(t1.fentryid) fentryid,t1.fname,t1.ICMOFInterID from  ( select  t.FBillNo,t.fentryid fentryid,t.ICMOFInterID, fname=(stuff((select ','+mach from m10..M_Task_001_routMach where FBillNo=t1.FBillNo for XML path('')),1,1,'')) from m10..M_Task_001_routMach(nolock) t  inner join m10..M_Task_001_routMach t1 on t1.FBillNo=t.FBillNo and t1.FentryID=t.FentryID) t1 group by FBillNo,fname,ICMOFInterID) t9 on t9.FBillNo=t1.FBillNo WHERE ISNULL(T1.FSTATUS,0)<>9 and ISNULL(t2.fstatus,0)<>3";
            DataTable dt22 = BHWS.MExecSQL(MyHelper.strVerify, MyHelper.strIP, "", MyHelper.strProjName + "-" + this.AccessibleName, MyHelper.strUser, sql11);
​
            int rows= dt22.Rows.Count;  //数据总行数
​
            comboBox1.Items.Add("");  //空选项
​
            for (int i = 0; i < rows; i++)
            {
                string name = dt22.Rows[i][0].ToString();
                comboBox1.Items.Add(name);  //选择项
            }
        }