C#

       SqlCommand Command = new SqlCommand("insert into lojas (NIF, Loja, bloqueado, DataFim, lastupdate, Nome) values (" + NIF + "', " + loja + "," + bloqueador + ",'" + DataFim + "','" + lastupdate + "','" + Nome + "')", connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue("@NIF", grid_lic.CurrentRow.Cells[1].Value);
Command.Parameters.AddWithValue("@Loja", grid_lic.CurrentRow.Cells[2].Value);
Command.Parameters.AddWithValue("@Bloqueado", grid_lic.CurrentRow.Cells[3].Value);
COmmand.Parameters.AddWithValue("@DataFim", grid_lic.CurrentRow.Cells[4].Value);
Command.Parameters.AddWithValue("@lastupdate", grid_lic.CurrentRow.Cells[5].Value);
                    Command.Parameters.AddWithValue("@Nome", grid_lic.CurrentRow.Cells[6].Value);

 Command.ExecuteNonQuery();

"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