Hi Tony,

Thanks for reply. What you have mentioned will work, my stored procedure does an insert if the record doesn't exist and update if it does. I really dont want to return a dataset, I just need a rowcount that the record was updated. Somehow ExecNonQuery doesn't work for me.

Thanks again

Yassin