DataGridViewComboboxCell值无效,见代码
public void OnFormLoaded(object sender,EventArgs args)
{
DataTable ts = new DataTable();
ts.Columns.Add("state");
ts.Columns.Add("name");
DataRow row = ts.NewRow();
row["state"] = 0;
row["name"] = "带上架";
ts.Rows.Add(row);
row = ts.NewRow();
row["state"] = 1;
row["name"] = "正常";
ts.Rows.Add(row);
DataGridViewComboBoxColumn comboboxColumn = new DataGridViewComboBoxColumn();
comboboxColumn.DataPropertyName = "state";
comboboxColumn.HeaderText = "状态";
comboboxColumn.DisplayMember = "name";
comboboxColumn.ValueMember = "state";
comboboxColumn.DataSource = ts;
string connStr = "server=10.1.35.92;user=root;database=test;port=3306;password=123456;Allow Zero Datetime=True";
MySqlConnection conn = new MySqlConnection(connStr);
MySqlDataAdapter ada = new MySqlDataAdapter("select state from items limit 0,10", conn);
/** state 只有 0,1两种状态,数据库类型 int **/
DataSet set = new DataSet();
ada.Fill(set);
this.dataGridView1.Columns.Add(comboboxColumn);
this.dataGridView1.AutoGenerateColumns = false;
this.dataGridView1.DataSource = set.Tables[0];
}
总是报: DataGridViewComboboxCell值无效 错误 并且cell显示的也不是汉字,还是数字,当点击下来的时候才会显示汉字,一旦选中,就变回选中的数字了