Click here to Skip to main content
15,890,741 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have a SQL table (tbl_badge) which have around 100 columns like primary_key,user_key,First_Name, Last_Name column 1, column 2, column 3, column 4...etc. I have to create a badge admin setting page with in 6 bag lines (master columns of tbl_setting_bage) by choose some of columns from the table (tbl_badge) . So I want to give this right (UI page with drag and drop columns ) to each and every admin user who can design badge setting (it means position of columns, no. of total taken clolumns, total no of columns in a single badge line etc) according to his/her choice, and settings will save in a database table.

Here are the badge admin setting and badge end user UI which i want.

Admin Bag Setting table (tbl_setting_bage) View-
<pre>
Badge Line 1 - {column 1} {column 3} {column 4} 
Badge Line 2 - {column 2} 
Badge Line 3 - {column 8} 
. 
. 
Badge Line 6 - {First_Name} {Last_Name}


if I get save above these settings in a table (tbl_setting_bage) then eaisly I can design and fetch for end user UI

Final End User Report UI will be like which I can take from above tables (setting_bage & tbl_badge)-

{badge Line 1},
Title : {badge Line 2}
Address : some text {badge Line 3}
some text {bag line 4}
...........
Phone :{badge Line 5}
From : {badge Line 6}

What I have tried:

I have fetched all table columns through this query

select column_name AS 'Column Name'
FROM information_schema.columns
WHERE table_name = 'Client_UserProfile'


I am totally blank from here...
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900