dbnull value

[NuB]

I have a grid on a winForm, where I can enter a date or leave it blank for
data entry. If I have a data field blank I get a DBNull value error, how can
I allow a blank date field in my grid be passed into the database without
getting a DBNull error?

 

[Nicholas Paldino [.NET/C# MVP]]

NuB,

Does the underlying column in the database support null values? If it
doesn't, and you are trying to update the value with null, you will get an
error.

Or are you getting a different error? If so, what are the details?

Hope this helps.

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Does the column in the DB accept nulls?

It has to accept null.


cheers,

 

[NuB]

yes, the date colum supports NULL values.

I get the error "Cannot get value because its DBNull"
I get this on the first row that has no date entered. If the first row has a
date entered then I do not get this error until I hit a row that has no date
in the date colum in the grid

NuB,

Does the underlying column in the database support null values? If it
doesn't, and you are trying to update the value with null, you will get an
error.

Or are you getting a different error? If so, what are the details?

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I have a grid on a winForm, where I can enter a date or leave it blank for
data entry. If I have a data field blank I get a DBNull value error, how
can I allow a blank date field in my grid be passed into the database
without getting a DBNull error?