To insert null values

Question

How to insert null values in to not null fields in vb.net ?

Vaikesh K P · Answer

Hi Check this : 1) https://msdn.microsoft.com/en-us/library/ 2) http://stackoverflow.com/a/4722780/3891036

Jithil John · Answer

But it doesn't work for not null fiels

Rajeesh Menoth · Answer

Hi If String.IsNullOrEmpty(pd_first_name.Text.ToString().Trim) = true Then frmFirstName = DBNull.Value Else frmFirstName = pd_first_name.Text End If

Sumit Joshi · Answer

Hi JITHIL JOHN Check whether the value is NULL if it is Null then pass DBNULL.Value https://msdn.microsoft.com/en-us/library/system.dbnull.value(v=vs.110).aspx If helpful mark as Correct Answer