如何在C＃中检查DBNULL？ [英] How to check DBNULL in C#?

问题描述

您好我正在使用Adapter并且在amount字段中有dbnull值。那么如何检查值是否为dbnull？



我尝试过：



var amount = Convert.IsDBNull（smsMessageTransactionDetailsProcessing.Amount）？ 0：smsMessageTransactionDetailsProcessing.Amount.ToString（）;





但我收到DBNUll的错误。

解决方案

尝试：

 amount = smsMessageTransactionDetailsProcessing.Amount == DBNUll.Value？   0：smsMessageTransactionDetailsProcessing.Amount.ToString（）; 

Hi i am using Adapter and in amount field there is dbnull value. So how to check the value is dbnull or not?

What I have tried:

var amount= Convert.IsDBNull(smsMessageTransactionDetailsProcessing.Amount) ? "0" : smsMessageTransactionDetailsProcessing.Amount.ToString();


but i get error on it of DBNUll.

解决方案

Try:

amount = smsMessageTransactionDetailsProcessing.Amount == DBNUll.Value ? "0" : smsMessageTransactionDetailsProcessing.Amount.ToString();

这篇关于如何在C＃中检查DBNULL？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！