ASP.net table adapter parameter query

Hi

In ASP.net 4 I have a table adapter with a parameter query. How do I pass a NULL value
into a parameter query?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
informaniacConnect With a Mentor Commented:
SqlDbValue.Null?
0
 
Pratima PharandeCommented:
Use System.DBNull.Value
0
 
Pratima PharandeConnect With a Mentor Commented:
dim Parameter as SqlParameter
for each Parameter in comm.Parameters
      if Parameter.Value is null then
            Parameter.Value = DBNull.Value
      end if
next
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
All Courses

From novice to tech pro — start learning today.