Windows Forms in C#

Mr. Thekotik

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?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajeev Kumar3y ago
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;
Satya Karki5y ago
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 Singh5y ago
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;
Salman Beg5y ago
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