[store procedure] + sqldatareader problem

my simple store procedure like thiese:-
CREATE PROCEDURE dbo.companyinfo_shipper_search
@searchcode varchar(10)
as
select name
from companyheader
where code = @searchcode
GO
-------------------------------------------------------------------
my vb.net code
cmdSearch.CommandType = "dbo.companyinfo_shipper_search"
prmCompany_Code = cmdSearch.Parameters.Add("@searchcode", strCode)
prmCompany_Code.Direction = ParameterDirection.Input
prmCompany_Code.SqlDbType = SqlDbType.VarChar

Try
Dim drCompanyReader As SqlClient.SqlDataReader =
cmdSearch.ExecuteReader(CommandBehavior.SequentialAccess)


Do While drCompanyReader.Read
Console.Write(drCompanyReader.GetString(0))
Loop
......etc
I use sql analyzer to check and it really return the correct records.
However, as I use sqldatareader,
it returns error" Invalid attempt to read when no data is present".
What's wrong with my code ???
Please help.

Marina
Tue Jun 01 11:45:39 CDT 2004

Why are you passing in CommandBehavior.SequentialAccess? That might be the
problem - try taking you out, you probably don't need it anyway since it
doesn't look like you are returning large binary data.

"Agnes" <agnes@dynamictech.com.hk> wrote in message
news:%230uirm%23REHA.3344@TK2MSFTNGP12.phx.gbl...
> my simple store procedure like thiese:-
> CREATE PROCEDURE dbo.companyinfo_shipper_search
> @searchcode varchar(10)
> as
> select name
> from companyheader
> where code = @searchcode
> GO
> -------------------------------------------------------------------
> my vb.net code
> cmdSearch.CommandType = "dbo.companyinfo_shipper_search"
> prmCompany_Code = cmdSearch.Parameters.Add("@searchcode",
strCode)
> prmCompany_Code.Direction = ParameterDirection.Input
> prmCompany_Code.SqlDbType = SqlDbType.VarChar
>
> Try
> Dim drCompanyReader As SqlClient.SqlDataReader =
> cmdSearch.ExecuteReader(CommandBehavior.SequentialAccess)
>
>
> Do While drCompanyReader.Read
> Console.Write(drCompanyReader.GetString(0))
> Loop
> ......etc
> I use sql analyzer to check and it really return the correct records.
> However, as I use sqldatareader,
> it returns error" Invalid attempt to read when no data is present".
> What's wrong with my code ???
> Please help.
>
>
>
>
>