如何显示我在数据库中上传的pdf和doc文件的缩略图. [英] How do I display thumbnail of pdf and doc file which I have uploaded in database.

问题描述

您好，我遇到的情况是我正在数据库中上载每种类型的文件，并在视图中显示相关的图标，但是我想在显示图像文件的图像时显示每个文件的缩略图.

请建议我如何显示doc，pdf，xlsx或任何文件格式的缩略图.

我尝试过的事情:

这是我用来上传每个文件的方法.

Hi, I have a situation where i am uploading every type of file in the database and displaying related icons in the view, But i want to display Thumbnail of each file as i am displaying the image for the image file.

please suggest me how I''ll show a thumbnail for doc, pdf, xlsx, or any file format.

What I have tried:

Here is method which i am using to upload every file.

[HttpPost]
        public ActionResult UploadResources(HttpPostedFileBase[] files)
        {
            if (ModelState.IsValid && Request.Form["SelectedSubCategoryId"] != null && Request.Form["SelectedCategoryId"] != null)
            {
                string result = string.Empty;
                if (files != null && files.Length > 0 && files[0] !=null )
                {
                    string[] results = new string[files.Length];
                    int i = 0;
                    foreach (HttpPostedFileBase file in files)
                    {
                        string ext = string.Empty;
                        string fileName = file.FileName;
                        int fileExtPos = fileName.LastIndexOf(".");
                        if (fileExtPos >= 0)
                            ext = fileName.Substring(fileExtPos, (fileName.Length - fileExtPos));

                        results[i] = dat.UploadResources(Convert.ToInt32(Request.Form["SelectedCategoryId"]), Convert.ToInt32(Request.Form["SelectedSubCategoryId"]), Convert.ToString(Request.Form["Description"]), WebSecurity.CurrentUserId, Convert.ToBoolean(Request.Form["IsDisplay"]), Convert.ToString(Request.Form["YoutubeURL"]), file.FileName, ext, file.InputStream);
                        i++;
                    }
                    if (results.Any(m => m == "1"))
                    {
                        string Upfilenames = string.Empty;
                        string Npfilenames = string.Empty;
                        int m = 0;
                        foreach (string s in results)
                        {
                            if (s == "1")
                            {
                                Upfilenames += files[m].FileName + ",";
                            }
                            else
                            {
                                Npfilenames += files[m].FileName + ",";
                            }
                            m++;
                        }
                       TempData["Message"] = "Success:" + Upfilenames + "were uploaded.";
                    }
                    if (results.Any(m => m == "-2"))
                    {
                        TempData["Message"] = "Danger: File not uploaded, Please try again.";
                    }
                    //else
                    //{
                    //    TempData["Message"] = "Success: All files were uploaded.";
                    //}
                }
                else if (Request.Form["YoutubeURL"] != null)
                {
                    result = dat.UploadResources(Convert.ToInt32(Request.Form["SelectedCategoryId"]), Convert.ToInt32(Request.Form["SelectedSubCategoryId"]), Convert.ToString(Request.Form["Description"]), WebSecurity.CurrentUserId, Convert.ToBoolean(Request.Form["IsDisplay"]), Convert.ToString(Request.Form["YoutubeURL"]), null, null, null);
                    if (result == "1")
                    {
                        TempData["Message"] = "Success: Resource uploaded.";
                    }

                    else if (result == "-2")
                    {
                        TempData["Message"] = "Danger: Resource not uploaded, Please try again.";
                    }
                }
                
            }
            return RedirectToAction("UploadResources");
        }

和

and

#region UploadResources

       public string UploadResources(int CategoryId, int SubCategoryId, string Description, int AdminId,bool IsDisplay ,string YoutubeURL = null,string FileName = null, string fileExt = null, Stream Media = null)
       {
           string RetValue = string.Empty;

           string ProcedureName =string.Empty;
           string ReturnValue = string.Empty;
           string regex = "^(?:https?\\:\\/\\/)?(?:www\\.)?(?:youtu\\.be\\/|youtube\\.com\\/(?:embed\\/|v\\/|watch\\?v\\=))([\\w-]{10,12})(?:$|\\&|\\?\\#).*";
           string YoutubeID = string.Empty;
           if(YoutubeURL != null)
           {
               YoutubeID = new Regex(regex).Match(YoutubeURL).Groups[1].Value;
           }
           ProcedureName = "BP_UPLOAD_RESOURCE";
           using (con = new SqlConnection(constrBrandpier))
           {
               try
               {
                   con.Open();
                   SqlCommand cmd = new SqlCommand(ProcedureName, con);
                   cmd.CommandType = CommandType.StoredProcedure;

                   cmd.Parameters.AddWithValue("@CATEGORY_ID", CategoryId);
                   cmd.Parameters.AddWithValue("@SUB_CATEGORY_ID", SubCategoryId);
                   cmd.Parameters.AddWithValue("@FILENAME", FileName);
                   cmd.Parameters.AddWithValue("@FILEEXT", fileExt);
                   cmd.Parameters.AddWithValue("@DESCRIPTION", Description);
                   cmd.Parameters.AddWithValue("@ADMINID", AdminId);
                   cmd.Parameters.AddWithValue("@YOUTUBE_URL", YoutubeURL);
                   cmd.Parameters.AddWithValue("@YOUTUBE_ID", YoutubeID);
                   cmd.Parameters.Add(new SqlParameter("@ISDISPLAY", SqlDbType.Char)).Value = IsDisplay ? ''1'' : ''0'';

                   SqlParameter IMAGEID = new SqlParameter();
                   IMAGEID = cmd.Parameters.Add("@IMAGEID", SqlDbType.NVarChar, 300);
                   IMAGEID.Direction = ParameterDirection.Output;

                   SqlParameter intReturn = new SqlParameter();
                   intReturn = cmd.Parameters.Add("@INTRETURN", SqlDbType.Int);
                   intReturn.Direction = ParameterDirection.Output;

                   cmd.ExecuteScalar();
                   RetValue = intReturn.Value.ToString();

                   if (intReturn.Value.ToString() == "1" && FileName != null)
                   {
                       string _bucketpath = ConfigurationManager.AppSettings["bucketName"].ToString() + ConfigurationManager.AppSettings["ResourcebucketName"].ToString() + CategoryId.ToString() + "/" + SubCategoryId.ToString();
                       BWS.AWS.S3 s3 = new BWS.AWS.S3();
                       string _returns3 = s3.UploadFile(_bucketpath, IMAGEID.Value.ToString(), ReadFully(Media));
                   }
               }
               catch (Exception ex)
               {
                   RetValue = ex.Message.ToString();
               }
           }
           return RetValue;

       }

