c# - 根据数据库表值创建标签或其他控件

Question

我想根据数据库列值创建标签或文本框..例如: 我有一个数据库表列值 Casual Leave、Medical Leave、Annual leave 等。我想为上面的列值创建动态标签和相应的文本框。

我想要这样的控件..

         Casual Leave :  Textbox1
         Medical Leave:  Textbox2
         Annul Leave  :  Textbox3
         etc based on table value

我做什么？我不能这样做。请帮助我...

Answer 1

试试这个

<asp:Panel Id="pnl" runat ="server">
    </asp:Panel>


Label lblT = null;
            TextBox txt = null;
            Table tb = new Table();
            pnl.Controls.Add(tb);
            DataTable table = DT_GeneratedOp();
            foreach (DataColumn dr in table.Columns)
            {
                TableRow tr = new TableRow();
                TableCell tc = new TableCell();
                TableCell tc2 = new TableCell();
                lblT = new Label();
                txt = new TextBox();
                lblT.Text = dr.ColumnName + ":";
                txt.Text = table.Rows[0][dr].ToString();
                tc.Controls.Add(lblT);
                tc2.Controls.Add(txt);
                tr.Cells.Add(tc);
                tr.Cells.Add(tc2);
                tb.Rows.Add(tr);
            }