指定Null值在DataTable中的整数列 [英] Assign Null value to the Integer Column in the DataTable
本文介绍了指定Null值在DataTable中的整数列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个的ColumnName客户ID与整数数据类型,一个DataTable。
动态我要行添加到数据表。对于这一点,我已经创建了一个DataRow对象,如:
I have a datatable with One ColumnName "CustomerID" with Integer DataType. Dynamically I want to add rows to the DataTable. For that, I had created one DataRow object like:
DataTable dt = new DataTable();
DataRow DR = dt.NewRow();
DR["CustomerID"] = Convert.ToInt32(TextBox1.Text);
但是,如果文本框包含空字符串,它抛出的错误。在这种情况下,我想Null值分配给客户ID。如何做到这一点?
But if the TextBox contains empty string, it throws the error. In that case, I want to assign Null value to the CustomerID. How to do this?
推荐答案
一个空/空字符串格式错误;您将需要检测的场景和补偿:
A null/empty string is in the wrong format; you would need to detect that scenario and compensate:
DR["CustomerID"] = string.IsNullOrWhiteSpace(text)
? DBNull.Value : (object)Convert.ToInt32(text);
这篇关于指定Null值在DataTable中的整数列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文