passing parameters to a stored procedure

[vbguy2008]

I am confused about how to pass parameters to a stored procedure. The stored procedure is written in sql server 2005 and the code is in vb.net.

I have included the sub that I am working on. I know that my use of parameters is wrong. Can someone explain what I should do?

Public Sub AddRecipe()

        Using myDBconnection As New SqlConnection(setConnstring)
            Using SQLcmd As New SqlCommand()
                SQLcmd.Connection = myDBconnection
                SQLcmd.CommandType = CommandType.StoredProcedure
                SQLcmd.CommandText = "CreateRecipe"
               SQLcmd.Parameters.Add("Name", NVarChar)


            End Using
        End Using
    End Sub

[Negative0]

Here is a good example on how to use StoredProcedures in .Net.

[jmcilhinney]

There are essentially two ways to add a parameter to a command and they are the same whether you're executing a stored procedure or inline SQL. If you're calling ExecuteScalar, ExecuteReader or ExecuteNonQuery on the command or if you're executing it as the SelectCommand of a DataAdapter by calling Fill then you will normally want to set the parameter value when you add the parameter, e.g.

myCommand.Parameters.AddWithValue("@ParamName", paramValue)

There's no need to specify the type or size of the parameter because that's inferred from the value.

If you're executing the command as the DeleteCommand, InsertCommand or UpdateCommand of a DataAdapter by calling Update then you'll want to specify the source column for the parameter from the DataTable being saved, e.g.

myCommand.Parameters.Add("@ParamName", SqlDbType.NVarChar, 50, "SourceColumnName")

In this case you need to specify the type of the parameter and the size for those types that require it.

[vbguy2008]

thanks

[vbguy2008]

Can someone point me to resources on the syntax for stored procedures in sql server 2005. Its been a while since I have written a stored procedure and I am rusty.

I also need resources on how to pass an array of values all of the same data type to this stored procedure.

thanks,