在Datagridview中创建列Combobox [英] Creating column Combobox in Datagridview

问题描述

我是新的 C＃。我想在我的 Datagridview 的第一列中创建 combobox 。以下是我写过的例程。但是在设置网格后，最后一列中添加组合。

I am new to C#. I want to create combobox in first column of my Datagridview. Following is the routine I have wrote. But it is adding combo in last column after setting up my grid.

对于设置网格，我尝试了以下代码：

For setting up Grid, i have tried the below code:

private void SetGrid()
{
    dgDetail.AutoGenerateColumns = false;
    dgDetail.ColumnCount = 5;
    dgDetail.Columns[0].Name = "Debit";
    dgDetail.Columns[0].HeaderText = "Debit Account Name";
    dgDetail.Columns[1].Name = "Bank";
    dgDetail.Columns[1].HeaderText = "Bank";
    dgDetail.Columns[2].Name = "ChqNo";
    dgDetail.Columns[2].HeaderText = "CC/Chq No";
    dgDetail.Columns[3].Name = "ChqDate";
    dgDetail.Columns[3].HeaderText = "Chq Date";
    dgDetail.Columns[4].Name = "Amount";
    dgDetail.Columns[4].HeaderText = "Amount";
    dgDetail.AllowUserToDeleteRows = true;
    dgDetail.Columns[0].Width = 280;
    dgDetail.Columns[1].Width = 160;
    dgDetail.Columns[2].Width = 90;
    dgDetail.Columns[3].Width = 90;
    dgDetail.Columns[4].Width = 120;
    dgDetail.RowsDefaultCellStyle.ForeColor = Color.Black;
    dgDetail.RowsDefaultCellStyle.BackColor = Color.White;
    dgDetail.Font = new Font("Arial", 9, FontStyle.Regular);
}

创建从DB填充的组合框。

For Creating the combobox which is filled from DB.

private void FillGridCombo()
{
    SqlConnection sqlConnection = new SqlConnection(strCon);
    sqlConnection.Open();
    try
    {
        string selectQueryStringMonth = "SELECT accode, GLAC FROM glmast where (actype = 'CSH' and titleac <> 'PDP') OR TITLEAC = 'DIS' ORDER BY GLAC";

        SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(selectQueryStringMonth, sqlConnection);
        SqlCommandBuilder sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter);

        DataTable dataTable = new DataTable();
        sqlDataAdapter.Fill(dataTable);
        BindingSource bindingSourceMonth = new BindingSource();
        bindingSource.DataSource = dataTable;

        //Adding  Combo
        DataGridViewComboBoxColumn ColumnAcc = new DataGridViewComboBoxColumn();
        ColumnAcc.DataPropertyName = "Debit Account Name";
        ColumnAcc.HeaderText = "Debit Account Name";
        ColumnAcc.Width = 280;

        ColumnAcc.DataSource = bindingSourceMonth;
        ColumnAcc.ValueMember = "accode";
        ColumnAcc.DisplayMember = "GLAC";

        dgDetail.Columns.Add(ColumnAcc);
        dgDetail.DataSource = bindingSource;
    }

    catch (Exception ex)
    {
        MessageBox.Show("Error : " + ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
    }

    finally
    {
        if (sqlConnection.State != ConnectionState.Closed)
        sqlConnection.Close();
    }
}

我正在调用我的NewData（）这个

I am calling both procedures on my NewData() like this.

private void NewData()
{
    if (dgDetail.DataSource != null)
        dgDetail.DataSource = null;
    else
        dgDetail.Rows.Clear();

    ClearData();
    CtrlEnable();
    SetGrid();
    FillGridCombo();
}

帮助/指导我实现这一点，

Help / Guide me to achieve this.,

推荐答案

您可以使用插入方法而不是添加这样：

You can use the Insert method instead of Add like this:

dgDetail.Columns.Insert(0,ColumnAcc);

这篇关于在Datagridview中创建列Combobox的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！