Most of the time we used to download the data onto .csv file from website we can also code the same thing by writing this code

protected void Download_Click(object sender, EventArgs e)
{

SqlConnection conn = new SqlConnection(“Server=.;uid=sa;pwd=****;database=practice”);
string query = “select * from rnemp;
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable ds = new DataTable();
da.Fill(ds);
string csv = string.Empty;
foreach (DataColumn column in ds.Columns)
{
csv += column.ColumnName + ‘,’;
}
csv += “\r\n”;
foreach (DataRow row in ds.Rows)
{
foreach (DataColumn column in ds.Columns)
{
csv += row[column.ColumnName].ToString().Replace(“,”, “;”) + ‘,’;
}
csv += “\r\n”;
}
Response.Clear();
Response.Buffer = true;
Response.AddHeader(“content-disposition”, “attachment;filename=SqlExport.csv”);
Response.Charset = “”;
Response.ContentType = “application/text”;
Response.Output.Write(csv);
Response.Flush();
Response.End();
}
}