时间戳

首页 > 解决方案 > C# asp.net mvc 下载表到csv

c# - C# asp.net mvc 下载表到csv

问题描述

我制作了这段代码来下载带有数据库元素的 cvs 文件，但我无法通过数据库。
如果我运行该函数，浏览器会下载一个带有默认行的 cvs。

你能帮我吗？？

控制

public FileContentResult DownloadCSV(List<Movie> List)
{
            string csv = "\"ID\",\"Title\",\"Release Date\",\"Genere\",\"Price\",\"Rating\" \n";
            foreach (Movie item in List)
            {
                csv = csv + String.Format("\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\" \n",
                                           item.Id,
                                           item.Title,
                                           item.ReleaseDate,
                                           item.Genre,
                                           item.Price,
                                           item.Rating);
            }
            //StringWriter sw = new StringWriter();
            //sw.WriteLine("\"ID\",\"Title\",\"Release Date\",\"Genere\",\"Price\",\"Rating\"");
            return File(new System.Text.UTF8Encoding().GetBytes(csv), "text/csv","Report123.csv");
        }

查看页面

@model Database.Models.MovieGenreViewModel

@{
    ViewData["Title"] = "Index";
}

<h1>Index</h1>

<p>
    <a asp-action="Create">Create New</a>
</p>
<form asp-controller="Movies" asp-action="Index" method="get">
    <p>

        <select asp-for="MovieGenre" asp-items="Model.Genres">
            <option value="">All</option>
        </select>

        Title: <input type="text" asp-for="SearchString" />
        <input type="submit" value="Filter" />

        @*<a href="MoviesController/DownloadCSV">Download CSV</a>*@
        <a asp-action="DownloadCSV" asp-route-list ="@Model.Movies">Edit</a>
    </p>
</form>

标签： c#asp.netasp.net-mvcdatabase

解决方案

您的DownloadCSV操作需要一个电影列表，我认为它是空的。

您可以按如下方式更改方法：

public FileContentResult DownloadCSV()
{
            string csv = "\"ID\",\"Title\",\"Release Date\",\"Genere\",\"Price\",\"Rating\" \n";
            List<Movie> List = db.Movies; //get this list from database 
            foreach (Movie item in List)
            {
                csv = csv + String.Format("\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\" \n",
                                           item.Id,
                                           item.Title,
                                           item.ReleaseDate,
                                           item.Genre,
                                           item.Price,
                                           item.Rating);
            }
            //StringWriter sw = new StringWriter();
            //sw.WriteLine("\"ID\",\"Title\",\"Release Date\",\"Genere\",\"Price\",\"Rating\"");
            return File(new System.Text.UTF8Encoding().GetBytes(csv), "text/csv","Report123.csv");
        }

推荐阅读