//我就是想实现dataGridView1的Id字段,
//当Id=1时显示“男”,当Id=0时显示“女”ClassOne co = new ClassOne();//自定义的类
DataTable tt = co.Get_dt("select Id,Name from sextbl");
DataGridViewComboBoxColumn da = new DataGridViewComboBoxColumn();//创建新列
{
da.DataPropertyName = "Id";
da.HeaderText = "性别";
//da.Items.Add("0");
//da.Items.Add("1");
da.DataSource = tt;
da.DisplayMember = tt.Columns["Name"].ColumnName;
da.ValueMember = tt.Columns["Id"].ColumnName;
this.dataGridView1.Columns.Add(da);
}string s = "select * from depttbl ";
DataTable dt = co.Get_dt(s);
dataGridView1.DataSource = dt;
运行出现错误:DataGridView 中发生以下异常:
system.FormatException:DataGridviewComboBoxCell值无效
要替换些默认对话框,请处理DataError事件.
//当Id=1时显示“男”,当Id=0时显示“女”ClassOne co = new ClassOne();//自定义的类
DataTable tt = co.Get_dt("select Id,Name from sextbl");
DataGridViewComboBoxColumn da = new DataGridViewComboBoxColumn();//创建新列
{
da.DataPropertyName = "Id";
da.HeaderText = "性别";
//da.Items.Add("0");
//da.Items.Add("1");
da.DataSource = tt;
da.DisplayMember = tt.Columns["Name"].ColumnName;
da.ValueMember = tt.Columns["Id"].ColumnName;
this.dataGridView1.Columns.Add(da);
}string s = "select * from depttbl ";
DataTable dt = co.Get_dt(s);
dataGridView1.DataSource = dt;
运行出现错误:DataGridView 中发生以下异常:
system.FormatException:DataGridviewComboBoxCell值无效
要替换些默认对话框,请处理DataError事件.
select case Id when '1' then '男' when '0' then '女' end,Name from sextbl
DataGridViewComboBoxColumn
来实现,怎么实现呢?