二进制流上传

[c#]代码库

        public static string ImgUpdata(string TableName, Byte[] FileByteArray, string FILENAME, string FileID)
        {
            string Sql = "Update " + TableName + " set IMGFILE=@UpFile ,FILENAME=@FILENAME where FileID='" + FileID + "'";
            SqlConnection myCn = new SqlConnection(ConnectionString);
            SqlCommand myCmd = new SqlCommand(Sql, myCn);
            myCmd.Parameters.Add("@UpFile", SqlDbType.Image, FileByteArray.Length);
            myCmd.Parameters.Add("@FILENAME", SqlDbType.VarChar);
            myCmd.Parameters["@FILENAME"].Value = FILENAME;
            myCmd.Parameters["@UpFile"].Value = FileByteArray;
            myCn.Open();
            myCmd.ExecuteNonQuery();
            myCn.Close();
            return FileID;
        }