NKTableView with Database

From NimbleKit

Jump to: navigation, search

Some sample code that shows a sqlite database on an NKTableView. Also uses an NKImage.

<html>
<head>
<meta name = "viewport" content = "initial-scale = 1.0, user-scalable = no" />
</head>
<body>
<script type="text/javascript" src="NKit.js"></script>

<script type="text/javascript">
var tableView = new NKTableView();
tableView.init(20, 20, 280, 300, 'plain');
tableView.show();


var database = new NKSQLite();
database.openDatabase("db1.sqlite", 0); 
database.executeSQL("SELECT * FROM Table1 order by field1");
results = database.getResults();
var records = results.length;

for (i=0; i<records; i++) 
{ 
   var mytitle=results[i].field1;
  var mysubtitle=results[i].field2;
   var nki1 = new NKImage();
   nki1.loadFromBundle("contacts.png"); //load an image from the bundle... or you can also use loadURL(url);
   var myimage=nki1;
   var myimageright=0; //This will use just the default "arrow"
   var mysection=0;
   var mycallback="onRowClick()";
   tableView.insertRecord(mytitle,mysubtitle,myimage,mysection,myimageright,mycallback);
   
}

database.closeDatabase();

</script>

</body>
</html>

Personal tools