从SQL表将它添加到datagridview组合框列 [英] Adding itms to datagridview combobox column from sql table

问题描述

我有一个名为"test"的表，其中有一个名为"fname"的列
和datadridview组合框列
我希望将列fname项添加到datagridview每行的第一个单元格中

I have a table named ''test'' in that have a column named ''fname''
and datadridview combobox column
i want column fname items should be add in datagridview every row''s first cell

推荐答案

DataGridViewComboBoxColumn dc = new DataGridViewComboboxColumn();
dc.DataSource = dt;
dc.ValueMember = "ID";
dc.TextMember = "Name";
 
DataGridView1.Columns.Add("ColumnName", dc);

where dt = datatable.

请参考:
DataGrid中的组合框 [ http://msdn.microsoft.com/en-us/library/system. windows.forms.datagridviewcomboboxcolumn.aspx [ ^ ]
演示如何使用DataGridViewComboBoxColumn协助将数据输入到TitleOfCourtesy列中.

Please refer:
ComboBox in DataGrid[^]

http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewcomboboxcolumn.aspx[^]
Demonstrates how to use a DataGridViewComboBoxColumn to aid in entering data into the TitleOfCourtesy column.

这篇关于从SQL表将它添加到datagridview组合框列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！