Data grid + Stored procedure + input parameter ?

[JAM]

Hi everyone

I'm trying to display some data on a datagrid using a stored procedure that requires an input parameter.

The problem is how to pass the input parameter to the stored procedure.

ANY IDEA, PLEASE HELP.

[PlausiblyDamp]

       Dim sp As New SqlClient.SqlCommand()
       sp.CommandText = "stored proc name"
       sp.Parameters.Add("@param name", SqlDbType.Int) 'Change as appropriate
       sp.Parameters("@param name").Value = 47    'Change to your value