<div>
Can you change your stored procedure.
</div>


<div>
The one way to do this is in SQL Server Management Studio (I'm assuming SSMS here). <a href="https://stackoverflow.com/questions/3169220/export-query-result-to-csv-file-in-sql-server-2008" rel="ugc">Export query result to .csv file in SQL Server 2008</a>. I am assuming though that you want to do this via code. If so, just write the results of the DataSet to a CSV file: <a href="https://stackoverflow.com/questions/8810065/best-way-to-save-dataset-to-a-csv-file" rel="ugc">Best way to save DataSet to a CSV file</a>. <br />
<br />
An interesting comment on the previous article on StackOverflow was to <a href="http://www.filehelpers.net" rel="ugc">use FileHelpers</a>.<br />

<blockquote>
FileHelpers is a free and easy to use .NET library to import or export data from fixed length or delimited records in files, strings or streams.
</blockquote>
. <br />
It's free, why not give that a try?
</div>


The one way to do this is in SQL Server Management Studio (I'm assuming SSMS here). Export query result to .csv file in SQL Server 2008 [https://stackoverflow.com/questions/3169220/export-query-result-to-csv-file-in-sql-server-2008]. I am assuming though that you want to do this via code. If so, just write the results of the DataSet to a CSV file: Best way to save DataSet to a CSV file [https://stackoverflow.com/questions/8810065/best-way-to-save-dataset-to-a-csv-file].

An interesting comment on the previous article on StackOverflow was to use FileHelpers [http://www.filehelpers.net].


> FileHelpers is a free and easy to use .NET library to import or export data from fixed length or delimited records in files, strings or streams.

.
It's free, why not give that a try?

<div>
I feel that there should be an accepted/assisted solution. The author did not respond to any of the experts.
</div>


I feel that there should be an accepted/assisted solution. The author did not respond to any of the experts.

<div>
Hi Dirk,<br />
<br />
Sorry for I do not have response to any of the expert solution because &nbsp;there is no assisted solution on the current problem.
</div>


Hi Dirk,

Sorry for I do not have response to any of the expert solution because  there is no assisted solution on the current problem.

<div>
<div class="content wysiwyg-content">
Hi Expert,<br />
<br />
Please help me export data from my sql to text file with comma delimited format. I have SP that generates the data and i want it from the user interface to download the data and save is as text comma delimited.<br />
<br />
Many Thanks.
</div>
</div>


Hi Expert,

Please help me export data from my sql to text file with comma delimited format. I have SP that generates the data and i want it from the user interface to download the data and save is as text comma delimited.

Many Thanks.

Export data from SQL Store Procedure to text comma delimited

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.