C#實現上傳照片到實體路徑，並且將地址儲存到資料庫的小例子

最後更新：2018-05-12 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

C#實現上傳照片到實體路徑，並且將地址儲存到資料庫的小例子

效果：

思路：
首先，擷取圖片物理地址，然後進行判斷將圖片儲存到檔案夾下，再將圖片的資訊儲存到資料庫。
資料庫：

create table image1  (  ID int identity(1,1) primary key,  ImageName varchar(100) ,  ImageType varchar(20),  ImagePath varchar(200)  )

代碼：

<body>      <form id="form1" runat="server">      <p>          <table>              <tr>                  <td colspan="2" style="height: 21px">                                         </td>              </tr>              <tr>                  <td style="width: 400px">                      <asp:FileUpload ID="FileUpload1" runat="server" />                       <asp:Label ID="label1" runat="server" ForeColor="Red"></asp:Label>                  </td>                  <td style="width: 80px">                      <asp:Button ID="UploadButton" runat="server" Text="上傳圖片" OnClick="UploadButton_Click" />                  </td>              </tr>              <tr>                  <td colspan="2" align="center">                      <br />                      <br />                      <asp:Image ID="Image1" runat="server" Height="118px" Width="131px" />                  </td>              </tr>          </table>      </p>      </form>  </body>

using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.IO;using System.Configuration;using System.Data;using System.Data.SqlClient;namespace InExcelOutExcel{    public partial class UpWord : System.Web.UI.Page    {        protected void Page_Load(object sender, EventArgs e)        {        }        string SQLString = ConfigurationManager.ConnectionStrings["ConnectionStr"].ToString();        protected void UploadButton_Click(object sender, EventArgs e)        {            try            {                using (SqlConnection sqlcon = new SqlConnection(SQLString))                {                    string FullName = FileUpload1.PostedFile.FileName;//擷取圖片物理地址                    FileInfo fi = new FileInfo(FullName);                    string name = fi.Name;//擷取圖片名稱                    string type = fi.Extension;//擷取圖片類型                    if (type == ".jpg" || type == ".gif" || type == ".bmp" || type == ".png")                    {                        string SavePath = Server.MapPath("~\\excel");//圖片儲存到檔案夾下                        this.FileUpload1.PostedFile.SaveAs(SavePath + "\\" + name);//儲存路徑                        this.Image1.Visible = true;                        this.Image1.ImageUrl = "~\\excel" + "\\" + name;//介面顯示圖片                        string sql = "insert into image1(ImageName,ImageType,ImagePath) values('" + name + "','" + type + "','~\\excel" + name + "')";                        SqlCommand cmd = new SqlCommand(sql, sqlcon);                        sqlcon.Open();                        cmd.ExecuteNonQuery();                        this.label1.Text = "上傳成功";                    }                    else                    {                        this.label1.Text = "請選擇正確的格式圖片";                    }                }            }            catch (Exception ex)            {                Response.Write(ex.Message);            }        }    }}

以上就是C#實現上傳照片到實體路徑，並且將地址儲存到資料庫的小例子的內容，更多相關內容請關注topic.alibabacloud.com（www.php.cn）！



本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More