Comments by KevinBadger (Top 11 by date)

Thanks,
I will look into that.

Erm...
Being a bit dumb here but:

1. Canvas? Where is this in relation to the listview item?
2. If I can use .canvas where do I put the code? Drawsubitem relates to a subitem and I want to highlight the entire line but drawitem does not seem to get triggered?

See my comment

I am catching the error and putting up a message.

I didn't write the code, just like I didn't write code to populate mu grid and that works OK.

I don't understand why the update SQL was not defaulted to the correct thing?

But, as I say, I am new to this.

Well, this is all a bit new to me
I didn't write the code for update, I dropted the grid onto the form:

private void ordersBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
try
{
this.Validate();
this.ordersBindingSource.EndEdit();
this.tableAdapterManager.UpdateAll(this.santanderDataSet);
}
catch (System.Exception ex)
{
MessageBox.Show(string.Format("Update failed ({0})", ex.Message));
}
}