C#中DataGridView常用操作 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);
 }
}