DataGridView(DataGridViewComboBoxCell)总结
花了两天时间,终于对 DataGridView 有了一点了解,为了赚点分,拿出来和大家分享分享^O^
1. 获得当前选中行:
int rowIndex = this.dataGridView1.CurrentCell.RowIndex;
2. 为 DataGridView 中添加一行数据:
如果 DataGridView 的 Cells 是 DataGridViewTextBoxCellde
this.dataGridView1.Rows.Add(“value1”,”value2”,”valueN”);的方式添加。
如果 DataGridView 的 Cells 中包含 DataGridViewComboBoxCell
int index = this.dataGridView1.Rows.Add();
DataGridViewRow dataGridRow = this.dataGridView1.Rows[index];
DataGridViewComboBoxCell dataGridViewCbo = row.Cells[dataGridViewCbo_index] as
DataGridViewComboBoxCell;
if (dataGridViewCbo != null)
{
dataGridViewCbo.Items.Add("itemValue1");
dataGridViewCbo.Items.Add("itemValue2");
dataGridViewCbo.Items.Add("itemValue3");
}
row.Cells[next_Index].Value = " Value2";
row.Cells[next_Index].Value = " Value3";
row.Cells[next_Index].Value = " ValueN";
3. 为DataGridView中DataGridViewComboBoxCell数据绑定:
DataSet dataSet = null;
using (SqlConnection connection = new SqlConnection("Data Source=忧伤的一点~;Initial
Catalog=test;Integrated Security=SSPI"))
{
dataSet = new DataSet();
SqlDataAdapter ss = new SqlDataAdapter("select * from test", connection); ;
ss.Fill(dataSet);
}
InitializeComponent();
DataGridViewComboBoxColumn dataCridCbo = this.dataGridView1.Columns["列名"] as
DataGridViewComboBoxColumn;
dataCridCbo.DataSource = dataSet.Tables[0];
dataCridCbo.DataPropertyName = "绑定数据的列名";
dataCridCbo.ValueMember = "绑定数据的列名";
4. 得到DataGridView中的值
this.dataGridView1.Rows[row].Cells[col].Value.ToString();
- 1
- 2
- 3
- 4
- 5
- 6
前往页