passing paramiters to sp's

[Edneeis]

Looks fine to me or atleast nothing 'seems' out of place. I'd save myself some typing when creating the command but that is strictly personal.

Dim cmd As New SqlCommand("insRecord", _ 
New SqlConnection("Password=KJH987KJ;Persist Security Info=True;User ID=sa;Initial Catalog=MortgageFlowDev;Data Source=COSERV01\MORTGAGEFLOWLIVE"))
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New SqlParameter("@strTitle", "Mr"))
cmd.Parameters.Add(New SqlParameter("@strFirstName", "wolly"))
cmd.Parameters.Add(New SqlParameter("@strSurname", "woo"))

Are you using SQL7 and I think that articles is relative to the Prepare method. Actually if you want to make life easier then you should check out the MS Data Access Blocks.

http://msdn.microsoft.com/library/de...ml/daab-rm.asp

It is basically a set of wrapper type classes that simplify the process.