First things first, I am an absolute newbie when it comes to RealBasic. I've been using VB.NET since Beta 2 but only picked up RB a few days ago.
Anyway, I have a very simple database (one table), and I can add records to it, but can't figure out how to get them back out! My table (Projects) contains two fields (ID and Name), and I'm trying to put all the Names into a ListBox.
I think I've filled my RecordSet correctly, so how do I get the data out of it? In VB, I would do this:
For Each myRow As DataRow In myDataSet.Tables("Projects").Rows
ProjectList.Items.Add(myRow("Name"))
Next
Nice and simple, but I can't figure out how to do this in RB. Even Google hasn't been helpful, maybe I've been searching for the wrong things. Someone must know what to do
Thanks
Edit: Problem has been solved
Anyway, I have a very simple database (one table), and I can add records to it, but can't figure out how to get them back out! My table (Projects) contains two fields (ID and Name), and I'm trying to put all the Names into a ListBox.
I think I've filled my RecordSet correctly, so how do I get the data out of it? In VB, I would do this:
For Each myRow As DataRow In myDataSet.Tables("Projects").Rows
ProjectList.Items.Add(myRow("Name"))
Next
Nice and simple, but I can't figure out how to do this in RB. Even Google hasn't been helpful, maybe I've been searching for the wrong things. Someone must know what to do
Thanks
Edit: Problem has been solved