1.获取单元格所在的列数,行数 (以0开始)
row = datagrid.CurrentCell.RowIndex; //所选cell的行数
column = datagrid.CurrentCell.ColumnIndex;//所选cell所在的列数
1.动态修改cell的值,点击另一行才生效编辑后的cell的值
解决方法:修改完毕之后执行datagrid.EndEdit();即可
1.设置列,行,cell的可编辑性
datagrid.Columns[num].ReadOnly = true;
datagrid.Rows[num].ReadOnly=true;
datagrid.Rows[row].Cells[num].ReadOnly = true;
1.获取某cell的值
datagrid.Rows[row].Cells["colname"].Value
1.设置背景色
datagrid.Rows[row].DefaultCellStyle.BackColor = Color.FromArgb(174, 238, 238); //行
datagrid.Columns[row].DefaultCellStyle.BackColor = Color.FromArgb(174, 238, 238); //列
datagrid.Rows[1].Cells[3].Style.BackColor = Color.FromArgb(174, 238, 238);//cell
1.更新页面datagrid的值( 数据增、删、改后的界面同步,不使用重新加载数据的方式)
//新增
DataRow dr;
dr = (datagrid.DataSource as DataTable).NewRow();
dr["colname1"] = value1;
dr["colname2"] = value2;
(datagrid.DataSource as DataTable).Rows.Add(dr);
(datagrid.DataSource as DataTable).AcceptChanges();
datagrid.ClearSelection();
datagrid.Rows[datagrid.Rows.Count - 1].Selected = true;
//修改
DataRow dr;
dr = (datagrid.DataSource as DataTable).Rows[row];
dr["colname1"] = value1;
dr["colname2"] = value2;
(datagrid.DataSource as DataTable).AcceptChanges();
//删除
DataRow dr;
(datagrid.DataSource as DataTable).Rows.RemoveAt(datagrid.SelectedRows[0].Index);
(datagrid.DataSource as DataTable).AcceptChanges();