Christian Graus wrote:
Does 'I found the stored proc' mean you don't really understand what it does ?
not 100% true. Actually I am not good at writing the stored procedures.
Christian Graus wrote:
the table adapter 's insert method probably doesn't return the result of the proc
this could be the issue ... But my task is straight forward, I have to first Insert a row in one table, then using the value of the Identity column of the created row, some rows are to have inserted into other table where, the primary-key in this table is Foreign key in the other table. What should be the approach to this problem ?
Apurv “Never trust a computer you can’t throw out a window.” (Steve Wozniak) “There are only two industries that refer to their customers as ‘users’.” (Edward Tufte)