protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e) { object cid; cid = DataBinder.Eval(e.Item.DataItem, "id"); Repeater Repeater2; Repeater2 = (Repeater)e.Item.FindControl("Repeater2"); string sqlnews = "select top 4 id,title,infotime,hits from news where BigClassID='" + int.Parse(cid.ToString()) + "' and flag='已审核' order by cindex"; DataSet ds1 = db.ReturnDataSet(sqlnews); Repeater2.DataSource = ds1.Tables[0].DefaultView; Repeater2.DataBind(); }
/// <summary> /// 执行SQL语句,返回admin表格里的数据集合 /// </summary> /// <returns>DataSet数据集合</returns> public DataSet GetDataAdmin() { string strSQL = "select * from admin"; return(db.ReturnDataSet(strSQL)); }
/// <summary> /// 执行SQL语句,返回整个表里的数据集合 /// </summary> /// <returns>返回DataSet</returns> public DataSet GetData_BigClass() { string strSQL = "select * from BigClass"; return(db.ReturnDataSet(strSQL)); }
/// <summary> /// 获取全部新闻评论 /// </summary> /// <returns>DataSet数据集</returns> public DataSet GetAllAnswer() { string strSQL = "select * from answer"; return(db.ReturnDataSet(strSQL)); }
/// <summary> /// 获取现有新闻ID /// </summary> /// <returns>DataSet数据集</returns> public DataSet GetNewsID() { string strSQL = "select id from news where flag='已审核'"; return(db.ReturnDataSet(strSQL)); }