Hi,
I think your stored Procedure is right.
You need to fetch output parameter in your C# Application like.
cnnConnection.Open();
cmdSQLCommand.ExecuteNonQuery();
string mErrorMsg ="";
mErrorMsg = (string)(cmdSQLCommand.Parameters["@idcount"].Value);