如何使用asp.net将.txt文件上传到sql数据库(C#)

Question

如何使用asp.net将.txt文件上传到sql数据库(C#)

Answer 1

这是由用户手动完成的事情吗？

如果是这样，那么 ASP.NET MVC 应用程序怎么样？

在您的 视图 中：

<h2>
    Upload A File of Foos</h2>
<%
    Html.BeginForm("LoadFoos", "Admin", FormMethod.Post, new { enctype = "multipart/form-data" });
%>
<label for="foosFile">
    Foos file:
</label>
<input type="file" name="FileUpload1" id="foosFile" /><br />
<input type="submit" name="Submit" id="Submit" value="Upload" />
<%
    Html.EndForm();
%>

在您的 控制器：

public class AdminController : Controller
{
    public ActionResult LoadFoos()
    {
        if (Request.Files.Count > 0)
        {
            // This illustrates how to read the uploaded file contents,
            // and would need to be adapted to your scenario
            List<string> foos = new List<string>();

            using (StreamReader reader = new StreamReader(Request.Files[0].InputStream))
            {
                while (!reader.EndOfStream)
                {
                    string line = reader.ReadLine();

                    foos.Add(line);
                }
            }

            // TODO: use LINQ 2 SQL, NHibernate or ADO.NET to load the foos directly,
            // or call a web/WCF service behind your firewall that does this
        }

        return View();
    }
}