C#

"INSERT INTO lojas (NIF, Loja, bloqueado, DataFim, lastupdate, Nome) 
    VALUES (@NIF, @Loja, @Bloqueador, @DataFim, @lastupdate, @Nome)"

values (" + NIF + "', " + loja + "," + bloqueador + ",'" + DataFim + "','" + lastupdate + "','" + Nome + "')

values(NIF',Loja,bloqueador,'DataFim','latupdate','Nome')

OriginalGriff wrote:

is £2 per postcode area, per user, per year

naouf10 wrote:

as my EPOS will not have internet connection

naouf10 wrote:

how this EPOS can find the address from the postcode although there is no internet access nor address database in the PC?

Dictionary<string, string> LbItemsToFilePaths = new Dictionary<string, string>
{
   {"ABC", @"D:\Music\XYZ"},  {"XYZ", @"D:\Music\Old\XYZ"} 
};

private void Form1_Load(object sender, EventArgs e)
{
    listBox1.DataSource = new BindingSource(LbItemsToFilePaths, null);
    listBox1.DisplayMember = "Key";
    listBox1.ValueMember = "Value";
}

// then you can get the filepath from the 'SelectedValue property of the ListBox
// when the user selects an item at run-time:
string selectedFilePath;

private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    selectedFilePath = listBox1.SelectedValue.ToString();
    Console.WriteLine(selectedFilePath);
}

var