Hi, Einar,
To the best of my awareness, you can't use ExecuteNonQuery and then hope to get a return value.
I usually just use a data adapter and fill it, the same way you would if you're looking for a result set (even if, in this case, all you're getting back is a one-row, one-column table) There may be other ways, but that's one way.
Hope that helps...
Kevin