Dynamically generate CSV file from Database by retaining delimited character (comma) using C# and VB.Net in ASP.Net

Question

hi i have try to  create dynamiclly in vbnetwith help of this httpswwwaspsnippetscomArticlesDynamicallycreateanddownloadCSVfileinASPNetusingCandVBNetaspxbut when i used this code my data has been separated  for commaand i  want to change comma separater to semicomma  please help me how to separatedr csv file

AnandM · Accepted Answer

Hi  serivermaYou need to do workaround for getting the single value with comma as in single column in csv by creating a method which will return the same value by adding the quotes with escape sequenceRefer below sample code and implement according to your needHTMLltaspButton Text34Export34 OnClick34ExportCSV34 runat34server34 gtVBNetProtected Sub ExportCSVsender As Object e As EventArgs    Dim constr As String  ConfigurationManagerConnectionStrings34constr34ConnectionString    Using con As New SqlConnectionconstr        Using cmd As New SqlCommand34SELECT 39abcv39 column139assfffff kkklf39 column2 FROM Customers34            Using sda As New SqlDataAdapter                cmdConnection  con                sdaSelectCommand  cmd                Using dt As New DataTable                    sdaFilldt                    39Build the CSV file data as a Comma separated string                    Dim csv As

Dynamically generate CSV file from Database by retaining delimited character (comma) using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us