stored procedure (parameter)

[afterMoon]

hi
is there a way for giving parameters to a stored procedure without using command.parameters.add method?. In vb6, we could've given parameters directly with connection.execute.

please help

[pvb]

Dim cmd As SqlCommand = New SqlCommand("Exec usp_Authors_f @au_id='123-56-1234'")

[afterMoon]

hi
thanks. but it gave an sqlexception error.
any suggetions?

thanks

[Marivic]

hi,

it should be:


Dim cmd As SqlCommand = New SqlCommand("Exec usp_Authors_f @au_id='123-56-1234'", MyConnection)

[afterMoon]

hi
ofcourse I tried that. Then I got that error.
any idea?

[pvb]

um, i only posted the part you needed, hence, no connection information, you don't have to put the connection reference in the initializer(you can do that later).

Imports System
Imports System.Data
Imports System.Data.SqlClient
Public Module TestCommand
Public Sub Main()
Dim connString As String = "user id=sa;password=sa;database=pubs;server=Manson;"
Dim cn As SqlConnection = New SqlConnection(connString)
Dim cmdText As String = "Exec usp_Author_f '274-80-9391'"
Dim cmd As SqlCommand = New SqlCommand(cmdText, cn)
Dim dr As SqlDataReader
Try
cmd.Connection.Open()
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
If dr.Read() Then
Console.WriteLine("Author's last name is {0}", dr("au_lname"))
End If
Catch sqlEx As SqlException
Console.WriteLine("Sql Exception: " & sqlEx.Message)
Catch ex As Exception
Console.WriteLine("Exception: " & ex.Message)
Finally
If Not dr Is Nothing Then
dr.Close()
End If
cmd.Dispose()
cn.Dispose()
End Try
Console.WriteLine("Press <Enter> to exit...")
Console.ReadLine()
End Sub
End Module
Here's the stored proc i'm calling:

Create Procedure usp_Author_f
@au_id id
As
Set Nocount On
Select
*
From
Authors
Where
au_id=@au_id
Set Nocount Off
go

[afterMoon]

Thank you very much Mr.PVB

the problem was I gave command.commandType as commandType.StoredProcedure. it's only text. right?

Thanks again