Generate csv file from sql table

[ththomps]

I am looking to do the following from a C# ASP.Net applicatio
1. Generate a DS from a SQL pull of a single table. Once I have pulled the data (Display to user is not required, just notification that the data has been gathered)
2. Convert the DS to a .CSV format and place the file in a directory with userID and date/time for the file name. IE. JohnD20040430_1, JohnD20040430_2(If a second file placed)

Any suggestions on where to look to find samples to accomplish this

Thanks, Tom

[Bob Barrows [MVP]]

ththomps wrote:

> I am looking to do the following from a C# ASP.Net application
> 1. Generate a DS from a SQL pull of a single table. Once I have
> pulled the data (Display to user is not required, just notification
> that the data has been gathered).
> 2. Convert the DS to a .CSV format and place the file in a directory
> with userID and date/time for the file name. IE. JohnD20040430_1,
> JohnD20040430_2(If a second file placed).
>
> Any suggestions on where to look to find samples to accomplish this?
>
> Thanks, Tom

This is a classic asp newsgroup. While you may be lucky enough to find a
dotnet-savvy person here who can answer your question, you can eliminate the
luck factor by posting your question to an appropriate group. I suggest
microsoft.public.dotnet.framework.aspnet.

HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Yan-Hong Huang[MSFT]]

Hello Tom,

For your questions, please refer to the following:

1) It is an easy work by using dataset. Just run select * from tablename to
get the data. When the function returns, all the data should be in dataset
already.

2) Please refer to
[url]http://weblogs.asp.net/fmarguerie/archive/2003/10/01/29964.aspx[/url] for how to
save the contect in a dataset to a csv file.

Also, Bob is right that it would be best to post these questions in the
following newsgroup.

microsoft.public.dotnet.framework.aspnet

All ASP.NET programming issues, configuration and other questions are
posted in the newsgroup above.

The reason why we recommend posting appropriately is you will get the most
qualified pool of respondents, and other partners who the newsgroups
regularly can either share their knowledge or learn from your interaction
with us. Also, this is to make sure that the responders can better track
the problem.Thank you for your understanding.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C [url]www.microsoft.com/security[/url]
This posting is provided "AS IS" with no warranties, and confers no rights.

[Yan-Hong Huang[MSFT]]

Hi Tom,

Have you successfully resolved this issue? If there is any unclear, please
feel free to post in the group that I recommended or here. Thanks very much.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C [url]www.microsoft.com/security[/url]
This posting is provided "AS IS" with no warranties, and confers no rights.