如何将数据源绑定到datagridview组合框和复选框。 [英] How to bind data source to datagridview combobox and checkbox.

问题描述

我有一个带有组合框和复选框的datagridview。



图片以获得更好的解释



当我尝试从数据表中的datagridview获取值时，它工作正常。但是当我尝试从datagridview的相同方案中从数据库获取值时，它在datagridview中添加行但不设置组合框或复选框值。用于设置我尝试过的数据源。

 DataTable dt = db.getSecurityCheck（dateTimePickerDate.Value）; 
 dataGridView1.DataSource =  null ; 
 dataGridView1.DataSource = dt;`

我是否需要通过为检索到的数据表上的每个循环运行并单独设置每个单元格的值来手动设置值。

解决方案

我猜...



而不是......

 DataGridViewComboBoxColumn dcombo; 
 dcombo.DataSource = db.getBuses（）; 
 dcombo.DisplayMember =   BusId; 
 dcombo.ValueMember =   Id; 

你应该......

 DataGridViewComboBoxColumn dcombo; 
  dcombo = dataGridView1.Columns [  ComboBoxColumnName];  
 dcombo.DataSource = db.getBuses（）; 
 dcombo.DisplayMember =   BusId; 
 dcombo.ValueMember =   Id; 

Hi Chetan这里是关于C中DataGridView中ComboBox的一些有用且有用的链接。



在C＃中使用DataGridView的ComboBox Rahim Khan&＃039的博客 [ ^ ]



C＃中DataGridView中的ComboBox [ ^ ]



[ ^ ]

I have one datagridview with combo-box and check box.

Image for better explanation

when i try to get values from datagridview in data table it works fine. But when i tried to get value from database in same scheme of datagridview it adds rows in datagridview but does not sets combo box or check box value. For setting datasource i tried.

DataTable dt = db.getSecurityCheck(dateTimePickerDate.Value);
dataGridView1.DataSource = null;
dataGridView1.DataSource = dt;`

Do i need to manually set the values by running for each loop on retrieved datatable and setting value for each cell individually.

解决方案

I guess...

Instead of below...

DataGridViewComboBoxColumn dcombo; 
dcombo.DataSource=db.getBuses();
dcombo.DisplayMember = "BusId";
dcombo.ValueMember = "Id";

You should have...

DataGridViewComboBoxColumn dcombo;
dcombo = dataGridView1.Columns["ComboBoxColumnName"];
dcombo.DataSource = db.getBuses();
dcombo.DisplayMember = "BusId";
dcombo.ValueMember = "Id";

Hi Chetan here is some useful and helpful link about ComboBox in DataGridView in C#

ComboBox with DataGridView in C# | A Rahim Khan's Blog[^]

ComboBox in DataGridView in C#[^]

Add ComboBox cell to DataGridview in C# on Cell Enter using DataGridViewComboBoxCell[^]

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