DataGridView单元格实现下拉和编辑功能设置代码

private ComboBox cmb_Temp = new ComboBox();

public FormDB()

{

InitializeComponent();

}

///

///绑定性别下拉列表框

///

private void BindSex()

{

DataTable dtSex = new DataTable();

dtSex.Columns.Add("Value");

dtSex.Columns.Add("Name");

DataRow drSex;

drSex = dtSex.NewRow();

drSex[0] = "1";

drSex[1] = "int";

dtSex.Rows.Add(drSex);

drSex = dtSex.NewRow();

drSex[0] = "0";

drSex[1] = "char(50)";

dtSex.Rows.Add(drSex);

cmb_Temp.ValueMember = "Value";

cmb_Temp.DisplayMember = "Name";

cmb_Temp.DataSource = dtSex;

cmb_Temp.DropDownStyle = ComboBoxStyle.DropDownList; }

private void FormDB_Load(object sender, EventArgs e)

{

//实现行可编辑

this.dgv_User.Rows[0].ReadOnly = false;

// 绑定性别下拉列表框

BindSex();

//绑定数据表

//BindData();

//添加DataGridView中的行

this.dgv_User.Rows.Add(1);

//设置DataGridView为可编辑

this.dgv_User.ReadOnly = false;

//添加DataGridView中的列

//this.dgv_User.Columns.Add(1);

int i = Convert.ToInt32(this.tbnum.Text);

// 设置下拉列表框不可见

cmb_Temp.Visible = false;

// 添加下拉列表框事件

cmb_Temp.SelectedIndexChanged += new EventHandler(cmb_Temp_SelectedIndexChanged);

// 将下拉列表框加入到DataGridView控件中

this.dgv_User.Controls.Add(cmb_Temp);

}

// 当用户选择下拉列表框时改变DataGridView单元格的内容

private void cmb_Temp_SelectedIndexChanged(object sender, EventArgs e)

{

if (((ComboBox)sender).Text == "int")

{

dgv_User.CurrentCell.Value = "int";

dgv_User.CurrentCell.Tag = "1";

}

else

{

dgv_User.CurrentCell.Value = "char(50)";

dgv_User.CurrentCell.Tag = "0";

}

}

// 滚动DataGridView时将下拉列表框设为不可见

private void dgv_User_Scroll(object sender, ScrollEventArgs e)

{

this.cmb_Temp.Visible = false;

}

// 改变DataGridView列宽时将下拉列表框设为不可见

private void dgv_User_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e) {

this.cmb_Temp.Visible = false;

}

//将datagridView的第二行绑定ComboBox控件实现下拉菜单功能

private void dgv_User_CurrentCellChanged(object sender, EventArgs e)

{

try

{

if (this.dgv_User.CurrentCell.RowIndex == 1)

{

Rectangle rect =

dgv_User.GetCellDisplayRectangle(dgv_User.CurrentCell.ColumnIndex,

dgv_User.CurrentCell.RowIndex, false);

cmb_Temp.Left = rect.Left;

cmb_Temp.Top = rect.Top;

cmb_Temp.Width = rect.Width;

cmb_Temp.Height = rect.Height;

cmb_Temp.Visible = true;

}

else

{

cmb_Temp.Visible = false;

}

}

catch

{

}

}

private void dgv_User_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)

{

this.dgv_User.Rows[e.RowIndex].Cells[e.ColumnIndex].ReadOnly = false;//将当前单元格设为可读

this.dgv_User.CurrentCell =

this.dgv_User.Rows[e.RowIndex].Cells[e.ColumnIndex];//获取当前单元格

this.dgv_User.BeginEdit(true);//将单元格设为编辑状态

}