1。向DataGridView中插入数据
m_index = this.dataGridView1.Rows.Add();
m_currentTime = DateTime.Now.ToLocalTime().ToString();
this.dataGridView1.Rows[m_index].Cells[0].Value = m_currentTime;
this.dataGridView1.Rows[m_index].Cells[1].Value = m_aName;
this.dataGridView1.Rows[m_index].Cells[2].Value = m_aScore;
this.dataGridView1.Rows[m_index].Cells[3].Value = m_aK;
2。将DataGridView表格自动编号
private void dataGridView1_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e) {
System.Drawing.Rectangle rectangle = new System.Drawing.Rectangle(e.RowBounds.Location.X,
e.RowBounds.Location.Y,
dataGridView1.RowHeadersWidth - 4,
e.RowBounds.Height);
TextRenderer.DrawText(e.Graphics,
(e.RowIndex + 1).ToString(),
dataGridView1.RowHeadersDefaultCellStyle.Font,
rectangle,
dataGridView1.RowHeadersDefaultCellStyle.ForeColor,
TextFormatFlags.VerticalCenter | TextFormatFlags.Right);
}
3。将DataGridView中数据导出到excel表格中
private void btnExport_Click(object sender, EventArgs e)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.Title = "Export Excel File";
saveFileDialog.ShowDialog();
if (saveFileDialog.FileName == "")
return;
Stream myStream;
myStream = saveFileDialog.OpenFile();
StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
string str = "";
try
{
for (int i = 0; i < dataGridView1.ColumnCount; i++)
{