winform combox动态绑定数据 获取DataGridView选中数据

                          ****winform combox动态绑定数据****

动态绑定数据

    public void comboxlist()
    {
        this.comboBox1.Items.Clear();
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=.;Initial Catalog=Lloct;User ID=sa;Password=123456;";
        conn.Open();
        string sqlstr = "select distinct WorkWearType from WorkWear";
        SqlCommand com = new SqlCommand(sqlstr, conn);
        SqlDataReader dr = com.ExecuteReader();
        while (dr.Read())
        {
           this.comboBox1.Items.Add(dr[0].ToString());
            this.Workwear.Items.Add(dr[0].ToString());
        }
        conn.Close();


    }
    ~~单击datagridview~~ 
       private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
    {
        int id = dataGridView1.SelectedRows[0].Index;
        string type = dataGridView1.Rows[id].Cells["WorkWeraType"].Value.ToString();
        this.Workwear.Text = dataGridView1.Rows[id].Cells["WorkWeraType"].Value.ToString();
        this.RowsNum.Text = dataGridView1.Rows[id].Cells["ShelfRow"].Value.ToString();
        this.LedNum.Text = dataGridView1.Rows[id].Cells["Leds"].Value.ToString();
        this.TagPosition.Text = dataGridView1.Rows[id].Cells["ElectronicLabelPosition"].Value.ToString();
       
    }