Hi Bonnie,

The Convert.DBNull works for me. Here is the sample code (I happen to have this sample in VB .NET but you can get the general idea):

Dim oConnStr As String = "data source=localhost;initial catalog=Northwind;integrated security=SSPI;persist security info=False;packet size=4096"

' Make connection to database
Dim oConn As New SqlConnection()
oConn.ConnectionString = oConnStr
oConn.Open()

' Create a Command object with select statement
Dim strSelect As [String] = "SELECT FirstName,LastName,Title FROM EMPLOYEES"
Dim oSelectCommand As New SqlCommand(strSelect, oConn)

' Create a Command object with insert statement
Dim strInsert As [String] = "INSERT INTO EMPLOYEES(FirstName,LastName,Title) values (@FirstName,@LastName,@Title)"

Dim oInsertCommand As New SqlCommand(strInsert, oConn)
oInsertCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@FirstName", System.Data.SqlDbType.NVarChar, 10, "FirstName"))
oInsertCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@LastName", System.Data.SqlDbType.NVarChar, 20, "LastName"))
oInsertCommand.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Title", System.Data.SqlDbType.NVarChar, 30, "Title"))

' Create a DataAdapter
Dim da As New SqlDataAdapter()
da.SelectCommand = oSelectCommand
da.InsertCommand = oInsertCommand

' Create a DataSet
Dim ds As New DataSet()

' Fill the DataSet with table information
da.Fill(ds, "Employees")

Dim dr As DataRow = ds.Tables(0).NewRow()
dr("FirstName") = "NetFN"
dr("LastName") = "NetLN"
dr("Title") = Convert.DBNull
ds.Tables(0).Rows.Add(dr)

da.Update(ds.Tables(0))

oConn.Close()

>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 ?