如何在ASP.NET MVC中上传1gb文件 [英] How to upload 1gb files in ASP.NET MVC

问题描述

我想在我的sql server上上传1gb视频文件，但得到了http：错误404.13。

请给一些建议来解决这个问题。



我尝试过：



WebConfig部分

< system.web>

<身份验证模式=无/>

<编译debug =truetarget Framework =4.5.2/>

< httpRuntime目标框架=4.5.2执行超时=999999最大请求长度=294857600/>

< /system.web>



控制器部分

公共ActionResult商店（[Bind（Include =Mname，Mgenre，Mruntime，Mreleasedate，Mcreators） ，Mpath，Mdescription，Mstars，Mimage）] AdminUpload Aupload，IEnumerable< httppostedfilebase> upload）



{



string constrr = ConfigurationManager.ConnectionStrings [Mymoviestore]。ToString（）;

SqlConnection con = new SqlConnection（constrr）;

if（upload.ElementAt（ 0）！= null）

{

var file1 = upload.ElementAt（0）;

if（file1！= null&& ; file1.ContentLength> 0）



{

string filename = System.IO.Path.GetFileName（file1.FileName）;

file1.SaveAs（Server.MapPath（〜/ Movie /+ filename））

SqlCommand cmd = new SqlCommand（sp_MovieDB，con）;

cmd.CommandType = CommandType.StoredProcedure;

con.Open（）;

cmd.Parameters.AddWithValue（@ Mname，Aupload.Mname）;

cmd.Parameters.AddWithValue（@ Mgenre，Aupload.Mgenre）;

cmd.Parameters.AddWithValue（@ Mruntime，Aupload.Mruntime）;

cmd.Parameters.AddWithValue（@ Mreleasedate，Aupload.Mreleasedate）;

cmd.Parameters.AddWithValue（@ Mcreators，Aupload.Mcreators）;

cmd.Parameters.AddWithValue（@ Mpath，〜/ Movie /+ file1.FileName）;

cmd.Parameters.AddWithValue（@ Mdescription，Aupload.Mdescription）;

cmd.Parameters.AddWithValue（@ Mstars，Aupload.Mstars）;

cmd.Parameters.AddWithValue（@ Mimage，〜/ Coverimage /+ filename）;

cmd.Parameters.Add（@ err，SqlDbType.VarChar，50）;

cmd.Parameters [@ err]。Direction = ParameterDirection.Output;

cmd.ExecuteNonQuery（）;

string result =（cmd.Parameters [@ err]。Value.ToString（））;

con.Close（）;

ViewBag.Message =结果;

ModelState.Clear（）;



}

解决方案

您可以使用以下链接解决此问题： -

处理ASP.NET Web API中的大文件StrathWeb。一个自由流动的网络技术独白。 [ ^ ]

 <  配置 >  
 <   system.web  >  
 <！ -    这将处理高达1024MB（1GB）   - >   
 <   httpRuntime     maxRequestLength   =  1048576    timeout   =  3600    /  >  
 <   / system.web  >  
 <   / configuration  >  
 
 <！ -     IIS特定目标（由system.webServer部分）   - >   
 <   system.webServer  >  
 <  安全 >  
 <   requestFiltering  >  
 <！ -    这将处理高达1024MB（1GB）的请求   - >   
 <   requestLimits     maxAllowedContentLength   =  1048576000    /  >  
 <   / requestFiltering  >  
 <   /安全性 >  
 <   / system.webServer  >  

Google [ ^ ]

Hi,

I am trying to upload 1gb video files on my sql server but got http:error 404.13.
Please give some suggestion to solve the issue.

What I have tried:

WebConfig Part
< system.web >
< authentication mode="None" />
< compilation debug="true" target Framework="4.5.2" />
< httpRuntime target Framework="4.5.2" execution Timeout="999999" max Request Length="294857600" />
< /system.web>

Controller part
public ActionResult Store([Bind(Include = "Mname,Mgenre,Mruntime,Mreleasedate,Mcreators,Mpath,Mdescription,Mstars,Mimage")]AdminUpload Aupload,IEnumerable<httppostedfilebase> upload)

{

string constrr = ConfigurationManager.ConnectionStrings["Mymoviestore"].ToString();
SqlConnection con = new SqlConnection(constrr);
if (upload.ElementAt(0) != null)
{
var file1 = upload.ElementAt(0);
if (file1 != null && file1.ContentLength > 0)

{
string filename = System.IO.Path.GetFileName(file1.FileName);
file1.SaveAs(Server.MapPath("~/Movie/" + filename))
SqlCommand cmd = new SqlCommand("sp_MovieDB", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.Parameters.AddWithValue("@Mname", Aupload.Mname);
cmd.Parameters.AddWithValue("@Mgenre", Aupload.Mgenre);
cmd.Parameters.AddWithValue("@Mruntime", Aupload.Mruntime);
cmd.Parameters.AddWithValue("@Mreleasedate", Aupload.Mreleasedate);
cmd.Parameters.AddWithValue("@Mcreators", Aupload.Mcreators);
cmd.Parameters.AddWithValue("@Mpath", "~/Movie/" + file1.FileName);
cmd.Parameters.AddWithValue("@Mdescription", Aupload.Mdescription);
cmd.Parameters.AddWithValue("@Mstars", Aupload.Mstars);
cmd.Parameters.AddWithValue("@Mimage", "~/Coverimage/" + filename);
cmd.Parameters.Add("@err", SqlDbType.VarChar, 50);
cmd.Parameters["@err"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
string result = (cmd.Parameters["@err"].Value.ToString());
con.Close();
ViewBag.Message = result;
ModelState.Clear();

}

解决方案

You can solve this issue using this link:-
Dealing with large files in ASP.NET Web API | StrathWeb. A free flowing web tech monologue.[^]

<configuration>
    <system.web>
        <!-- This will handle requests up to 1024MB (1GB) -->
        <httpRuntime maxRequestLength="1048576" timeout="3600" />
    </system.web>
</configuration>

<!-- IIS Specific Targeting (noted by the system.webServer section) -->
<system.webServer>
   <security>
      <requestFiltering>
         <!-- This will handle requests up to 1024MB (1GB) -->
         <requestLimits maxAllowedContentLength="1048576000" />
      </requestFiltering>
   </security>
 </system.webServer>

Google[^]

这篇关于如何在ASP.NET MVC中上传1gb文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！