刚做过的一个项目里面的一段,如下: //获取数据表 voltage 为数据表 sql = "select * from Voltage order by Voltage_ID"; voltage = linkAccess.GetDBTabFromOEquipment(sql, conn); if (voltage.Rows.Count > 0) { foreach (DataRow dr in voltage.Rows) { // ColumnVoltage 是DataGridViewComboBoxColumn ColumnVoltage.Items.Add(dr[1].ToString()); } //设置默认值 comboBoxVoltage.SelectedIndex = 0; } 给分吧~
DataGridViewComboBoxColumn dgvCbl = new DataGridViewComboBoxColumn();
dgvCbl.HeaderText = "类别";
// dgvCbl.DataSource =; 绑定数据源
this.dataGridView1.Columns.Add(new DataGridViewComboBoxColumn());
//获取数据表 voltage 为数据表
sql = "select * from Voltage order by Voltage_ID";
voltage = linkAccess.GetDBTabFromOEquipment(sql, conn);
if (voltage.Rows.Count > 0)
{
foreach (DataRow dr in voltage.Rows)
{
// ColumnVoltage 是DataGridViewComboBoxColumn
ColumnVoltage.Items.Add(dr[1].ToString());
}
//设置默认值
comboBoxVoltage.SelectedIndex = 0;
}
给分吧~