What Is Wrong With This Sproc Call?

I keep getting 0 returned, in both Query Analyzer and in my code. My double 'rate' just always ends up 0 or Null, and I've tried many different approaches. Here is the general idea. This is all for phone number searching.





I have a table with three columns - country, countrycode, and rate. The country code is two or three digits. In the code, I strip the first two digits of phoneNumber to make codeTwo and then strip the first three to make codeThree. That part works. I then pass codeTwo and codeThree to the sproc.





There are no overlapping codes (ie 23 and 237), so I search for a country code matching codeTwo and return that value. If none is found, then I search for a country code matching codeThree and return that value. If none is still found I return 0.





Here is the SQL 2000 stored procedure:





CREATE PROCEDURE getRate





(


@codeTwo int,


@codeThree int,


@rate int OUTPUT


)


AS





SELECT @rate = rate


FROM rates


WHERE countrycode = @codeTwo





IF @@rowcount = 0





SELECT @rate = rate


FROM rates


WHERE countrycode = @codeThree





RETURN@rate


GO





Here is the code calling the sproc:





string dbConn=ConfigurationSettings.AppSettings["ConnectionString"];


SqlConnection conn=new SqlConnection(dbConn);


SqlCommand cmd = new SqlCommand( "getRate", conn );


cmd.CommandType = CommandType.StoredProcedure;





SqlParameter parmTwoCountry = cmd.Parameters.Add("@codeTwo", SqlDbType.Int);


parmTwoCountry.Value = codeTwo;





SqlParameter parmThreeCountry = cmd.Parameters.Add("@codeThree", SqlDbType.Int);


parmThreeCountry.Value = codeThree;





SqlParameter parmRate = cmd.Parameters.Add("@rate", SqlDbType.Int);


parmRate.Direction = ParameterDirection.Output;





try


{


conn.Open();


cmd.ExecuteNonQuery();


conn.Close();





rate = Convert.ToDouble(parmRate.Value);


}


catch(Exception ex){throw new Exception(ex.Message);}


finally {}








Thanks for your time,


dave