Download CSV format with SQL table header

Question

hi frnds anyone share the in a webpage download csv excel format samle records with table header also using sql server

Nilesh Shah · Answer

SQL will give you result in table format only it's upto you to convert that table into CSV format and write it to a text file. Once data is written to a text file you can show it to user in a popup or give option to download. sample code is here: SqlConnection sqlCon = new SqlConnection( myConnection ); sqlCon.Open(); SqlCommand sqlCmd = new SqlCommand( Select * from myTable  sqlCon); SqlDataReader reader = sqlCmd.ExecuteReader(); string fileName = test.csv ; StreamWriter sw = new StreamWriter(fileName); object [] output = new object [reader.FieldCount]; for ( int i = 0; i output[i] = reader.GetName(i); sw.WriteLine( string .Join(   output)); while (reader.Read()) { reader.GetValues(output); sw.WriteLine( string .Join(   output)); } sw.Close(); reader.Close(); sqlCon.Close();

Kumaran P · Answer

HI NILESH VERY THANKS