topic Set a row value to Null in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/set-a-row-value-to-null/m-p/141899#M3700 <HTML><HEAD></HEAD><BODY><SPAN>How does one set a row value to null?</SPAN><BR /><BR /><SPAN>pRow.Value(i) = "" sets it to an empty string</SPAN><BR /><SPAN>pRow.Value(i) = nothing also sets it to an empty string</SPAN><BR /><SPAN>pRow.Value(i) = system.dbnull&nbsp; generates an error</SPAN><BR /><BR /><SPAN>in the field calculator you can create an expression like Field1 = null and it will set the values to Null, but how do you do it in .NET?</SPAN></BODY></HTML> Sun, 06 Nov 2011 03:06:59 GMT BerndtNording 2011-11-06T03:06:59Z Set a row value to Null https://community.esri.com/t5/arcobjects-sdk-questions/set-a-row-value-to-null/m-p/141899#M3700 <HTML><HEAD></HEAD><BODY><SPAN>How does one set a row value to null?</SPAN><BR /><BR /><SPAN>pRow.Value(i) = "" sets it to an empty string</SPAN><BR /><SPAN>pRow.Value(i) = nothing also sets it to an empty string</SPAN><BR /><SPAN>pRow.Value(i) = system.dbnull&nbsp; generates an error</SPAN><BR /><BR /><SPAN>in the field calculator you can create an expression like Field1 = null and it will set the values to Null, but how do you do it in .NET?</SPAN></BODY></HTML> Sun, 06 Nov 2011 03:06:59 GMT https://community.esri.com/t5/arcobjects-sdk-questions/set-a-row-value-to-null/m-p/141899#M3700 BerndtNording 2011-11-06T03:06:59Z Re: Set a row value to Null https://community.esri.com/t5/arcobjects-sdk-questions/set-a-row-value-to-null/m-p/141900#M3701 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">How does one set a row value to null?<BR /><BR />pRow.Value(i) = "" sets it to an empty string<BR />pRow.Value(i) = nothing also sets it to an empty string<BR />pRow.Value(i) = system.dbnull&nbsp; generates an error<BR /><BR />in the field calculator you can create an expression like Field1 = null and it will set the values to Null, but how do you do it in .NET?</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><SPAN>Check out </SPAN><A href="http://www.c-sharpcorner.com/UploadFile/sd_patel/EnterNullValuesForDateTime11222005015742AM/EnterNullValuesForDateTime.aspx">this link</A><SPAN>.&nbsp; It seems to list a way to generate a null value, at least for date fields.&nbsp; Let me know if this points you in the right direction.</SPAN></BODY></HTML> Sun, 06 Nov 2011 04:42:03 GMT https://community.esri.com/t5/arcobjects-sdk-questions/set-a-row-value-to-null/m-p/141900#M3701 RichardFairhurst 2011-11-06T04:42:03Z Re: Set a row value to Null https://community.esri.com/t5/arcobjects-sdk-questions/set-a-row-value-to-null/m-p/141901#M3702 <HTML><HEAD></HEAD><BODY><SPAN>See also </SPAN><A href="http://www.devnewsgroups.net/adonet/t4039-adding-null-vb-net-field.aspx">this link</A><SPAN> for string fields.&nbsp; It seems you should use</SPAN><BR /><BR /><SPAN>field.value = dbNull.value.</SPAN></BODY></HTML> Sun, 06 Nov 2011 04:52:06 GMT https://community.esri.com/t5/arcobjects-sdk-questions/set-a-row-value-to-null/m-p/141901#M3702 RichardFairhurst 2011-11-06T04:52:06Z Re: Set a row value to Null https://community.esri.com/t5/arcobjects-sdk-questions/set-a-row-value-to-null/m-p/141902#M3703 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">How does one set a row value to null?<BR /><BR />pRow.Value(i) = "" sets it to an empty string<BR />pRow.Value(i) = nothing also sets it to an empty string<BR />pRow.Value(i) = system.dbnull&nbsp; generates an error<BR /><BR />in the field calculator you can create an expression like Field1 = null and it will set the values to Null, but how do you do it in .NET?</BLOCKQUOTE><BR /><SPAN> </SPAN><BR /><BR /><SPAN>Try:</SPAN><BR /><BR /><PRE class="lia-code-sample line-numbers language-none"> pRow.Value(i) = System.DBNull.Value </PRE></BODY></HTML> Sat, 11 Dec 2021 07:49:03 GMT https://community.esri.com/t5/arcobjects-sdk-questions/set-a-row-value-to-null/m-p/141902#M3703 JamesCrandall 2021-12-11T07:49:03Z