Access数据库:在数据库建立一个pic(id设为主键[自动编号],)的表,(pic_name[备注])用于存储上传图片的名字.[此博客全部程序都通过windowds 2003和vs2005测试]
Upload.aspx
<form id="form1" method="post" enctype="multipart/form-data" runat="server">
<div>
<asp:FileUpload ID="FileUpload1" runat="server" /> <asp:Button ID="Button1"
runat="server" OnClick="Button1_Click" Text="Button" /><br />
<br />
<asp:Image ID="Image1" runat="server" /><br />
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label><br />
</div>
</form>
upload.cs
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string name = FileUpload1.FileName;//获取已上传的文件的名字
string size = FileUpload1.PostedFile.ContentLength.ToString();//获取已上传文件的大小
string type = FileUpload1.PostedFile.ContentType;//获取已上传文件mime内容类型
string type2 = name.Substring(name.LastIndexOf(".")+1);//得到文件的后缀名
string ipath = Server.MapPath("upimg") + "//" + name;//获取文件上传的实际路径
string fpath = Server.MapPath("upfile") + "//" + name;//获取文件上传的实际路径
string wpath = "upimg//" + name;//写到文件的虚拟路径
Image_show.aspx(用于显示上传以后图片的的页面)
<form id="form1" runat="server"> <div> <asp:DataList ID="DataList1" runat="server" Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" RepeatDirection="Horizontal"> <ItemTemplate> <a href="pro_show.aspx?id=<%# DataBinder.Eval(Container.DataItem,"id") %>"> <img border="0" src="admin/upimg/<%# DataBinder.Eval(Container.DataItem,"pic_name") %>" /> </a> </ItemTemplate> </asp:DataList></div> </form>
Image_show.aspx(cs)
protected void Page_Load(object sender, EventArgs e)
{
//创建连接数据库字符串
string conn = "provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath("App_Data/test.mdb");
OleDbConnection oleConnection = new OleDbConnection(conn);
try
{
//打开数据库连接
oleConnection.Open();
OleDbCommand cmd = new OleDbCommand("select * from pic", oleConnection);
OleDbDataAdapter dpt = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
dpt.Fill(ds);
DataList1.DataSource = ds;
DataList1.DataBind();
}
finally
{
//关闭数据库
oleConnection.Close();
}
}
pro_show.aspx(点击图片以后,显示图片以及文字介绍)
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server" Text="Label" Width="142px"></asp:Label><asp:DataList ID="DataList1" runat="server">
<ItemTemplate>
<img border="0" src="admin/upimg/<%# DataBinder.Eval(Container.DataItem,"pic_name") %>" />
</ItemTemplate>
</asp:DataList></div>
</form>
pro_show.cs
protected void Page_Load(object sender, EventArgs e)
{
string AuthorID = Request["id"].ToString();
//创建连接数据库字符串
string conn = "provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath("App_Data/test.mdb");
OleDbConnection oleConnection = new OleDbConnection(conn);