日本高清在线精品一区二区三区,99爱视频在线观看,国产日韩欧美在线观看

效果：

C#實現(xiàn)上傳照片到物理路徑，并且將地址保存到數(shù)據(jù)庫的小例子

思路：

首先，獲取圖片物理地址，然后進行判斷將圖片保存到文件夾下，再將圖片的信息保存到數(shù)據(jù)庫。

數(shù)據(jù)庫：

復(fù)制代碼代碼如下:

	
	create table image1

	(

	ID int identity(1,1) primary key,

	ImageName varchar(100) ,

	ImageType varchar(20),

	ImagePath varchar(200)

	)

代碼：

復(fù)制代碼代碼如下:

	
	<body>

	    <form id="form1" runat="server">

	    <div>

	        <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>

	    </div>

	    </form>

	</body>

復(fù)制代碼代碼如下:

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);
            }
        }
    }
}