数据库读取数据问题(DataList控件)

来源:百度知道 编辑:UC知道 时间:2024/06/15 14:40:47
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionString["connstr"].ConnectionString;
conn.Open();
string str = "SELECT * FROM ReList WHERE RePostID = " + Request.QueryString["pid"] + "";
OleDbCommand cmd = new OleDbCommand(str, conn);
OleDbDataAdapter da = new OleDbDataAdapter(str, conn);//
DataSet ds = new DataSet();//
da.Fill(ds);//
//对PagedDataSource 对象的相关属性赋值
PagedDataSource objPds = new PagedDataSource();
objPds.DataSource = ds.Tables[0].DefaultView;
objPds.AllowPaging = true;
objPds.PageSize = 50;
........(分页控制等等代码)........
DataListRe.DataSource = objPds;
DataListRe.DataBind();
.....................
现在我想在DataListRe中添加一个Asp:Image控件,但是如果数据库中image地址为空的话,就

<%# Evel("ImageURL").ToString() != "" ? ("<img src='" + Evel("ImageURL") + "'/>" ): "" %>

<asp:DataList ID="DataList1" runat="server">
<ItemTemplate>
<asp:Image ID="Image1" runat="server" ImageUrl='<%# Bind("ImgPath") %>' />
</ItemTemplate>
</asp:DataList>

模板列
<%# Evel("ImageURL") == DBNull.Value ? ("<img src='" + Evel("ImageURL") + "'/>" ): "" %>