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 ?