Hi all.. I am trying to insert multiple tables at a time.. If any one of the insert is failed that means 0 rows updated after that.. When i try to execute the command in .net using execute non query i got 0 as result .. Is there any alternative ways to fix this .
I need to execute the query and return 1 as the result ie,. successfully inserted..
cmd.executenonquery(....,con); While executing the above query i got 0 as return value that means insert is not successfull. But in my query I insert values to 9 tables ..If any one of the table has no value to insert (0 rows) then the query returns 0
Thanks in advance..