。。。-CSDN博客

本文链接：https://blog.csdn.net/zhangjie849798714/article/details/6974484

将数据库的内容一表格形式显示出来，并且是一个超链接，可以跳转页面

protected void Page_Load(object sender, EventArgs e)
    {
        string sql = "Select id,name from 新建";
        DataTable dt = SqlHelper.ExecuteTable(sql);
        WriteUser(dt);
    }

    private int nums = 0;
    private void WriteUser(DataTable dt)
    {
        Table table = new Table();
        TableRow row = new TableRow();
        TableCell cell = new TableCell();
        cell.Text = "id";

        cell = new TableCell();
        cell.Text = "name";
        row.Cells.Add(cell);
        table.Rows.Add(row);
        foreach (DataRow row1 in dt.Rows)
        {
            nums = nums + 1;
            row = new TableRow();
            cell = new TableCell();
            cell.Text = row1["id"].ToString();
            row.Cells.Add(cell);

            cell = new TableCell();
            HyperLink hl2 = new HyperLink();
            hl2.Text = row1["name"].ToString();
            hl2.NavigateUrl = "Default2.aspx";
            row.Cells.Add(cell);
            cell.Controls.Add(hl2);
            row.Cells.Add(cell);

row.Cells.Add(cell);
table.Rows.Add(row);

        }
        this.Panel1.Controls.Add(table);
    }