string strSQL1, strSQL2,strSQL3;
strSQL1 = "SELECT id,oneid, twoid, threeid, sort, classname FROM nts_InfoClass WHERE (twoid = 0) AND (threeid = 0) order by sort";
strSQL2 = "SELECT id,oneid, twoid, threeid, sort, classname FROM nts_InfoClass WHERE (twoid <> 0) AND (threeid = 0) order by sort";
strSQL3 ="SELECT id, title, class_oneid, postdate FROM nts_infodata A ";
strSQL3 += "WHERE id IN (SELECT TOP 3 id FROM nts_infodata WHERE class_oneid = A.class_oneid and state=1 and checked=1" + DataClass.GetSession("areawhere");
strSQL3 += " ORDER BY postdate DESC) ORDER BY class_oneid, postdate DESC";
strSQL = strSQL1 + ";" + strSQL2+";"+strSQL3;
DataSet ds = DataClass.GetDataSet(strSQL);
ds.Relations.Add("myrelation", ds.Tables[0].Columns["oneid"], ds.Tables[1].Columns["oneid"]);
ds.Relations.Add("myrelation1", ds.Tables[0].Columns["oneid"], ds.Tables[2].Columns["class_oneid"]);
Dlt_Class.DataSource = ds.Tables[0];
Dlt_Class.DataBind();
我想提取分类信息的前面五条信息
有一个这样的问题:
如果我连续在同一级二级分类下发表 界面先显示大于五条信息。请问如何修改!