Solved: How to save a generated CSV file on server drive.

Hello , I am able to create a csv file but I don't know how to automatically save it on the server drive.
Here is the code that creates the CSV file

        string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand("GIS_dasboard1"))
            {
                cmd.CommandType = CommandType.StoredProcedure;
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {

                    cmd.Connection = con;
                    sda.SelectCommand = cmd;

                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        //Build the CSV file data as a Comma separated string.
                        string csv = string.Empty;
                        foreach (DataColumn column in dt.Columns)
                        {
                            csv += column.ColumnName + ';';
                        }

                        csv += "\r\n";
                        foreach (DataRow row in dt.Rows)
                        {
                            foreach (DataColumn column in dt.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();

                    }

                }
               }

        }

Open in new window