1.设置行标题
for (int i = 0; i < rowcount; i++)
{
dataGridView1.Rows[i].HeaderCell.Value =(i+1).ToString();
}
1'设置行标题文字中心对齐、中心左对齐
dataGridView1.RowHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.RowHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
2.设置第n列的宽度
dataGridView1.Columns[n].Width = 50;
dataGridView1.Columns[0].ReadOnly = true;//不允许编辑
dataGridView1.Columns[0].Resizable = DataGridViewTriState.False;//禁止改变第一列的列宽
for(int i=0;i<dataGridView1.ColumnCount;i++) //所有列禁止排序
{
dataGridView1.Columns[i].SortMode=DataGridViewColumnSortMode.NotSortable;
}
3.向单元格写入数据
dataGridView1.Rows[0].Cells[0].Value="123";
4.水平滚动条或垂直滚动条移动到指定位置
法1:FirstDisplayedScrollingRowIndex和FirstDisplayedScrollingColumnIndex等属性
法2:CurrentCell属性;
dataGridView1.FirstDisplayedScrollingColumnIndex=index0_day;
dataGridView1.CurrentCell=dataGridView1.Rows[0].Cells[index0_day];
5.dataGridView数据导出到Excel
public bool ExportDataGridview(DataGridView dgv, bool isShowExcle)
{
try
{
if (dgv.Rows.Count == 0)
return false;
//建立Excel对象
Excel.Application excel = new Excel.Application();
excel.Application.Workbooks.Add(true);
excel.Visible = isShowExcle;
//生成字段名称
for (int i = 0; i < dgv.Colu
for (int i = 0; i < rowcount; i++)
{
dataGridView1.Rows[i].HeaderCell.Value =(i+1).ToString();
}
1'设置行标题文字中心对齐、中心左对齐
dataGridView1.RowHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
dataGridView1.RowHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
2.设置第n列的宽度
dataGridView1.Columns[n].Width = 50;
dataGridView1.Columns[0].ReadOnly = true;//不允许编辑
dataGridView1.Columns[0].Resizable = DataGridViewTriState.False;//禁止改变第一列的列宽
for(int i=0;i<dataGridView1.ColumnCount;i++) //所有列禁止排序
{
dataGridView1.Columns[i].SortMode=DataGridViewColumnSortMode.NotSortable;
}
3.向单元格写入数据
dataGridView1.Rows[0].Cells[0].Value="123";
4.水平滚动条或垂直滚动条移动到指定位置
法1:FirstDisplayedScrollingRowIndex和FirstDisplayedScrollingColumnIndex等属性
法2:CurrentCell属性;
dataGridView1.FirstDisplayedScrollingColumnIndex=index0_day;
dataGridView1.CurrentCell=dataGridView1.Rows[0].Cells[index0_day];
5.dataGridView数据导出到Excel
public bool ExportDataGridview(DataGridView dgv, bool isShowExcle)
{
try
{
if (dgv.Rows.Count == 0)
return false;
//建立Excel对象
Excel.Application excel = new Excel.Application();
excel.Application.Workbooks.Add(true);
excel.Visible = isShowExcle;
//生成字段名称
for (int i = 0; i < dgv.Colu