Call BCP in C# with header columns

Question

How can I call BCP (bulk copy SQl Server) with Header columns in C# to export data from sql server to a text file. Can you show me some examples?

Vulpes · Answer

Well first of all here's a link which shows how to call the BCP utility from C#: http://social.msdn.microsoft.com/Forums/en-US/cfb40e41-d6c9-4b0c-a1de-c10230588fcc/bcp-utility-using-c-?forum=adodotnetdataproviders Unfortunately the BCP utility doesn't have a straightforward option to include column headers with the data. However I found another link where someone's had the bright idea of using the 'queryout' option and then using UNION ALL to link a list of column headers with the rows of the datatable: http://stackoverflow.com/questions/1355876/export-table-to-file-with-column-headers-column-names-using-the-bcp-utility-an Hopefully you'll be able to figure something out from this.

j c · Answer

Thannk you