ASP.NET (Telerik RadGrid, RadCombo, jQuery)

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