C#winform在DataGridView控件中加入ComboBox下拉列表框

C#winform 

 

private void mainForm_Load(object sender, EventArgs e)
        {
            string sqll = "select * from Type";

            List<string> ListData = new List<string> { "张三", "里斯", "王六" };
            DataGridViewComboBoxColumn column1 = new DataGridViewComboBoxColumn();
            column1.Name = "Name";
            column1.DataPropertyName = "Name";//对应数据源的字段
            column1.HeaderText = "combox姓名";
            column1.Width = 80;
            this.dataGridView1.Columns.Add(column1);
            column1.DataSource = ListData; 
           //数据库的
            DataGridViewComboBoxColumn column12 = new DataGridViewComboBoxColumn();
            column12.DisplayMember = "Type";
            column12.ValueMember = "TypeID";
            column12.HeaderText = "combox类型";
            column12.Width = 80;
            this.dataGridView1.Columns.Add(column12);
            column12.DataSource = DBHelper.ExecuteTable(sqll);
            //文本的
            DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
            column.Name = "Type";
            column.DataPropertyName = "TypeID";//对应数据源的字段
            column.HeaderText = "文本类型";
            column.Width = 80;
            this.dataGridView1.Columns.Add(column); 

            string sql = "select name 法律,t.Type 类型,description 内容 from book g,Type t where t.TypeID=g.TypeID";
            dataGridView1.DataSource = DBHelper.ExecuteTable(sql);
        
            cbx1.DataSource = DBHelper.ExecuteTable(sqll);
            cbx1.DisplayMember = "Type";
            cbx1.ValueMember = "TypeID";
        }

   private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            ComboBox combo = e.Control as ComboBox;
            if (combo != null)
            {
                combo.SelectedIndexChanged +=
                new EventHandler(ComboBox_SelectedIndexChanged);
            }

        }

        private void ComboBox_SelectedIndexChanged(object sender, EventArgs e)
        {
            ComboBox combo = sender as ComboBox;
            string selectedItem = combo.Text;//拿到选择后的值
        }