how to set a menuItem text properties to a value retrieved from a DB

[jcavard]

Hi! I am designing an application that will be in french and english. So I will design two table with all the strings I need, on table in french and another in english. Like tbl_french_string and tbl_english_string, with field like STRING_MAIN_MENU_FILE = &File (&Fichier in french). At the application startup, I want to check the language selected and then loaded the right string. Like at startup, if English is selected, then it will loaded the tbl_english_string table and replace all the text with the right string. So there would be som,ething like that, mainMenu1.text = STRING_MAIN_MENU_FILE from the table loaded previously.

The problem I have is, that I know how to bind data to textboxes, but I dont know how to refer to dataset in the code ..., I dont know either how to create a dataset in the code, because I dont want to have two dataset with the two table, since only just one will be used, depending on what language has been selected. So I'd like to create the dataset at runtime to use the less memory. can anyone help me with this one!??

I hope I made myself clear, I'll check around, so posted any question and I will answer you if I'm not enogh clear. Thanks in advance!

Jean Christophe Avard