在asp.net中上传视频文件怎样插入数据库的代码

/// <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();

        }

}