protected void Page_Load(object sender, EventArgs e)
{
//文字显示
if (!IsPostBack)
{
string sql = "select * from T_ClassCatalogs";
DataTable dt = sqlhelp.Executedatatable(sql);
TableRow tr;
TableRow tr2;
TableCell td;
TableCell td2;
for (int i = 0; i < dt.Rows.Count; i++)
{
tr = new TableRow();
tr.Height = Unit.Pixel(20);
td = new TableCell();
td.Text = "<img src='img/tupian.PNG'>" + dt.Rows[i]["ClassCatalog"].ToString();
td.Style.Add(HtmlTextWriterStyle.Color, "black");
td.Style.Add(HtmlTextWriterStyle.FontSize, "17px");
td.Style.Add(HtmlTextWriterStyle.FontFamily, "楷体");
tr.Cells.Add(td);
Table1.Rows.Add(tr);//把课程读出来了
DataTable ds = sqlhelp.Executedatatable("select * from T_SubCatalogs whereSubId=@id", new SqlParameter("@id", dt.Rows[i]["ClassId"]));//把那些个子类读出来
for (int j = 0; j < ds.Rows.Count; j++)
{
tr2 = new TableRow();
td2 = new TableCell();
string navi = ds.Rows[j]["SubCatalog"].ToString();
td2.Text = "<a class='txtbt' href='" + navi + "?y=" + i.ToString() + "'>" + ds.Rows[j]["SubCatalog"].ToString();
td2.Style.Add(HtmlTextWriterStyle.Color, "blue");
td2.Style.Add(HtmlTextWriterStyle.FontSize, "16px");
td2.Style.Add(HtmlTextWriterStyle.FontFamily, "楷体");
tr2.Cells.Add(td2);
Table1.Rows.Add(tr2);
}
}
}
}
效果图: