How to check if a field Date is empty?

Question

User858916221 posted

Hi all

 

how can I check if a daet field in a dataset is empty before assiging it to a string variable

 

Answer 1

User269846090 posted

if(!string.isnullorempty(ds.tables[0].rows[0]["columnname"].tostring()))

{

assign the value to variable

}

else

{

// leave it.

}

Answer 2

User3866881 posted

Hi all

how can I check if a daet field in a dataset is empty before assiging it to a string variable

Hello：）

Please just use DbNull to check：

if(ds.tables[0].rows[0]["columnname"] is DbNull)
{
  //do what you want ……
}