Kahapdos Member Licensed User Longtime User Jan 18, 2015 #1 B4J I need help please how connect mysql with tableview. I have the connextion MainForm = Form1 MainForm.RootPane.LoadLayout("1") MainForm.Show sql1.Initialize ("com.mysql.jdbc.Driver","jdbc:mysql://localhost/") but how load 1 table to tableview thanks
B4J I need help please how connect mysql with tableview. I have the connextion MainForm = Form1 MainForm.RootPane.LoadLayout("1") MainForm.Show sql1.Initialize ("com.mysql.jdbc.Driver","jdbc:mysql://localhost/") but how load 1 table to tableview thanks
Erel B4X founder Staff member Licensed User Longtime User Jan 18, 2015 #2 You can use DBUtils.ExecuteMemoryTable to get a list with the results and then go over the results and add them to the TableView: B4X: Dim rows As List = DBUtils.ExecuteMemoryTable(...) TableView1.Items = rows Upvote 0
You can use DBUtils.ExecuteMemoryTable to get a list with the results and then go over the results and add them to the TableView: B4X: Dim rows As List = DBUtils.ExecuteMemoryTable(...) TableView1.Items = rows