空值处理（国外英文资料）.docVIP

空值处理（国外英文资料） 1. A null value processing The method for determining null values in a database without a null value in c # is wrong DataRow Dr = tablename.rows [0]; If (Dr [ ID ] = = null) / / this is the wrong one and it cant judge whether it is null. The return; The null value in the database is the DBNULL method If (Dr [ id ] = = DBnull. Value) The return; Or you might say If (Dr [ id ].tostring () = = string.empty) The return; There is a question of what kind of data can be converted into a string to make sure that this transformation is not wrong The object of aa = null; String Eorr = aa.tostring (); / / this will report that the error message is not instantiated and that this empty value cannot be converted to a string The object bb = DBnull. Value; String Right = bb. / / this is the right thing to turn out to be an empty string. If (Right = string. Empty) this would be the Right thing to do. ... When a database USES a statement like select * from TableName, it is often found that the value of a field is NULL, and there is a blank. Whats the difference? A blank is a null value and a median is the same as an empty string, which is indeed an empty string when it is converted into a string in c # The NULL that you see in the database is actually the value of the data and the unknown is unknown for the first time and Ill just use it as an empty value. In c # it corresponds to DBnull. Value, I guess DBnull. Value is a data value that is specifically designed to handle database data convenience. Just now, DBNull. Value is converted into a string that is also an empty string. So the way to determine whether or not a data is the safest method in the database is If (Dr [ id ].tostring () = = string. Empty) / / it doesnt happen because no c # objects in the database are null. ... / / if you are doing it yourself, it is hard to say that you can only say that data obtained from the database does not have a null phenomenon that is not instantiated. The effect of constant va