vb.netwinformswinapp

Difference between nothing and system.DBNull

I am working in VB.NET and I am wondering about the difference between Nothing and System.DBNull.

When I fire save query at that time I am giving value from grid at runtime like as follow:

gvMain.Rows(j).Cells("Brand").Value.ToString()

But it shows me error when it has value of Nothing and it works perfectlly when it has value of System.DBnull.

What to do in this case?
Thanks in advance

Solution

  • The keyword Nothing is used to specify or asign that a var of reference type is not pointing anything, no object is instanciated for this var.

    DBNull.Value, on the other hand, is an object used to point out that a type of a field of the DataBase is of null value.