C#中DataGridView控件的详解，将DataGridView数据保存到本地xml文件，从xml文件中读取数据，导出数据到excel表格

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++)
                {