最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

How to dynamically populate DataGridViewComboBoxColumn from SQL using C# - Stack Overflow

programmeradmin5浏览0评论

So users asked me to add drop downs to a pre-existing DataGridView, which populates the table from SQL and allows users to edit the information which updates SQL. I've added the drop downs using DataGridViewComboBoxColumn. I'd like to prepopulate these from SQL and I have Googled a bunch and I can't find anything. Hoping someone can help me with this.

I need this to populate specific values based on the ID for that entry.

DataGridViewComboBoxColumn comboBoxColumn1 = new DataGridViewComboBoxColumn();
DataGridViewComboBoxColumn comboBoxColumn2 = new DataGridViewComboBoxColumn();
if(tabControl1.SelectedTab.ToString() == tabPage2.ToString()) {
    //MessageBox.Show("Selected Tab2: " + tabPage2);                
    // Check if the column is already added to avoid duplication
    if(!dataGridView1.Columns.Contains("comboBoxColumn1")) {
        //*
        //DataGridViewComboBoxColumn comboBoxColumn1 = new DataGridViewComboBoxColumn();
        comboBoxColumn1.HeaderText = "Direction";
        comboBoxColumn1.Name = "comboBoxColumn1";
        comboBoxColumn1.Items.AddRange("Inbound","Outbound");
        //dataGridView1.Columns.Add(comboBoxColumn1);
        dataGridView1.Columns.RemoveAt(2);
        dataGridView1.Columns.Insert(1,comboBoxColumn1);
        dataGridView1.Columns[1].Width = 150;
        //*/
    }
    if(!dataGridView1.Columns.Contains("comboBoxColumn2")) {
        //*
        //DataGridViewComboBoxColumn comboBoxColumn2 = new DataGridViewComboBoxColumn();
        comboBoxColumn2.HeaderText = "Folder";
        comboBoxColumn2.Name = "comboBoxColumn2";
        comboBoxColumn2.Items.AddRange("DST_CM-RRE","DST_DST-CM","DST_DST-USPS","DST_Exceptions","DST_Inbound","DST_RTS","NCT_CM-RRE","NCT_Exceptions","NCT_Inbound","NCT_NCT-CM","NCT_NCT-USPS","NCT_RTS");
        //dataGridView1.Columns.Add(comboBoxColumn2);
        dataGridView1.Columns.RemoveAt(3);
        dataGridView1.Columns.Insert(2,comboBoxColumn2);
        dataGridView1.Columns[2].Width = 150;
        //*/
    }
} else if(tabControl1.SelectedTab.ToString() == tabPage1.ToString()) {
    //MessageBox.Show("Selected Tab1: " + tabPage1);
    // Optionally, you can remove the column when the tab is not selected
    if(dataGridView1.Columns.Contains("comboBoxColumn1")) {
        dataGridView1.Columns.Remove("comboBoxColumn1");
    }
    if(dataGridView1.Columns.Contains("comboBoxColumn2")) {
        dataGridView1.Columns.Remove("comboBoxColumn2");
    }
} else {
    MessageBox.Show("No Selected Tab");
}

Trying to populate DataGridViewComboBoxColumn from SQL

发布评论

评论列表(0)

  1. 暂无评论