12-13（显示csdn大本营那种的一个大标题下有好多的子类）从数据库读出来（如图）

来源：互联网发布：重复文件清理软件 mac 编辑：程序博客网时间：2024/05/21 17:54

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

效果图：