How to Find the shell script was successfully executed in VB.Net

Hi All,

I m executing the below line from vb.net

Microsoft.VisualBasic.Interaction.Shell("osql -S sap-server -U sa -P sa123 -d TBP1 -i C:\sql1.sql", AppWinStyle.Hide)

This command is successfully getting executed

since i m running an sql script from sql1.sql file, there may be some error while execution

But i find that it does not generate any error, irrespective of Query being correct or incorrect

How can i find that the above command is successfully executed

Awaiting Reply

Sanjay