Stored Procedures

[vlitim]

am using the below code to execute a normal statement, but now want to turn it into a stored procedure. I ahve written the syored procedure 'sp_showTasks' and need to pass a parameter to it. How do I convert the below code to work with the SP??

Dim nwindConn As SqlConnection = New SqlConnection(SQLCon)
nwindConn.Open()
Dim myCMD As SqlCommand = New SqlCommand("SELECT * FROM todo WHERE " & sqlStr & "", nwindConn)
Dim todo As SqlDataReader = myCMD.ExecuteReader()

Dim i = 0
Do While todo.Read()

loop
....................

Cheers
Tim

[Edneeis]

I don't remember if the SQLCommand has a type property or not but you can just put the name of the SP where you have the SELECT statement:

Dim nwindConn As SqlConnection = New SqlConnection(SQLCon) 
nwindConn.Open() 
Dim myCMD As SqlCommand = New SqlCommand("sp_GetUserID", nwindConn) 
Dim todo As SqlDataReader = myCMD.ExecuteReader()