Completely Free .NET word API

Resources » Code Snippets » DataGridView

Export DataGridView into .csv file

Updated: Category: DataGridView
Author: Member Level: GoldPoints: 12

Following example I am trying to save the DataGridView's Data into .csv file

Please create a Windows Application and Add a DataGridView and a button on Form1, and please use following code.

I have explained code inline

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace DataGridView_ExportToCSV
public partial class Form1 : Form
public Form1()

private void Form1_Load(object sender, EventArgs e)
//Fetch the Employee details
SqlDataAdapter sqlDa = new SqlDataAdapter("Select EmployeeID, firstname," +
"Lastname from Employees",
DataSet ds = new DataSet();
//Fill the DataSet
sqlDa.Fill(ds, "Employees");
//Set the DataSource of DataGrid View
dataGridView1.DataSource = ds.Tables[0];

private void button1_Click(object sender, EventArgs e)
string strExport = "";
//Loop through all the columns in DataGridView to Set the
//Column Heading
foreach (DataGridViewColumn dc in dataGridView1.Columns)
strExport += dc.Name + " ";
strExport = strExport.Substring(0, strExport.Length - 3) + Environment.NewLine.ToString();
//Loop through all the row and append the value with 3 spaces
foreach (DataGridViewRow dr in dataGridView1.Rows)
foreach (DataGridViewCell dc in dr.Cells)
if (dc.Value != null)
strExport += dc.Value.ToString() + " ";
strExport += Environment.NewLine.ToString();
strExport = strExport.Substring(0, strExport.Length - 3) + Environment.NewLine.ToString();
//Create a TextWrite object to write to file, select a file name with .csv extention
System.IO.TextWriter tw = new System.IO.StreamWriter("data.csv");
//Write the Text to file
//Close the Textwrite

Please find attached source code.

Hope this helps.

SatishKumar J
Microsoft MVP(ASP.NET)

Did you like this resource? Share it with your friends and show your love!

Responses to "Export DataGridView into .csv file"
Guest Author: Ali Danish   06 Mar 2012
Thanks a lot, i was searching last two days for exporting Datagridview to excel and csv. finally i got right solution.
your article is so clear. It working properly.

Guest Author: lynx   29 Jun 2012
thank you


Post Comment:

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:   Sign In to fill automatically.
    Email: (Will not be published, but required to validate comment)

    Type the numbers and letters shown on the left.

    Submit Article     Return to Article Index
    Subscribe to Subscribers
    Active Members
    TodayLast 7 Daysmore...

    Awards & Gifts
    Talk to Webmaster Tony John

    Online Members

    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India