How pass null in VB to field of a table of sqlserver?

• Hector Angello Silva Carmona

  SSCrazy

  Points: 2720

  More actions

  May 14, 2007 at 1:49 pm

  #176649

  Hello friends do you know how to pass null value to a variable in VB for insert a null into a table or to pass like input parameter to sp???

   

  example

   

  Dim a as integer

  Dim strquery as string

  a = null ' this is my problem null of VB is different to a null of sql server

  strquery = " insert into CT_Mytable value(" & a & "&nbsp"

   

  thank you your help

• Sam-246632

  Old Hand

  Points: 366

  More actions

  May 14, 2007 at 8:12 pm

  #706370

  try using this.......

  Dim lsTemp as String

  lsTemp ="NULL"

  or lsTemp = vbNull