如何绑定在datagridview的组合框列数据 [英] How to bind data in datagridview combobox column

问题描述

下面有联系方式，但我们可以有多个联系人，所以我想显示在组合框列表

Here are contacts but we can have multiple contacts so i want to show a list in combobox

DataTable dt = new DataTable();
dt = MainClass.GetDatabyQuery("select * from tbl");
if (dt.Rows.Count > 0)
{
    dgv_ClientDetail.DataSource = dt;
}

我有这种方法的datagridview来从数据库值，但我想要一个datagridview的组合框列，并希望在一个DGV组合框的数据绑定和DGV texboxex等。如果有人知道，然后告诉我。这里有三个coulumns名称，市，联系人。我想表明在DGV组合框列的多个联系人

I have this method to fetch values from database in datagridview but I want one datagridview combobox column and want to bind data in one dgv combobox and other in dgv texboxex . if anybody know then tell me. Here are three coulumns Name, City , Contacts. I want to show multiple contacts in dgv combobox column

推荐答案

只要选择只有名称和城市在 DT ，这样就可以做这样的事情，

Just select only Name and City in dt, so that you can do something like,

        dgv_ClientDetail.DataSource = dt;
        DataGridViewComboBoxColumn dgvCboColumn = new DataGridViewComboBoxColumn();
        dgvCboColumn.Name = "Contacts";
        dgvCboColumn.DataSource = dtContacts; //DataTable that contains contact details
        dgvCboColumn.DisplayMember = "Name";
        dgvCboColumn.ValueMember = "Id";
        dataGridView1.Columns.Add(dgvCboColumn);

编辑：

        dgv_ClientDetail.DataSource = new DataView(dt)
                                         .ToTable(true, new string[] { "Name", "City" });
        DataGridViewComboBoxColumn dgvCboColumn = new DataGridViewComboBoxColumn();
        dgvCboColumn.Name = "Contacts";
        dgv_ClientDetail.Columns.Add(dgvCboColumn);
        foreach (DataGridViewRow row in dgv_ClientDetail.Rows)
        {
            DataGridViewComboBoxCell cboContacts = (DataGridViewComboBoxCell)
                                                         (row.Cells["Contacts"]);
            cboContacts.DataSource = //Get the contact details of a person,
                                     //using his Name or Id field (row.Cells["Name"]);
            cboContacts.DisplayMember = "Name"; //Name column of contact datasource
            cboContacts.ValueMember = "Id";//Value column of contact datasource
        }

希望这有助于...

这篇关于如何绑定在datagridview的组合框列数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！