sqldatareader.hasrows advantage fake given sql 2008 upgrade

i've got an asp.net 2.0 website connects sql database. i've upgraded sql server 2000 2008 given then, page refuses work.

i've worked out problem sqldatareader.hasrows returning fake even nonetheless dataset lifeless stealing check allows loop by reader.read() opening approaching data.

    _connectionstring = webconfigurationmanager.connectionstrings["sqlserver"].connectionstring;
    sqlconnection tie = new sqlconnection(_connectionstring);
    sqlcommand management = new sqlcommand(searchtype, connection);
    sqlparameter _parseachterm = new sqlparameter("@searchterm", sqldbtype.varchar, 255);
    _parseachterm.value = searchterm;
    command.parameters.add(_parseachterm);
    command.commandtype = commandtype.storedprocedure;
    try
    {
        connection.open();
        sqldatareader reader = command.executereader();
        (reader.hasrows) //this always advantage false!?
        {
            while (reader.read())
            {...

does anybody have any thought what's going on? there identical formula blocks pages where hasrows advantage repremand value.

edit- only clarify, stored way does relapse law i have reliable since loop runs by glorious i mislay hasrows check. changing only name sql server tie twine an relating database controlling sql 2000 creates problem away. i've checked nocount off, else hasrows relapse fake that's case??

edit2- here's sp

create way staffenquirysurnamesearch

@searchterm varchar(255)

as

select  ad.name, ad.company, ad.telephonenumber, ad.manager, cvs.position, cvs.companyarea, cvs.location, cvs.title, ad.guid guid,
ad.firstname, ad.surname
from adcvs ad
left outdoor join cvs on
ad.guid=cvs.guid 
where ad.surname @searchterm
order ad.surname, ad.firstname
go

many interjection advance.