How to read all 4 the sql command?

Question

When i click the button only the two first sql command are working and the third and fourth command are not workingcan anyone help guys? i'm using visual studio 2013 (vb.net) and sql server 2012

Manoj Bhoir · Answer

Hi While Inserting and Deleting why you are using ExecuteReader . Just use ExecuteNonQuery which will give you Number of Rows affected . Try to debug your code and check when your second Insert command execute on Database what value you are getting in your READERRR variable. It may be null. You are using ( If READERR.Read() Then ) if READERR is null your condition return false and it will not execute other two queries. Simply use ExecuteNonquery and check if number of rows affected is greater thatn 0 then execute next query.

Manoj Bhoir · Answer

Welcome. :)

King Umar · Answer

Thank you Manoji have tried your suggestions and it worked..many thanks :D