Hi. On my button click event, I have 3 tasks to do: 1) to update one of my sql database tables & 2) to insert variables in another sql database tables. My questions are:
a) Can I execute multiple sqlCommands within one sqlConnection Open() and Close() block?
b) What is the best method to achieve this? - I tried separate connections and commands and also using block method my in both the cases, my first command works and other one doesn’t.
Please advise. Thanks in advance. Sat