Question

asp 上传 视频代码，要求简洁 规范，分多多滴

[
能够上传最大为10M的视频文件(flv格式)，其文件上传到指定文件夹，其文件名字要保存到数据库，最好有列子，有注释，不贴代码可以，请发送邮箱macore#163.com["#"替换为"@"],先回答，后给分，我办事，您放心……
]

Answer 1

/// <summary> /// 上传文件到服务器 /// </summary> protected void ButtonAdd_Click(object sender, EventArgs e) { string Userid = Session["num"].ToString(); string Homeworkname; string Type; int Size; string Date; string Url; if (FULHomeWork.PostedFile.FileName != "") { string[] filename = FULHomeWork.PostedFile.FileName.Split('.'); Homeworkname = filename[0].Substring(filename[0].LastIndexOf("\\")+1); Type = filename[1]; Size = FULHomeWork.PostedFile.ContentLength; Date = System.DateTime.Now.ToShortDateString(); string uppath = @"UpLoadFiles\" + Userid; Url = uppath.Replace(@"\", "/") + "/" + Homeworkname + '.' + Type; try { if (!System.IO.Directory.Exists(Server.MapPath(uppath))) { System.IO.Directory.CreateDirectory(Server.MapPath(uppath)); } string strUrl = Server.MapPath(uppath + @"\" + this.FULHomeWork.FileName); FULHomeWork.SaveAs(strUrl); Mssql sql = new Mssql(); string str = "insert into HomeWork (UserID,CourseName,CourseCount,HomeWorkName,Type,Size,Date,Remark,Url) values('" + Userid + "','" + DDLCourse.SelectedValue + "','" + DDLCount.SelectedValue + "','" + Homeworkname + "','" + Type + "','" + Size + "','" + Date + "','"+TBRemark.Text+"','" + Url + "')"; sql.ExecuteNoReturn(str); Response.Write("<script language=\"javascript\"> window.alert(\"" + Homeworkname + '.' + Type + " 作业添加成功！" + "\");window.location.href='AddHomeWork.aspx';</script>"); } catch { LabelMessage.Text = "文件上传失败！"; } } else { LabelMessage.Text = "请选择要上传的文件！"; } } public class Mssql { public SqlConnection myconn; /// <summary> /// 构造函数，并打开数据库 /// </summary> public Mssql() { myconn = new SqlConnection(connectionString()); myconn.Open(); } /// <summary> /// 返回数据库连接字符串 /// </summary> private string connectionString() { return ConfigurationManager.ConnectionStrings["ERCPConnectionString"].ConnectionString; } /// <summary> /// 根据传入sql查询语句，返回SqlDataReader类型对象。 /// </summary> public SqlDataReader GetResultAsDataReader(string strSql) { SqlCommand command = new SqlCommand(strSql, myconn); return command.ExecuteReader(); //SqlDataAdapter cm = command.ExecuteReader(); //return cm; } /// <summary> /// 根据传入sql插入、更新、删除语句完成数据库的操作。 /// </summary> public void ExecuteNoReturn(string strSql) { SqlCommand myCommand = new SqlCommand(strSql, myconn); try { myCommand.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } myCommand.Dispose(); myconn.Close(); } /// <summary> /// 关闭数据库连接。 /// </summary> public void killMe() { myconn.Close(); }} 这上在上传的文件中插入数据库代码----------------------------------------------------------------------------------- 也可以先获得播放器地址后,再插进去啊

Answer 2

说的全是废话！！ 答非所问