学步园

//取得上传文件的大小
            int FileLen = fileImg.PostedFile.ContentLength;

            Byte[] FileData = new Byte[FileLen];

            //创建访问客户端上传文件的对象
            HttpPostedFile hp = fileImg.PostedFile;

            //创建数据流对象
            Stream sr = hp.InputStream;

            //将图片数据放到FileData数组对象实例中，0代表数组指针的起始位置,FileLen代表指针的结束位置
            sr.Read(FileData, 0, FileLen);
            #endregion

            string sql = "INSERT INTO ptif(ptif_id,ptif_name,ptif_file,ptif_url,ptif_cont) VALUES(ZHIBAO.create_id.nextval,:ptif_name,:ptif_file,:ptif_url,:ptif_cont)";
            try
            {
                string fileURL = fileclass.getFileURLName();
                OracleParameter[] parms =
                {
                    //ptif_id ,ptif_name ,ptif_file ,ptif_url ,ptif_cont
                    //OracleHelper.MakeInParam(":ptif_id",OracleType.Char, Admin_id),
                    OracleHelper.MakeInParam(":ptif_name",OracleType.Char, name.Text),
                    OracleHelper.MakeInParam(":ptif_file",OracleType.Blob, FileData),
                    OracleHelper.MakeInParam(":ptif_url",OracleType.Char, fileURL),
                    OracleHelper.MakeInParam(":ptif_cont",OracleType.Char,TextBox1.Text)
                };
                OracleHelper.ExecuteNonQuery(OracleHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, parms);
                if (chkAddContinue.Checked)
                {
                    Response.Write("<script language='javascript'>alert('添加成功!');window.location.href='AddPicture.aspx';</script>");
                }
                else
                {
                    Response.Write("<script language='javascript'>alert('添加成功!');window.location.href='PictureLib.aspx';</script>");
                }
            }
            catch
            {
                Response.Write("error");
            }