ASP.NET 4.5 (Telerik RadGrid)
Must use Telerik RadGrid, Telerik Load-on-demand using Web Service, jQuery, LINQ, ASP.NET 4.5, Entity Framework, HTML5.
There will be two sections: RadGrid to display data in a tabular format and Controls to allow a user to add a row.
a) tblIndividualColumn: This stores all possible columns.
Table Columns: IndividualColumnName, Length, LookupTable
TableValues:
Department, 10, tblDepartment
Project, 10, tblProject
Program, 10, tblProgram
tblDepartment values:
D1, D2, D3
tblProject values:
P1, P2, P3
tblProgram values:
G1, G2, G3
b) tblAppFields: This stores app feilds.
TableColumn: AppDisplayField, GroupID, FieldOrder, IsRequired
TableValues:
Input Combo, 1, 1, 1 (1st column in RadGrid) -- Based on the table C, this column consist of Department and Project data separated by dash.
Input Program, 2, 2, 0 (2nd column in RadGrid)
c) tblGroupFields: This maps how app fields are created.
TableColumn: GroupID, IndividualColumnName, DisplayOrder
1, Department, 1
1, Project, 2
2, Program, 3
Section 1: Allow a user to add data into dynamically created fields:
Based on the above tables, a page will contain two fields "Input Combo" and "Input Program" for a user to enter a new data. Data should saved in a new SQL table. The app should create a new table to store user data based on above setup.
E.g.., D1-P1, G1
Section 2: Create an ASP.NET page with Telerik RadGrid with column header as in [login to view URL] (don't need filter as shown in the demo).
The column header will be dynamic based on the above table structure.
E.g..,
D1-P1, G1
D1-P2, G2
-----------
If a user changes the tblGroupFields to the following values:
tblGroupFields:
TableColumn: GroupID, IndividualColumnName, DisplayOrder
1, Department, 1
2, Project, 2
2, Program, 3
Data will look like this in RadGrid and for user input:
D1, P1-G1
D1, P2-G2