C#中DataGridView常用操作实例小结

public void Binder1(){ DataTable tableType = DataBase.SQLDBHelper.GetDataTable("select top 200 unit_code,unit_name from unit "); DataTable table = DataBase.SQLDBHelper.GetDataTable("select top 2 * from TempProduct"); DataGridViewRow dgvr; foreach (DataRow row in table.Rows) {  dgvr = new DataGridViewRow();  dgvr.CreateCells(dataGridView);  dgvr.Cells[0].Value = row["Id"].ToString();  dgvr.Cells[1].Value = row["Name"].ToString();  dgvr.Cells[2].Value = row["Age"].ToString();  dgvr.Cells[3].Value = row["Address"].ToString();  //绑定下拉列表  DataGridViewComboBoxColumn dgvcbc = dataGridView.Columns[4] as DataGridViewComboBoxColumn;  if (dgvcbc != null)  {   //绑定下来列表   dgvcbc.DataSource = tableType;   dgvcbc.DisplayMember = "unit_name";   dgvcbc.ValueMember = "unit_code";  }  //为下拉列表设置默认值  dgvr.Cells[4].Value = row["EntryId"].ToString();  //设置复选框是否选中  dgvr.Cells[5].Value = row["flag"].ToString() == "0" ? true : false;  //在列表中找到DataGridViewLinkColumn  DataGridViewLinkColumn links = dataGridView.Columns[6] as DataGridViewLinkColumn;  if (links != null)  {   //需要设置DataGridViewLinkColumn的UseColumnTextForLinkValue属性为true才会有作用   links.Text = "点击查看";  }  //在列表中找到DataGridViewButtonColumn  DataGridViewButtonColumn button = dataGridView.Columns[7] as DataGridViewButtonColumn;  if (button != null)  {   //需要设置DataGridViewButtonColumn的UseColumnTextForLinkValue属性为true才会有作用   button.Text = "点击查看";  }  dataGridView.Rows.Add(dgvr); }}