sql語句沒錯 我测试有一条数据 但是调试发现dt.Rows.Count是等于0 不执行循环了 怎么回事???
protected void dlBig_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Label lblMen = e.Item.FindControl("lblMeaning") as Label;
Label lblTable = e.Item.FindControl("lblDataList") as Label;
string sql = "select content_id,content_title from mdsets_main_content where content_type='" + lblMen.Text + "'";
DataTable dt = new DataTable();
dt = OracleHelper.getDB(sql);
lblTable.Text = "<ul style='width:100%;' id='mst'>";
for (int i = 0; i < dt.Rows.Count; i++)
{
lblTable.Text += "<li><span>" + dt.Rows[i][0] + "</span><a href='javascript:void(0)' target='_blank'>" + dt.Rows[i][1] + "</a></li>";
}
lblTable.Text += "</ul>";
}
}
不是for (int i = 0; i < dt.Rows.Count; i++)
试下
另外:
dt.Rows[i][0] 这样的后面加上dt.Rows[i][0].ToString()
是否得到数据
调试看下dt的count,
还有就是row是从0计算