Call the maximum from SQL table to textbox

by

You could design your database table using an IDENTITY column. The database will assign a next value for the inserted row. You can access the value using one of: SCOPE_IDENTITY, @@IDENTITY or IDENT_CURRENT. More can be found here: MSDN-Identity.

To know the difference between SCOPE_IDENTITY and @@IDENTITY see here.

More Related Contents:

  1. SQL connection string for microsoft access 2010 .accdb
  2. How can I get the WebBrowser control to show modern contents?
  3. How to write WinForms code that auto-scales to system font and dpi settings?
  4. How to update GUI with backgroundworker?
  5. SQL Express connection string: mdf file location relative to application location
  6. How can we show progress bar for upload with FtpWebRequest
  7. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine while data export to MS ACCESS
  8. Refresh DataGridView when updating data source
  9. convert hex code to color name
  10. Transparent Overlapping Circular Progress Bars (Custom Control)
  11. How to find overlapping controls that I added to form?
  12. InvalidOperationException – object is currently in use elsewhere
  13. Button inside a WinForms textbox
  14. Fill Panel with gradient in three colors
  15. ComboBox Dropdown Position
  16. C# Version Of SQL LIKE
  17. Using C# to search a CSV file and pull the value in the column next to it
  18. Restoring Window Size/Position With Multiple Monitors
  19. Save Settings in VB.Net or C#
  20. Oracle Parameters with IN statement?
  21. How to add event handler for dynamically created controls at runtime?
  22. Control.AddRange(…) is slow
  23. TLS 1.2 not negotiated in .NET 4.7 without explicit ServicePointManager.SecurityProtocol call
  24. Order of events ‘Form.Load’, ‘Form.Shown’ and ‘Form.Activated’ in Windows Forms
  25. Close button in tabControl
  26. Popup window in winform c#
  27. big issue in converting string to datetime using linq-to-entities
  28. Read nodes of a xml file in C#
  29. Saving content of a treeview to a file and load it later
  30. How to create a Button that can send keys to a control without stealing the focus – Virtual Keyboard

Leave a Comment