1. /// <summary>
    2. /// 将DataGridView转为DataTable
    3. /// </summary>
    4. /// <param name="Dgv">DataGridView控件名</param>
    5. /// <param name="dt">DataTable表(数据库结构)</param>
    6. /// <returns>DataTable</returns>
    7. public static DTable GetDgvToTable(DataGridView dgv)
    8. {
    9. DTable table = new DTable();
    10. for (int iCol = 0; iCol < dgv.Columns.Count; iCol++)
    11. {
    12. table.Columns.Add(dgv.Columns[iCol].Name);
    13. }
    14. foreach (DataGridViewRow row in dgv.Rows)
    15. {
    16. DataRow datarw = table.NewRow();
    17. for (int iCol = 0; iCol < dgv.Columns.Count; iCol++)
    18. {
    19. datarw[iCol] = row.Cells[iCol].Value;
    20. }
    21. table.Rows.Add(datarw);
    22. }
    23. return table;
    24. }
    25. /// <summary>
    26. /// 将DataTable转为DataGridView
    27. /// </summary>
    28. /// <param name="Dgv">DataGridView控件名</param>
    29. /// <param name="dt">DataTable表(数据库结构)</param>
    30. /// <returns>DataGridView</returns>
    31. public static void GetTableToDgv(DataGridView dgv, DTable table)
    32. {
    33. dgv.Rows.Clear();
    34. foreach (DataRow row in table.Rows) dgv.Rows.Add(row.ItemArray);
    35. }