效果：
思路：
首先，獲取圖片物理地址，然后進行判斷將圖片保存到文件夾下，再將圖片的信息保存到數據庫。
數據庫：
復制代碼 代碼如下:
create table image1
(
ID int identity(1,1) primary key,
ImageName varchar(100) ,
ImageType varchar(20),
ImagePath varchar(200)
)
代碼：
復制代碼 代碼如下:
<body>
<form runat="server">
<div>
<table>
<tr>
<td colspan="2">
</td>
</tr>
<tr>
<td>
<asp:FileUpload runat="server" />
<asp:Label runat="server" ForeColor="Red"></asp:Label>
</td>
<td>
<asp:Button runat="server" Text="上傳圖片" />
</td>
</tr>
<tr>
<td colspan="2">
<br />
<br />
<asp:Image runat="server" />
</td>
</tr>
</table>
</div>
</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 + "http://" + name);//保存路徑
this.Image1.Visible = true;
this.Image1.ImageUrl = "~//excel" + "http://" + 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);
}
}
}
}
新聞熱點
疑難解答
圖片精選
