store procedure error

  • Thread starter Thread starter Hrvoje Voda
  • Start date Start date
H

Hrvoje Voda

SqlConnection conn = null;

int rowCount;


string sConnectionString = "packet size=4096;user id=sa;persist security
info=False;initial catalog=LeonUsers";



conn = new

SqlConnection(sConnectionString);

conn.Open() ;

userDb = new Db(sConnectionString);

SqlCommand cmdCount = new SqlCommand("UsersGroupsSearch", conn);

cmdCount.CommandType = CommandType.StoredProcedure;


cmdCount.Parameters.Add (new SqlParameter ("@UserID",
userRecAccount.UserID));

cmdCount.Parameters.Add("@RowCount", SqlDbType.Int);

cmdCount.Parameters["@RowCount"].Direction = ParameterDirection.Output;

cmdCount.ExecuteNonQuery ();

rowCount = (int)cmdCount.Parameters["@RowCount"].Value; <---- an
error: " Specified cast is not valid."



Hrcko
 
Back
Top