net上传图片(取一张最新图片)

来源:互联网 发布:日本老龄化 知乎 编辑:程序博客网 时间:2024/05/18 00:07
<form id="form1" runat="server">    <div>        &nbsp;<asp:DataList ID="DataList1" runat="server">            <ItemTemplate>                &nbsp;<img src="upimg/<%# DataBinder.Eval(Container.DataItem,"pic_name") %>" />            </ItemTemplate>        </asp:DataList></div>    </form>
 

//创建连接数据库字符串        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 top 1 [id],[pic_name],[introduced] from pic order by id DESC", oleConnection);            OleDbDataAdapter dpt = new OleDbDataAdapter(cmd);            DataSet ds = new DataSet();

            dpt.Fill(ds);            DataList1.DataSource = ds;            DataList1.DataBind();            OleDbDataReader dr = cmd.ExecuteReader();            if (dr.Read())                          Label1.Text = dr["introduced"].ToString();                        finally                  //关闭数据库            oleConnection.Close();        }