Windows Forms in C#

Question

Hey there! Help me pls with the code. I have a form for adding data and I need 1 data when adding to count as +1. Well, let's say I have 4 records. The user wants to add an entry without knowing what code to enter. I need it to automatically count it to 5. When adding another record, the code will already be 6. How can this be called?

Satya Karki · Answer

Hi, you can use Auto Increment in Database for Id column which automatically handles Id. If you need to do it logically then you can get Max Id and add 1 on it. What is your backend I don't have idea. you can take reference from below code. var maxId = select max (Id) from YourTableName var newId = maxId+1;

Sachin Singh · Answer

Just set the Id column's Autoincrement property to true. Or if you want to display the last column'c id+1 then retrieve the last column using the below command and add +1 to it. select top 1 Id from table order by Id desc; // ado.net nextID = (Int32)cmd.ExecuteScalar()+1;

Rajeev Kumar · Answer

You can use Identity in Column Field .Set Identity (ArticleId) and set value Seed and Increment is 1. var ArticleId1= select max(ArticleId) from Articlrmaster var newId = ArticleId1+1;

Salman Beg · Answer

You can use the auto-identity of sql server. See this link for example, https://www.aspsnippets.com/Articles/Return-Identity-Auto-Increment-Column-value-after-record-insert-in-SQL-Server-Database-using-ADONet-with-C-and-VBNet.aspx https://www.w3schools.com/sql/sql_autoincrement.asp

Windows Forms in C#

Answers (4)