如何在asp.net中上传，保存和获取图像？ [英] how to upload , save and fetch image in asp.net ?

问题描述

我希望图片上传，保存并从数据库中获取

plz帮助我

解决方案

http://www.aspdotnet-suresh.com/2011/01/how- to-insert-images-into-database-and.html [ ^ ]

[ ^ ]

使用Microsoft从SQL Server存储和检索图像。 NET [ ^ ]

HTTP：//www.c-sharpcorner .com / uploadfile / gowth / save-and-retrieve-image-from-sql-2005-in-Asp-Net / [ ^ ]



-KR

asp.net：

添加文件上传器>在代码后面保存btn点击事件

if（fileuploadimages.hasfile）

{

  string  filename = Path.GetFileName（fileuploadimages.PostedFile.FileName）; 
  //  将图像保存到Images文件夹 
 fileuploadimages.SaveAs（Server.MapPath （  Images / + filename））; 

//创建一个文件夹在您的项目中命名图像





/ *用于将图像插入数据库的代码

* / create connection字符串并在这里打开

SqlCommand cmd = new SqlCommand（插入图像（ImageName，ImagePath）值（@ ImageName，@ ImagePath），con）;

//传递参数进行查询

cmd.Parameters.AddWithValue（@ ImageName，filename）;

cmd.Parameters.AddWithValue（@ ImagePath，Images /+ filename）;

cmd.ExecuteNonQuery（）;



}





显示图像代码

----------------

 <   asp：GridView     runat   = < span class =code-keyword> server    ID   =  gvImages    AutoGenerateColumns   =  false    DataSourceID   =  sqldataImages    CssClass   =  Gridview    HeaderStyle-BackColor   = ＃61A6F8   >  
 <  列 >  
 <   asp：BoundField     DataField   =  ID    HeaderText   =  ID   < span class =code-keyword> /  >  
 <   asp：BoundField     DataField   =  ImageName    HeaderText   = 图片名称    /  >  
 < span class =code-keyword><   asp：ImageField     HeaderText   = 图片    DataImageUrlField   =  ImagePath     /  >  
 <   /列 >  
 <   / asp：GridView  >  
 <   asp ：SqlDataSource     ID   =  sqldataImages    runat   =  server      ConnectionString   =  <％ 

ConnectionStrings：dbconnection ％>

SelectCommand = 从图像中选择* >
< / asp：SqlDataSource >

i want image upload ,save and fetch from database
plz help me

解决方案

http://www.aspdotnet-suresh.com/2011/01/how-to-insert-images-into-database-and.html[^]
Save and Retrieve Image from a SQL Server Database using VB.NET[^]
Storing and Retrieving Images from SQL Server using Microsoft .NET[^]
http://www.c-sharpcorner.com/uploadfile/gowth/save-and-retrieve-image-from-sql-2005-in-Asp-Net/[^]

-KR

asp.net :
add a file uploader > in code behind save btn click event
if (fileuploadimages.hasfile)
{

string filename = Path.GetFileName(fileuploadimages.PostedFile.FileName);
//Save images into Images folder
fileuploadimages.SaveAs(Server.MapPath("Images/"+filename));

// create a folder in your project named images


/*code for insert the image into DB
*/ create connection string and open here
SqlCommand cmd = new SqlCommand("Insert into Images(ImageName,ImagePath) values(@ImageName,@ImagePath)", con);
//Passing parameters to query
cmd.Parameters.AddWithValue("@ImageName", filename);
cmd.Parameters.AddWithValue("@ImagePath", "Images/" + filename);
cmd.ExecuteNonQuery();

}


code for display image
----------------

<asp:GridView runat="server" ID="gvImages" AutoGenerateColumns="false" DataSourceID="sqldataImages" CssClass="Gridview" HeaderStyle-BackColor="#61A6F8" >
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" />
<asp:BoundField DataField="ImageName" HeaderText="Image Name" />
<asp:ImageField HeaderText="Image" DataImageUrlField="ImagePath" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="sqldataImages" runat="server"  ConnectionString="<%

ConnectionStrings:dbconnection %>" SelectCommand="select * from Images" > </asp:SqlDataSource>

这篇关于如何在asp.net中上传，保存和获取图像？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！