I have a flat file database program I'm writing using SQLite3 and I've run into a problem and a question.
Problem: I have the various fields on the forms linked to the results of my queries using databindings. They all work just fine except for 2. They are pulled from a table after the rest of the data. They show up it I move to the next record and back but when I first get the results, everything else shows up but the 2. Any ideas?
Question: I want to have a label on the form that tells me where I am in the list and how many records there are. The formatting should be something like
String.Format("Record {0} of {1}", current, count);
. Is there a way to do that with databindings so it updates as I scroll, even if I do a jump to the first or last record?
Thanks.