Save to DB

Question

Hi Everyone, 
 I need to store the values of lablels in col1, corresponding to col2 and col3 which are checkboxes into database and retrive it when the interface is loaded. Can anyone please help me out how to achieve this?

Harshit Bumb (Appyzie) · Answer

If the columns are fixed and will never increase or decrease, then the easiest way will be to create a dedicated column for every property in table an and use it in your editable grid. 
 If the column count isn't fixed, then you can use the below structure.

Label 
 Property 
 IsActive

Col1 
 Property1 
 TRUE

Col1 
 Property2 
 FALSE

Col2 
 Property1 
 TRUE

Col2 
 Property2 
 TRUE

Abhay Dalsaniya · Answer

You need to have a CDT (with 3 fields -col1,col2,col3) which represents this tabular structure. Then you can use it in grid or any other layout.