Family List

Owned by svitlana (Deactivated)
Last updated: Jul 04, 2018
1 min read



Introduction

The family list grid is used to collect the names of a family. It shows how to setup a grid with multiple types of columns, storing its data into a mysql database.

Screenshots

Grid configuration

# # There are 4 columns # gd.columns=name, dob, gender, relation, hobbies gd.tablename=familylist # # Family list is stored in the mysql database 'igrid_test' running on the local machine # The database is accessed using userid igrid_tester and password igrid_tester # ds.gridds.connection.type=mysql ds.gridds.connection.url=jdbc:mysql://localhost:3306/igrid_test?useUnicode=true&characterEncoding=UTF8&jdbcCompliantTruncation=false ds.gridds.connection.username=igrid_tester ds.gridds.connection.password=igrid_tester col.name=First name col.name.type=string col.name.width = 40 col.name.editable = true col.name.sortable = true col.name.required = true col.dob=Date of Birth col.dob.type=date col.dob.width=30 col.dob.editable=true col.dob.sortable=true col.dob.required=true col.gender=Gender col.gender.width=30 col.gender.sortable=true col.gender.type=radio col.gender.list.size=2 col.gender.name1=Male col.gender.value1=M col.gender.name2=Female col.gender.value2=F col.relation=Role col.relation.width=30 col.relation.sortable=true col.relation.type=list col.relation.list.size=4 col.relation.name1=Father col.relation.value1=Dad col.relation.name2=Mother col.relation.value2=Mom col.relation.name3=Son col.relation.value3=S col.relation.name4=Daughter col.relation.value4=D col.hobbies=Hobbies col.hobbies.type=textarea col.hobbies.rows=5 col.hobbies.cols=60

SQL Setup

No special setup required.