How do I call a stored procedure in vb2005

Maybe this snippet can help:

Dim MyCmd As New OleDbCommand()

Dim Cnxn As New OleDbConnection("ConnectionString")

With MyCmd

.Connection = Cnxn

.CommandType = Data.CommandType.StoredProcedure

.CommandText = "MyStoredproc"

End With

Cnxn.Open()

Dim MyReader As OleDbDataReader = MyCmd.ExecuteReader

While MyReader.Read

Dim Column0Data As String = CStr(MyReader(0))

End While

Cnxn.Close()

DMan1 at 2007-9-3 >

• Create SqlCommand object.

• Configure it to access a stored procedure by setting the commandtype to stored procedure.

• Add the parameters that exactly match thoose in the stored procedure itself.

• Execute.

command.Parameters.Add(New SqlParameter(@au_id, authorId))

(command is the SqlCommand created earlier).

I just cant figure out why they are doing this? Is it something you have to do while calling a stored procedure?

Excuse me for possible bad English/American.

JohanFrisell at 2007-9-3 >