Setting a datacolumns value to NULL?

[Doug Swanson]

How do I set the value of a specific datarow's column to be null?

Ex.
Private sub savedata(byval sOID as string, byval sComment as SqlString)
Dim ods as dataset
Dim odt as datatable
Dim odr as datarow
Dim odrarray() as datarow
try
ods = me.getdataset(xxx...)
odt = ods.tables(0)
odrarray = odt.select("myoid = '" + sOID + "'")
for each odr in odrarray
If sComment.isNull then
??????? How do I set this particular row/column to be
null???
Else
odr("mycomment") = sComment.value
End if
next
finally



--
Doug Swanson
Senior Applications Developer
Synchrono, Inc
651.228.1772
(e-mail address removed)

 

[Rajesh Patel]

try ord("columnname") = system.dbnull.value

Rajesh Patel