想要在设计时将一个DataGridViewComboBoxColumn插入到DataGridView控件中，并在运行时访问它并用它填充数据 [英] want to insert one DataGridViewComboBoxColumn to DataGridView control at design time, and access it and populate data with it at run time

问题描述

我想在设计时将一个DataGridViewComboBoxColumn插入DataGridView控件，并在运行时访问它并用它填充数据

我在Google上看到了很多看起来像这样的代码

I want to insert one DataGridViewComboBoxColumn to DataGridView control at design time, and access it and populate data with it at run time

I have seen lots of code on google which looks like this

DataGridViewComboBoxColumn colComboColumn = new DataGridViewComboBoxColumn(); 
DataTable dtbElements = new DataTable(); 
MySqlDataAdapter dbaElements = new MySqlDataAdapter(strSQLSelect, conn); 
// Set some parameters for the ComboBoxColumn 
colComboColumn.Name = strColName; 
colComboColumn.DisplayMember = strDisplay; 
colComboColumn.ValueMember = strValue; 
// Add the Elements 
dbaElements.Fill(dtbElements); 
colComboColumn.DataSource = dtbElements; 

我无法引用comboboxcolumn数据源或displaymember属性
像这个gridview1.column [2] .datasource ="xyz"

要实现这一目标需要什么?


问候
Omer

I cannot refer to the comboboxcolumn datasource or displaymember property
like this gridview1.column[2].datasource = "xyz"

what is required to achieve this ?


Regards
Omer

推荐答案

我正在使用radgridview，因此如果使用Visual Studio网格视图使用DataGridViewComboboxcolumn，则必须使用GridViewComboBoxColumn，它将起作用...

I was using a radgridview so had to use GridViewComboBoxColumn if using a visual studio grid view use DataGridViewComboboxcolumn and it will work...

DataTable dtstatus = new DataTable();
           dtstatus = getstatus();

            ((GridViewComboBoxColumn)radGridView2.Columns["status"]).DataSource = dtstatus ;
            ((GridViewComboBoxColumn)radGridView2.Columns["status"]).ValueMember = "status_code" ;
            ((GridViewComboBoxColumn)radGridView2.Columns["status"]).DisplayMember = "status_description";



 private DataTable  getstatus()
       {

           string statquery = "select status_code,status_description from status_codes";
           MySqlDataAdapter statadapter = new MySqlDataAdapter(statquery, conn);
           MySqlCommandBuilder cbs = new MySqlCommandBuilder(statadapter);

           DataSet statds = new DataSet();

           statadapter.Fill(statds);
           return statds.Tables[0];
       }

这篇关于想要在设计时将一个DataGridViewComboBoxColumn插入到DataGridView控件中，并在运行时访问它并用它填充数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！