</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">DataObjects for .NET</div> <div id="PageTitle"><div id="PageTitleText">AutoIncrement Property (Field)</div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span><!-- Spacing --> <span id="LanguageFilterPopupLink" class="PopupLink" data-popupcontentsource="#LanguageCheckboxes" data-popuptitle='Language Filter'> <label id="ShowAllLabel" for="LanguageFilterPopupLink"> Language Filter: All </label> <label id="MultipleLabel" for="LanguageFilterPopupLink" style="display: none;"> Language Filter: Multiple </label> <label id="VBAllLabel" for="LanguageFilterPopupLink" style="display: none;"> Language Filter: Visual Basic </label> <label id="VBLabel" for="LanguageFilterPopupLink" style="display: none;">Language Filter: Visual Basic (Declaration)</label> <label id="CSLabel" for="LanguageFilterPopupLink" style="display: none;">Language Filter: C#</label> </span> <div class="PopupContent" id="LanguageCheckboxes"> <input data-languagename="VB" id="VBLanguageCheckbox" type="checkbox" class="ToggleLanguageCheckbox" checked="true" data-toggleclass="FilteredContentVB"> <label class="LanguageFilter" for="VBCheckbox"> Visual Basic (Declaration) </label> <br><input data-languagename="CS" id="CSLanguageCheckbox" type="checkbox" class="ToggleLanguageCheckbox" checked="true" data-toggleclass="FilteredContentCS"> <label class="LanguageFilter" for="CSCheckbox"> C# </label> </div> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="C1.Data.2.html">C1.Data.2 Assembly</a> > <a href="C1.Data.2~C1.Data.SchemaObjects_namespace.html">C1.Data.SchemaObjects Namespace</a> > <a href="C1.Data.2~C1.Data.SchemaObjects.Field.html">Field Class</a> : AutoIncrement Property</td></tr></table></div> <div id="BodyContent"> <div class="DescriptionContent">Gets or sets a value indicating whether the field automatically receives an incremented value for a new row added to the table.</div> <div class="SectionHeading" id="syntaxSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Syntax</span></div><div id="syntaxSectionContent" class="SectionContent"> <div class="TabContainer" id="TabContainer"> <ul> <li class="FilteredContentVBAll"><a href="#Syntax-VBAll">Visual Basic</a></li> <li class="FilteredContentCS"><a href="#Syntax-CS">C#</a></li> </ul> <div id="Syntax-VB" class="FilteredContentVB"> <pre>'Declaration Public Overridable Property AutoIncrement As <a href="C1.Data.2~C1.Data.SchemaObjects.AutoIncrementEnum.html">AutoIncrementEnum</a></pre> </div> <div id="Syntax-CS" class="FilteredContentCS"> <pre>public virtual <a href="C1.Data.2~C1.Data.SchemaObjects.AutoIncrementEnum.html">AutoIncrementEnum</a> AutoIncrement {get; set;}</pre> </div> </div> </div> <div class="SectionHeading" id="remarksSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Remarks</span></div><div id="remarksSectionContent" class="SectionContent">The most common way of implementing the autoincrement functionality is using the ClientAndServer option. In this case, your database field must be an autoincrement field (an integer field having autoincrement functionality in the database), and C1DataObjects implements autoincrement functionality on the client. When a new row is added on the client, the field receives a negative autoincrement value (both <a href="C1.Data.2~C1.Data.SchemaObjects.Field~AutoIncrementSeed.html">AutoIncrementSeed</a> and <a href="C1.Data.2~C1.Data.SchemaObjects.Field~AutoIncrementStep.html">AutoIncrementStep</a> are equal to -1). C1DataObjects uses negative values on the client to ensure their uniqueness, to distinguish them from autoincremented values assigned by the database. When the new row is added to the database table on the server, C1DataObjects gets the autoincrement value assigned by the database and refreshes the field value on the client with this value. For this functionality to work with Oracle, Interbase and other databases that support sequence/generator objects, you must also set the <a href="C1.Data.2~C1.Data.SchemaObjects.Field~AutoIncrementSequenceName.html">AutoIncrementSequenceName</a> property.</div> <a name="exampleBookmark"></a> <a name="seealsobookmark"></a> <div class="SectionHeading" id="seealsoSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">See Also</span></div><div id="seealsoSectionContent" class="SectionContent"><h4 class="subHeading">Reference</h4><p><a href="C1.Data.2~C1.Data.SchemaObjects.Field.html">Field Class</a> <br><a href="C1.Data.2~C1.Data.SchemaObjects.Field_members.html">Field Members</a> <br><strong>Table Fields</strong> <br><strong>Keys Assigned by Server or Database</strong> </p> </div> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved.</p> </div> </body> </html>