Export DataTable to Excel/CSV using C#

I was working on a project and my client asked me to export data to excel or .csv file. do you know how easy is this, Just by using StreamWriter I exported a DataTable to excel .csv file.

and here is the code

for this article I used Northwind database and Employees table from MS SQL server.

   private void ExportToExcel()
        {
            try
            {
                SqlConnection Con = new SqlConnection("Server=(local);Database=NorthWind; Integrated Security=TRUE");
                Con.Open();
                SqlDataAdapter adapter = new SqlDataAdapter(
                    "SELECT EmployeeID, LastName, FirstName, Title, Address, City, Region, PostalCode, Country FROM Employees"
                    , Con);
                DataSet employees = new DataSet();
                adapter.Fill(employees, "Employees");
                string strSave = null;

                foreach (DataColumn columns in employees.Tables["Employees"].Columns)
                {
                    strSave += columns.ColumnName.ToString() + ",";
                }

                strSave = strSave.Substring(0, strSave.Length - 1) + Environment.NewLine;

                foreach (DataRow dr in employees.Tables["Employees"].Rows)
                {
                    strSave +=
                        dr["EmployeeID"].ToString() + "," +
                        dr["FirstName"].ToString() + "," +
                        dr["LastName"].ToString() + "," +
                        dr["Title"].ToString() + "," +
                        dr["Address"].ToString() + "," +
                        dr["City"].ToString() + "," +
                        dr["Region"].ToString() + "," +
                        dr["PostalCode"].ToString() + "," +
                        dr["Country"].ToString() + Environment.NewLine;
                }
                StreamWriter writer = new StreamWriter(@"C:\book1.csv");
                writer.Write(strSave);
                writer.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

At first I assigned all details from query to a database and looped over columns to get the columns and then looped over rows and concatenated whit the strSave variable and saved it in a path using StreamWriter

Wasn't it very easy.... ;)