Outputing SQL to CSV - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Outputing SQL to CSV

Message

From

30/10/2009 08:11:02

30/10/2009 02:46:42

General information

Forum:

ASP.NET

Category:

Databases

Title:

Environment versions

Environment:

VB.NET 1.1

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

MS SQL Server

Application:

Web

Miscellaneous

Thread ID:

01432335

Message ID:

01432349

Views:

>Hi all
>
>My app in VB.NET and my DB is MSSQL 2005
>
>May I know how I can execute a SQL to return the results to a CSV file from my VB.NET web app?
>
>Your advice much appreciated
>
>Thanks & Best Regards

Please read this article http://www.aspsnippets.com/post/2009/05/20/Export-DataSet-or-DataTable-to-Word-Excel-PDF-and-CSV-Formats.aspx that shows ways to output datatable into different formats.

If it's not broken, fix it until it is.

My Blog