Cathi,
If you recall a previous thread where I asked a question about inserting a NULL, I could never get the darn thing to work. I don't know if it's a bug or what, but I gave up on it.
~~Bonnie
>The SQL Server syntax for the insert statement is:
>
>
>insert into TABLENAME (FIELD1, FIELD2) values ('TEXT', NULL)
>
>
>If you are setting the value in a DataRow inside of a DataTable, then you set the value of the DataRow like the following:
>
>
>rowCustomer("ContactName") = Convert.DBNull
>
>
>
>>how to insert a null value to database (DB2,SQL Server) from vb.net ?