Name: Anonymous 2009-08-29 2:26
My problem is that I have all kinds of different tables that I would like to have the same form data entry for. The table structures are subject to change at a moments notice and for flexibility I want to keep it that way.
Here's essentially what I have so far:
code_infront
<asp:placeholder id="phUserForm" runat="server"></placeholder>
code_behind
sqldatareader for sql to get columns : exec getColumns for id=Apples1234567 (gets entry from tblColumnKey).
--- How to? Generate code_infront form elements based on the data returned.
--- How to? Accept values from said forms"
SQL Layout:
tblColumnKey
ColumnName | ColumnType | FieldOrder
-------------------------------------
Name | varchar(80) | 1
Photo | blob | 2
BirthDay | datetime | 3
etc...
code:
tblApples1234567
Name | Photo | BirthDay
-------------------------------------
Here's essentially what I have so far:
code_infront
<asp:placeholder id="phUserForm" runat="server"></placeholder>
code_behind
sqldatareader for sql to get columns : exec getColumns for id=Apples1234567 (gets entry from tblColumnKey).
--- How to? Generate code_infront form elements based on the data returned.
--- How to? Accept values from said forms"
SQL Layout:
tblColumnKey
ColumnName | ColumnType | FieldOrder
-------------------------------------
Name | varchar(80) | 1
Photo | blob | 2
BirthDay | datetime | 3
etc...
code:
tblApples1234567
Name | Photo | BirthDay
-------------------------------------