推荐答案

| \\& | \\?\\#).*; 字符串YoutubeID = string.Empty; if(YoutubeURL！= null) { YoutubeID =新的Regex(regex).Match(YoutubeURL).Groups [1] .Value; } ProcedureName ="BP_UPLOAD_RESOURCE"; 使用(con = new SqlConnection(constrBrandpier)) { 尝试 { con.Open(); SqlCommand cmd =新的SqlCommand(ProcedureName，con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ CATEGORY_ID"，CategoryId); cmd.Parameters.AddWithValue("@ SUB_CATEGORY_ID"，SubCategoryId); cmd.Parameters.AddWithValue("@ FILENAME"，FileName); cmd.Parameters.AddWithValue("@ FILEEXT"，fileExt); cmd.Parameters.AddWithValue("@ DESCRIPTION"，Description); cmd.Parameters.AddWithValue("@ ADMINID"，AdminId); cmd.Parameters.AddWithValue("@ YOUTUBE_URL"，YoutubeURL); cmd.Parameters.AddWithValue("@ YOUTUBE_ID"，YoutubeID); cmd.Parameters.Add(新SqlParameter("@ ISDISPLAY"，SqlDbType.Char)).Value = IsDisplay吗? ``1'':``0''; SqlParameter IMAGEID =新的SqlParameter(); IMAGEID = cmd.Parameters.Add("@ IMAGEID"，SqlDbType.NVarChar，300); IMAGEID.Direction = ParameterDirection.Output; SqlParameter intReturn =新的SqlParameter(); intReturn = cmd.Parameters.Add("@ INTRETURN"，SqlDbType.Int); intReturn.Direction = ParameterDirection.Output; cmd.ExecuteScalar(); RetValue = intReturn.Value.ToString(); 如果(intReturn.Value.ToString()=="1"&& FileName！= null) { 字符串_bucketpath = ConfigurationManager.AppSettings ["bucketName"].ToString()+ ConfigurationManager.AppSettings ["ResourcebucketName"].ToString()+ CategoryId.ToString()+"/" + SubCategoryId.ToString(); BWS.AWS.S3 s3 =新的BWS.AWS.S3(); 字符串_returns3 = s3.UploadFile(_bucketpath，IMAGEID.Value.ToString()，ReadFully(Media)); } } 抓住(前例外) { RetValue = ex.Message.ToString(); } } 返回RetValue; }

|\\&|\\?\\#).*"; string YoutubeID = string.Empty; if(YoutubeURL != null) { YoutubeID = new Regex(regex).Match(YoutubeURL).Groups[1].Value; } ProcedureName = "BP_UPLOAD_RESOURCE"; using (con = new SqlConnection(constrBrandpier)) { try { con.Open(); SqlCommand cmd = new SqlCommand(ProcedureName, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CATEGORY_ID", CategoryId); cmd.Parameters.AddWithValue("@SUB_CATEGORY_ID", SubCategoryId); cmd.Parameters.AddWithValue("@FILENAME", FileName); cmd.Parameters.AddWithValue("@FILEEXT", fileExt); cmd.Parameters.AddWithValue("@DESCRIPTION", Description); cmd.Parameters.AddWithValue("@ADMINID", AdminId); cmd.Parameters.AddWithValue("@YOUTUBE_URL", YoutubeURL); cmd.Parameters.AddWithValue("@YOUTUBE_ID", YoutubeID); cmd.Parameters.Add(new SqlParameter("@ISDISPLAY", SqlDbType.Char)).Value = IsDisplay ? ''1'' : ''0''; SqlParameter IMAGEID = new SqlParameter(); IMAGEID = cmd.Parameters.Add("@IMAGEID", SqlDbType.NVarChar, 300); IMAGEID.Direction = ParameterDirection.Output; SqlParameter intReturn = new SqlParameter(); intReturn = cmd.Parameters.Add("@INTRETURN", SqlDbType.Int); intReturn.Direction = ParameterDirection.Output; cmd.ExecuteScalar(); RetValue = intReturn.Value.ToString(); if (intReturn.Value.ToString() == "1" && FileName != null) { string _bucketpath = ConfigurationManager.AppSettings["bucketName"].ToString() + ConfigurationManager.AppSettings["ResourcebucketName"].ToString() + CategoryId.ToString() + "/" + SubCategoryId.ToString(); BWS.AWS.S3 s3 = new BWS.AWS.S3(); string _returns3 = s3.UploadFile(_bucketpath, IMAGEID.Value.ToString(), ReadFully(Media)); } } catch (Exception ex) { RetValue = ex.Message.ToString(); } } return RetValue; }

这篇关于如何显示我在数据库中上传的pdf和doc文件的缩略图.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！