Hi All,

I'm using MsSQL2000. How can I generate an aspx with certain <asp:ControlName ..../> based on my SQL Data at runtime ?

For example: I have a table called Students.

StudentID Title1 DispControl1 Title1 DispControl2
A0001 CourseName Listbox Comments textbox
B0003 DateofBirth Calendar ************ DropDownList

When Student A0001 login (login.aspx), they will see CourseName with its Listbox and Comments with textbox in SCREEN.ASPX

When Student B0003 login (login.aspx), they can select DateofBirth from Calendat and ************ from the dropDownList in SCREEN.ASPX

Any possibility to write ONE aspx ie SCREEN.ASPX to display different StudentID data ? I hope that I do not need to hardcoded many many aspx to cater this.

Any advice is appreciated. Thanks in advance!!

Hey,

Well, you need to determine what are the differences between Student A0001 and B0003 (with what options are shown: CourseName, DateofBirth), to determine whether you can pickup the difference through code. Seeing A0001 and B0003 I would have to say that you would check the first letter of the user to pickup the difference, then output the appropriate info.

I use two panels to switch the appropriate content. If Student A.. logins in, then show the Listbox and textbox in panel1, otherwise, show the calendar and dropdownlist in panel2.

Brian

Thanks!!! I'll try it out.