Hi there I am having problems developing a C# application that sorts the data in an SQL database by a particular column and then outputs it to a csv file on my hard drive. I want to do something like this:

SqlCommand sqlComm = new SqlCommand("SELECT * FROM TableA ORDER BY ColumnB
INTO OUTFILE ‘C:\output_file.csv’", myConnection);

Is this the right way to go about it? Thanks in advance