结果:
思绪:
起首,猎取图片物理地点,然后举行推断将图片保留到文件夹下,再将图片的信息保留到数据库。
数据库:
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#完成上传照片到物理途径,而且将地点保留到数据库的小例子的内容,更多相关内容请关注ki4网(www.ki4.cn)!