如何在DataGridView中显示ComboBox？

Question

大家好，我有两个名为brand（id，name）和product（id，brandid，name）的表格，我想在datagridview（id，名称，品牌），品牌列应为combobox，请参阅brandID in in 产品表和显示品牌名称来自brand表的记录的名称表

如何做到

品牌表

产品表

”

sstatic.net/9jq6u.png“ rel =“ nofollow noreferrer”> < href =“ https://i.sstatic.net/jbinh.png” rel =“ nofollow noreferrer”>

Answer 1

// Create and populate DataTable

DataTable dt = new DataTable();
dt.Columns.Add("Id", typeof(int));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Brand", typeof(string));

// Populate it here

// With this once we set datasource of dgv, it will not generate columns automatically
dataGridView1.AutoGenerateColumns = false;

DataGridViewTextBoxColumn idCol = new DataGridViewTextBoxColumn()
{
    Name = "Id",
    HeaderText = "Id",
    DataPropertyName = "Id",
    Width = 50,
    HeaderCell = new DataGridViewColumnHeaderCell()
    {
        Value = "Id"
    }
};

DataGridViewTextBoxColumn nameCol = new DataGridViewTextBoxColumn()
{
    Name = "Name",
    HeaderText = "Name",
    DataPropertyName = "Name",
    Width = 200,
    HeaderCell = new DataGridViewColumnHeaderCell()
    {
        Value = "Name"
    }
};

DataGridViewComboBoxColumn brandCol = new DataGridViewComboBoxColumn()
{
    Name = "Brand",
    HeaderText = "Brand",
    DataPropertyName = "Brand",
    Width = 100,
    HeaderCell = new DataGridViewColumnHeaderCell()
    {
        Value = "Brand"
    },
    DataSource = new List<Tuple<int, string>>() {
        new Tuple<int, string>(1, "Brand 1"),
        new Tuple<int, string>(2, "Brand 2"),
        new Tuple<int, string>(3, "Brand 3")
    },
    DisplayMember = "Item2",
    ValueMember = "Item1"
};

// Now we add these columns to our dgv
dataGridView1.Columns.Add(idCol);
dataGridView1.Columns.Add(nameCol);
dataGridView1.Columns.Add(brandCol);

// and at last, we bind our data to it
dataGridView1.DataSource = dt;

您可以看到该列是我们的combobox使用与普通combobox相同的绑定系统。为此，我使用了该单元列出的列表来填充它，但是通常您会从数据库中加载数据。

可以说，您拥有这样的品牌类别：

public class Brand
{
    public int ID { get; set; } // important to be property, not variable
    public string Name { get; set; }
}

您从数据库加载数据并创建以下对象列表：

// I have done it manually
List<Brand> brandsList = new List<Brand>();
brandsList.Add(new Brand() { ID = 1, Name = "Brand 1 });
brandsList.Add(new Brand() { ID = 2, Name = "Brand 2 });
brandsList.Add(new Brand() { ID = 3, Name = "Brand 3 });

然后，您将将上层ComboBox列定义更改为：

DataGridViewComboBoxColumn brandCol = new DataGridViewComboBoxColumn()
{
    Name = "Brand",
    HeaderText = "Brand",
    DataPropertyName = "Brand",
    Width = 100,
    HeaderCell = new DataGridViewColumnHeaderCell()
    {
        Value = "Brand"
    },
    DataSource = brandsList,
    DisplayMember = "Name",
    ValueMember = "ID"
};