Parameter object

Results 1 to 2 of 2

Thread: Parameter object

  1. #1
    Join Date
    Dec 1969

    Default Parameter object

    Is there a preformance in using explicit parateters below as to have them inline and using CommandType.Text? It is more typing, so wondering is it worth the effort to use explicit parameters?<BR><BR><BR>Dim pCompCd As SqlParameter = New SqlParameter("@sComp_Cd", SqlDbType.NChar, 6)<BR>pCompCd.Value = "N" & sNew_Comp_Cd<BR>moComm1.Parameters.Add(pCompCd)<BR ><BR>Thanks in advance

  2. #2
    Join Date
    Dec 1969

    Default RE: Parameter object

    To be honest I don&#039;t think you&#039;ll be able to see any difference unless you&#039;re using hundreds of parameters in hundreds of iterations of a loop.<BR><BR><BR>j<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts