store procedure problem

[Agnes]

my stored procedure runs very well. However, as I use .net to get the
dataset .It is fail, no data returns .
what's wrong with my code ?
Please help.

With cmdSearch
.Connection = conPubs
.CommandText = "dbo.companyinfo_shipper_List"
.CommandType = CommandType.StoredProcedure
End With

prmSearch = cmdSearch.Parameters.Add("@name", 'F%'))
prmSearch.Direction = ParameterDirection.Input
prmSearch.SqlDbType = SqlDbType.Char
Dim daSearchResult As New SqlDataAdapter(cmdSearch)
conPubs.Open()
daSearchResult.Fill(dsSearchResult)

---------------------------------------------
CREATE PROCEDURE dbo.companyinfo_shipper_list
@name char(40)
as
select code,name,address1,address2,address3,address4 ,telno,faxno
from companyheader
where shippersw = 1 and name like @name
order by name

 

[Cor Ligthert]

Hi Agnes,

I am not sure however I think you did mean something as:

cmdSearch.Parameters.Add("@name", "F%")

And than delete this part
prmSearch = cmdSearch.Parameters.Add("@name", 'F%'))
prmSearch.Direction = ParameterDirection.Input
prmSearch.SqlDbType = SqlDbType.Char

As far as I can see that does nothing.

However it is sunday, so maybe when this is not right you can ask it as well
in the newsgroup

Cor

Adonet
<
Web interface:

<http://communities2.microsoft.com/communities/newsgroups/en-us/?dg=microsof
t.public.dotnet.framework.adonet>

I hope this helps?

Cor

 

[Charlie Smith]

my stored procedure runs very well. However, as I use .net to get the
dataset .It is fail, no data returns .

Agnes,

Try changing the parameter to varchar(40).

HTH

 

[Herfried K. Wagner [MVP]]

my stored procedure runs very well. However, as I use .net to get the
dataset .It is fail, no data returns .

Just FYI:

There is a separate group for .NET + database related questions
available:

<URL:
Web interface:

<URL:http://msdn.microsoft.com/newsgroups/?dg=microsoft.public.dotnet.framework.adonet>

 

[Cor Ligthert]

Use for this the option

echo off

 

[Herfried K. Wagner [MVP]]

Use for this the option

Ooops. Didn't see your reply in gnus :-(((.