Asp.net save dataset to file

Write sb. ToString ; HttpContext. Ortund 1. Niranjan Singh Niranjan Singh Your code to write the CSV file is incomplete. If a field contains a comma, it will not be parsed correctly by programs like Excel.

JonathanWood: I have not tested the code completly and may be you better know that stackoverflow is not code provider side. Please see my stackoverflow score and you'll probably see that I do know what stackoverflow is about.

Yes, I think your answer was helpful. But it was incomplete and the OP may not realize that. Depending on his data, it might in fact not be enough to solve their problem. That's why I pointed it out. JonathanWood: Well thanks for the suggestion. I pointed that link in reference because that was belong to asp.

Jonathan Wood Jonathan Wood Sounds way too complicated ContentType " for the user to be prompted to "Save" the. Which part was too complicated?

Did you see that the second article did set Response. BTW, the second article mentioned seems to basically be what you suggested in your answer. But the first has a more complete implementation of CSV handling. Viewed 3k times. Keron Tzul 73 4 4 bronze badges. Manoj Maharana Manoj Maharana 52 1 1 silver badge 12 12 bronze badges.

Possible duplicate of Export a C DataSet to a text file — kgzdev. Add a comment. Active Oldest Votes. If you need one file per row, you can do it like this: foreach DataRow dr in dt. WriteLine line ; sw. StreamWriter object. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode.

Is this page helpful? Posted Oct pm Praneet Nadkar. Am Gayathri Oct am. Hi Praneeth, Great Thanks a lot One more doubt can i put line break in cell vale? Hi, In that case you will have to check while writing to the cell value and write your own login based on your DataTable.

NewLine in between to work it as break. Regards, Praneet. Its going to next cell line. Hi, For formatting you will have to create a workbook using interop. Like this: 1. Posted Oct am Praneet Nadkar. Thanks Praneet. Hi Praneet, This works in local but when run this in my server below error is coming System.