I use Visual Basic/Windows Forms to create my project
I have my form for amending orders ready.
The flow is:
Get order number
Open connection
sqlcommand to check if order number exists
if not, return
Set isolation level serialazable
Get response to "Delete full order"
If response is "Yes":
trans = connlock.BeginTransaction("Delete_OA")
qry = "delete from ilprod where iorno1 = " & miorno1.Text
cmd = New SqlCommand(qry, connlock, trans)
cmd.ExecuteNonQuery()
trans.Commit()
MessageBox.Show("OA " & miorno1.Text & "Deleted")
if response is no:
I display the order details and items.
if an item is selected, get response to "Delete item?"
if res ...
Go to the complete details ...