大哥些救命啊,头都想痛了~~为什么会少图片啊?ORACLE数据库~
cs920 2004-11-05 04:54:37 代码如下:
img.aspx :
<asp:datalist id="DataList1" runat="server" Width="778" RepeatColumns="1" ShowHeader="False" ShowFooter="False">
<ItemTemplate>
<FONT face="宋体">
<IMG src='<%#"ImageShow.aspx?ImageID="+DataBinder.Eval(Container.DataItem , "ID")%>'>
<%#DataBinder.Eval(Container.DataItem , "MEMO")%>
</FONT>
</ItemTemplate>
<AlternatingItemTemplate>
<FONT face="宋体"></FONT>
</AlternatingItemTemplate>
</asp:datalist>
///////只有一张图片时正常显示,如果多了的话就不规则乱显示,郁闷,我用的是ORACLE数据库。
img.aspx.cs:
string Body_ID = Request ["ID"];
DataTable newdat = BodyQuery("picture","*",Body_ID);
int n = newdat.Rows .Count ;//大家注意,此处"N"的数值正常。为要显示的图片数
DataList1.DataSource = newdat ;
DataList1.DataBind ();
public DataTable BodyQuery( string tableName , string strKey ,string info_ID)
{ OracleDataReader infocenter;
string ConnStr = ConfigurationSettings.AppSettings["oracleconn"];
string SelectStr = "SELECT " + strKey + " FROM " + tableName + " WHERE INFOID = "+info_ID +"ORDER BY ID DESC";
OracleConnection oracon = new OracleConnection (ConnStr);
oracon.Open ();
OracleCommand infocmd = new OracleCommand(SelectStr,oracon);
infocenter = infocmd.ExecuteReader();
DataTable tmpdat = HandleBase.FillData( infocenter);
infocenter.Close ();
oracon.Close ();
return tmpdat;
}