Exporting datagridview to csv file

by

LINQ FTW!

var sb = new StringBuilder();

var headers = dataGridView1.Columns.Cast<DataGridViewColumn>();
sb.AppendLine(string.Join(",", headers.Select(column => "\"" + column.HeaderText + "\"").ToArray()));

foreach (DataGridViewRow row in dataGridView1.Rows)
{
    var cells = row.Cells.Cast<DataGridViewCell>();
    sb.AppendLine(string.Join(",", cells.Select(cell => "\"" + cell.Value + "\"").ToArray()));
}

And indeed, c.Value.ToString() will throw on null value, while c.Value will correctly convert to an empty string.

More Related Contents:

  1. Null Reference Exception when int parsing DataGridView row values
  2. Append lines to a file using a StreamWriter
  3. How to format DateTime columns in DataGridView?
  4. right click context menu for datagridview
  5. How can I refresh c# dataGridView after update ?
  6. DataGridView bound to a Dictionary
  7. Unable To set row visible false of a datagridview
  8. Using a list as a data source for DataGridView
  9. DataGridView checkbox column – value and functionality
  10. How to refresh or show immediately in datagridview after inserting?
  11. How to filter data using Entity Framework in a way that DataGridView be editable and context track changes?
  12. Adding a Line to the Middle of a File with .NET
  13. How to create a Button that can send keys to a conrol without losing focus – Virtual Keyboard
  14. Rows cannot be programmatically added to the datagridview’s row collection when the control is data-bound
  15. Button in a column, getting the row from which it came on the Click event handler
  16. How to set DataGridView textbox column to multi-line?
  17. Check/Uncheck a checkbox on datagridview
  18. Index was out of range. Must be non-negative and less than the size of the collection parameter name:index
  19. Reading data from DataGridView in C#
  20. Open dropdown(in a datagrid view) items on a single click
  21. WinForms DataGridView – databind to an object with a list property (variable number of columns)
  22. Datagridview full row selection but get single cell value
  23. Populating a DataGridView with Text and ProgressBars
  24. DataGridView bound to BindingList does not refresh when value changed
  25. C#: Custom sort of DataGridView
  26. How to move focus on next cell in a datagridview on Enter key press event
  27. How to display an image in a datagridview column header?
  28. DataGridView not showing properites of objects which implement ICustomTypeDescriptor
  29. DataGridView changing cell background color
  30. Sort dataGridView columns in C# ? (Windows Form)

Leave a Comment