如何检索路径，在asp.net其保存在MySQL的链接？ [英] how to retrieve path as link in asp.net which is saved in mysql?

问题描述

我米储蓄图像，音频路径和视频文件的路径是在保存服务器文件夹中。现在，我想这条道路在C＃中的链接下载的目的。

有什么办法怎么办？

我不认为使用GridView控件显示的链接。

编辑： -

  ServerFileName = System.IO.Path.Combine（ServerSavePathI，ClientFileName）;
 字符串SERVERPATH =使用Server.Mappath（ServerFileName）;
 FileUpload1.SaveAs（SERVERPATH）;
 dbInsert（图像，文件名，fileExt，SERVERPATH）;
 // dbinsert值存储数据库。并在数据库中它显示就像路径
 //c:InetpubwwwRootFileUploadingpenguin.jpg，尚未出现
 //'\\\\'，虽然我已经使用的数据类型为varchar
 

编辑： -

 保护无效dbInsert（字符串的fileType，字符串文件名，字符串fileExt，
      字符串文件路径）
{
    串getSQL1;
    getSQL1 =INSERT INTO tbluploadedfilesdetail（FileDownloaded，文件类型，
      文件名，FileExt，文件路径）VALUES（'假'，'+的fileType +，+
      文件名+，+ fileExt +，+文件路径+'）;;
    的MySqlConnection objMyCon1 =新的MySqlConnection（strProvider）;
    objMyCon1.Open（）;
    MySqlCommand的CMD1 =新的MySqlCommand（getSQL1，objMyCon1）;
    cmd1.ExecuteNonQuery（）;
    objMyCon1.Close（）;
    dbLoad（）;
}
 

解决方案

<击>一般来说，如果你有文件夹的图像站点的根目录下名为图片并您保存路径名为图像 image1.jpg 为图片/ image1.jpg 您可以链接如下：
VAR路径=图像/ image1.jpg; //你从数据库得到这个
VAR链接= Page.ResolveUrl（〜/+路径）; //给/images/image1.jpg
〜/ 指定的路径相对于你的网站的根目录下。

通常我保存的物理路径，并分别虚拟路径。此外，你可以很容易地从虚拟路径物理路径。你应该保存文件上传/ ingpenguin.jpg 仅可以轻松地获得物理路径如下：

  VAR根=使用Server.Mappath（/）; //路径的根文件夹
//将返回完整路径
VAR的ImagePath =使用Server.Mappath（文件上传/ inpenguin.jpg）;
 

有关更多的信息了，你可以参考 4guysfromrolla

I m saving path of images, audio and video files that path is of folder saved at server. Now I want that path as link in c# for the purpose of download.

Is there any way how to do that?

I'm not suppose to use gridview to show link.

EDIT:-

 ServerFileName = System.IO.Path.Combine(ServerSavePathI, ClientFileName); 
 string serverPath=Server.MapPath(ServerFileName); 
 FileUpload1.SaveAs(serverPath); 
 dbInsert("Image",fileName,fileExt,serverPath); 
 //dbinsert stores values to database. and in database it is showing path just as
 //c:InetpubwwwRootFileUploadingpenguin.jpg and not showing 
 //'\\' though i have used datatype varchar

EDIT:-

protected void dbInsert(string fileType,string fileName,string fileExt,
      string filePath) 
{ 
    string getSQL1; 
    getSQL1 = "INSERT into tbluploadedfilesdetail (FileDownloaded,FileType, 
      FileName,FileExt,FilePath) VALUES ('false','" + fileType + "','" + 
      fileName + "','" + fileExt + "','"+filePath+"');"; 
    MySqlConnection objMyCon1 = new MySqlConnection(strProvider); 
    objMyCon1.Open(); 
    MySqlCommand cmd1 = new MySqlCommand(getSQL1, objMyCon1); 
    cmd1.ExecuteNonQuery(); 
    objMyCon1.Close(); 
    dbLoad(); 
} 

解决方案

Normally if you have images in folder named images under root folder of your site and you save path for an image named image1.jpg as images/image1.jpg you can get link as follows: var path="images/image1.jpg";//you get this from db var link=Page.ResolveUrl("~/"+path);//gives /images/image1.jpg ~/ specified path relative to root folder of your site.

Normally I save the physical path and virtual path separately. Moreover you can get physical path from virtual path easily. You should save FileUpload/ingpenguin.jpg only and can get physical path easily as follows:

var root = Server.MapPath("/");//path to the root folder
// will return full path 
var imagePath = Server.MapPath("FileUpload/inpenguin.jpg");

For more informaiton you can refer to 4guysfromrolla

这篇关于如何检索路径，在asp.net其保存在MySQL的链接？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！