datagridview中ComboBox的数据源

最新推荐文章于 2025-06-09 14:29:33 发布

fax5201314

最新推荐文章于 2025-06-09 14:29:33 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： winform 文章标签： ComboBox

本文链接：https://blog.youkuaiyun.com/fax5201314/article/details/8219006

winform 专栏收录该内容

6 篇文章

订阅专栏

本文介绍如何使用C#为DataGridView中的组合框单元格设置数据源、显示成员和值成员，并通过循环填充不同类型的值。此外，还展示了如何从数据库中获取数据并将其绑定到ComboBox。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

写入固定值
DataGridViewComboBoxCell cell1 = dataGridView1[1, i] as DataGridViewComboBoxCell;
                DataGridViewComboBoxCell cell2 = dataGridView1[2, i] as DataGridViewComboBoxCell;
                for (int j = 1; j <= 8; j++)
                {
                    if (j == 1)
                    {
                        DataTable dtttt = new DataTable();
                        dtttt.Columns.Add("v");//键值对value对应key text对应画面显示
                        dtttt.Columns.Add("text");
                        for (int m = 1; m < 5; m++)
                        {
                            DataRow r = dtttt.NewRow();
                            r["v"] = "0" + m;
                            r["text"] = "0" + m;
                            dtttt.Rows.Add(r);
                        }
                        cell1.DataSource = dtttt;
                        cell1.DisplayMember = "text";
                        cell1.ValueMember = "v";
                    }
                    if (j == 2)
                    {
                        cell2.DisplayMember = "text";
                        cell2.ValueMember = "v";
                        cell2.Items.Add(new { v = "1", text = "1 : 工作日" });
                        cell2.Items.Add(new { v = "2", text = "2 : 星期六" });
                        cell2.Items.Add(new { v = "3", text = "3 : 星期日" });
                        cell2.Items.Add(new { v = "4", text = "4 : 其它" });
                    }
下面的是从数据库绑定未验证

SqlDataAdapter da = new SqlDataAdapter("select * from Customers", "Data Source=.;Initial Catalog=Northwind;Integrated Security=True"); 

DataSet ds = new DataSet(); 

da.Fill(ds); 

DataTable dt = ds.Tables[0]; 

comboBox1.DataSource = dt; 
comboBox1.DisplayMember = "city"; //要显示的字段名 
//如果是Web程序的话，加上comboBox1.DataBind();