把数据库以路经形式保存到数据库并读取显示

1.前台代码 <form id="form1" runat="server"> <div> <asp:FileUpload ID="FileUpload1" runat="server" /> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="上传" />  <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="查看" /> <asp:Image ID="Image1" runat="server" Height="264px" Width="419px" /> <asp:Label ID="Label1" runat="server" Text="Label" Width="127px"></asp:Label> <asp:TextBox ID="TextBox1" runat="server" OnTextChanged="TextBox1_TextChanged"></asp:TextBox></div> 后台代码using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.IO;using System.Data.SqlClient;using System.Web.Configuration;public partial class login : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { string name = FileUpload1.FileName; //获取文件名 string type = name.Substring(name.LastIndexOf(".") + 1); //获取文件类型 string ipath = Server.MapPath("upimage") + "//" + name; //获取文件路径 string wpath = "upimage//" + name; //[color=red]设置文件保存相对路径(这里的路径起始就是我们存放图片的文件夹名)[/color] string S601_sql = "insert into [Image] (imagepath)values('" + wpath + "')"; //连接数据库字符串 string S601_dns = WebConfigurationManager.ConnectionStrings["S601ConnectionString"].ToString(); //创建连接对象 SqlConnection S601_myConn = new SqlConnection(S601_dns); //创建数据源执行命令 SqlCommand cmd = new SqlCommand(S601_sql, S601_myConn); if (type == "jpg" || type == "gif" || type == "bmp" || type == "png") { //打开连接对象 S601_myConn.Open(); FileUpload1.SaveAs(ipath);//服务器保存路径 cmd.ExecuteNonQuery(); S601_myConn.Close(); } } protected void Button2_Click(object sender, EventArgs e) { //连接数据库字符串 string S601_dns = WebConfigurationManager.ConnectionStrings["S601ConnectionString"].ToString(); //创建连接对象 SqlConnection S601_myConn = new SqlConnection(S601_dns); //创建数据源执行命令 string query2 = "select * from Image where iid=" + Convert.ToInt32(TextBox1.Text); S601_myConn.Open(); //创建数据源执行命令 SqlCommand cmd = new SqlCommand(query2,S601_myConn); //创建数据源执行命令 SqlDataReader sdr = cmd.ExecuteReader(); string wpath2 = ""; while (sdr.Read()) { wpath2 = sdr[1].ToString(); //获得相对路径 } S601_myConn.Close(); Image1.ImageUrl = wpath2; //图片显示路径就是相对路径 Label1.Text = wpath2; //显示相对路径 } protected void TextBox1_TextChanged(object sender, EventArgs e) { }}