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 · Accepted 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 < reader.FieldCount; 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