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));
}
