store procedure + datareader problem

[Agnes]

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()
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.

[Eric Lemmon]

Hi Agnes,

cmdSearch.CommandType = "dbo.companyinfo_shipper_search" It looks like the above line should be CommandText, not CommandType.
Try changing this, and be sure to set the CommandType to
CommandType.StoredProcedure (assuming that's a SP and not a table).

Does this fix it?

Take care,

Eric
"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:ub**************@TK2MSFTNGP10.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()
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.

[Cor Ligthert]

Hi Agnes,

I give you an answer bellow, but did you know there was a special newsgroup
for this kind of questions.

Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://communities2.microsoft.com/co...s/?dg=microsof
t.public.dotnet.framework.adonet>

You can try to change this (watch typos)

\\\
cmdSearch.CommandType = CommandType.StoredProcedure
cmdSearch.Commandext = "dbo.companyinfo_shipper_search"
///

I hope this helps?

Cor