How do I create a csv file with the output of sql query?

by 

public string ExportToCSVFile(DataTable dtTable)
{
    StringBuilder sbldr = new StringBuilder();
    if (dtTable.Columns.Count != 0)
    {
        foreach (DataColumn col in dtTable.Columns)
        {
            sbldr.Append(col.ColumnName.Replace(",", "") + ',');
        }
        sbldr.Append("\r\n");
        foreach (DataRow row in dtTable.Rows)
        {
            foreach (DataColumn column in dtTable.Columns)
            {
                sbldr.Append(row[column].ToString().Replace(",", "").Trim() + ',');
            }
            sbldr.Append("\r\n");
        }
    }
    return sbldr.ToString();
}

More Related Contents:

  1. not able to fetch text using utility in c#
  2. The ViewData item that has the key ‘XXX’ is of type ‘System.Int32’ but must be of type ‘IEnumerable’
  3. Deserialize JSON object into dynamic object using Json.net
  4. Remove trailing zeros
  5. ASP.NET MVC: Custom Validation by DataAnnotation
  6. What is the proper way to rethrow an exception in C#? [duplicate]
  7. Performance surprise with “as” and nullable types
  8. Windows Impersonation from C#
  9. When do static variables get initialized in C#?
  10. Why must I provide explicitly generic parameter types While the compiler should infer the type?
  11. Compare two objects’ properties to find differences?
  12. How to bind list to dataGridView?
  13. .NET Core DI, ways of passing parameters to constructor
  14. How to read the data in a wav file to an array
  15. how to delay shutdown and run a process in window service
  16. How to list available video modes using C#?
  17. How to convert a character in to equivalent System.Windows.Input.Key Enum value?
  18. c# marking class property as dirty
  19. C#: How to convert a list of objects to a list of a single property of that object?
  20. Is there a C# type for representing an integer Range?
  21. ThreadStatic v.s. ThreadLocal: is generic better than attribute?
  22. How to disable navigation on WinForm with arrows in C#?
  23. How to debug System.TypeLoadException errors in .NET?
  24. Ternary operator is twice as slow as an if-else block?
  25. Convert from Oracle’s RAW(16) to .NET’s GUID
  26. How can I maintain ModelState with RedirectToAction?
  27. Allow mapping of dynamic types using AutoMapper or similar?
  28. C# – How can I “overload” a delegate?
  29. How to rotate image x degrees in c#?
  30. How to merge two lists using LINQ?

Leave a Comment