Gridview: howto check if value is empty (coming from SQL DB)?

[stevens]

Hi,

I 'd need to check if a gridview entry has a value yes or no.
The value for $Result = $($datagridview1.SelectedRows[0].Cells['Myvalue'].Value) I have is System.DBNull.

But there is no way I found yet to check if the value is there
if (($Result -eq [DBNull]::Value or ([DBNull]::Value).Equals([DBNull]::Value)){dosomestuff} else {dootherstuff}
It always shows the value as true, filled in or not

Please advise.

$($datagridview1.SelectedRows[0].Cells['Myvalue'].Value) | gm


TypeName: System.DBNull

Name MemberType Definition
---- ---------- ----------
Equals Method bool Equals(System.Object obj)
GetHashCode Method int GetHashCode()
GetObjectData Method void GetObjectData(System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context), voi...
GetType Method type GetType()
GetTypeCode Method System.TypeCode GetTypeCode(), System.TypeCode IConvertible.GetTypeCode()
ToBoolean Method bool IConvertible.ToBoolean(System.IFormatProvider provider)
ToByte Method byte IConvertible.ToByte(System.IFormatProvider provider)
ToChar Method char IConvertible.ToChar(System.IFormatProvider provider)

[jvierra]

DBNull is a type and not a variable. YOu cannot test a type that way. I field in SQL cannot have a scema type of DBNull. A null value in a column can be tested fro dbnull.

$sqlrow[$rowID].Column[0].Value.GetType()

[stevens]

Awesome, was at wrong path here. Works correctly, thanks!