Hi,

anyone can help if you have a nice algorithm to solve dbconcurrency.

my code goes like this

try

{

this.TAInvoice.Update(this.Invoice);

this.TAInvoiceCharge.Update(this.InvoiceCharges);

transac.Commit();

}

catch(DBConcurrencyException DBC)

{

}

finally

{

TAInvoice.Connection.Close();

TAInvoice.Connection = null;

}

note that the table invoice is a parent and invoicecharges a child table.

i have set cascade on update and delete on the relation.

thanks.

hrub.

Hi,

You can't manage database concurrency using this method. You will have to implement some type of row checking or compare your original values with currently saved database values and decide whether you want to save or not.

If no record is saved then raise some errors either from your SQL or .Net code.

Hope this will give you some clue.
Zafar Iqbal

Hi thanks for the tip,

I also believe working with datasets could/would be having another way of solving things, up until now i am loving code minimisation techniques with datasets, batch updates. ,

Are you sure there are no other methodologies to handling concurrency using datasets, other than this., am sure there is..

any one else on this track?

thanks.