save csv file to my folder

Question

actly i want to make a csv file from query .. then i want to save this csv file with random name to my excel folder. i am unable to save csv file my random name and to my excel folder .. plz help Response.AddHeader(content-disposition attachment;filename=SqlExport.txt);

Joginder Banger · Answer

Hi Akash Singh what type of error you faced I think this is not a enough information. I think this is best way you can follow this code. string FilePath=your save file path. var csv = new StringBuilder(); var newLine = string.Format({0}{1} your data Environment.NewLine); csv.Append(newLine); File.WriteAllText(filePath csv.ToString()); for more information try below link http://www.codeproject.com/Articles/415732/Reading-and-Writing-CSV-Files-in-Csharp Best of Luck _jsb

Karthikeyan K · Answer

Hi sir try this Response.AddHeader(content-disposition attachment;filename= + Filename); If it is useful then accept my answer Karthikeyan K

Anurag Sarkar · Answer

Hi Please try this code and refer the link http://www.c-sharpcorner.com/UploadFile/83fe73/solutions-to-export-data-from-database-to-excel-in-C-Sharp/ Thanks