Geeks With Blogs
New Things I Learned September 2008 Entries
Get return value from stored procedure
Recently we changed our DAC layer from using inline SQL to stored procedures in the database. On some of these SQL, we did record deletion (usually only 1 record), and we just execute it via IDBCommand.ExecuteNonQuery() and then check the return value to see how many records were affected (which should be 1) for verification that the query actually does something. With the change to stored procedure, we just return 1 in the stored procedure if the delete is successful. However, the calling code then ......

Posted On Wednesday, September 17, 2008 11:57 AM

Copyright © Muljadi Budiman | Powered by: