Get the id of inserted row using C#

by 
MySqlCommand comm = connect.CreateCommand();
comm.CommandText = insertStatement;  // Set the insert statement
comm.ExecuteNonQuery();              // Execute the command
long id = comm.LastInsertedId;       // Get the ID of the inserted item

More Related Contents:

  1. Error: You have an error in your SQL syntax – but SQL statement works
  2. Quotes in string [closed]
  3. is there a more efficient way to write this sql code?
  4. Parameterized Query for MySQL with C#
  5. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  6. How to connect to MySQL Database?
  7. Configuration System Failed to Initialize
  8. .NET Core 2.1 Identity get all users with their associated roles
  9. ASP.NET use SqlConnection connect MySQL
  10. Most efficient way to insert Rows into MySQL Database
  11. MySqlCommand Command.Parameters.Add is obsolete
  12. LINQ to SQL multiple tables left outer join
  13. Enable Entity Framework 6 for MySql (C#) in WinForms of Microsoft Visual Studio 2013
  14. Dynamic MySQL database connection for Entity Framework 6
  15. C# with MySQL INSERT parameters
  16. Unable to connect to any of the specified mysql hosts. C# MySQL
  17. Why do I get “System.Data.DataRowView” instead of real values in my WinForms Listbox?
  18. Entity Framework creates a plural table name, but the view expects a singular table name?
  19. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  20. Asking for legitimate example of calling stored procedure C#: MYSQL
  21. Using SqlDataAdapter to insert a row
  22. Get affected rows on ExecuteNonQuery
  23. Index (zero based) must be greater than or equal to zero
  24. How to pass a table as parameter to MySqlCommand?
  25. Connection to MySQL from .NET using SSH.NET Library
  26. Testing an Entity Framework database connection
  27. How can I force a log out of all users for a website?
  28. How do I remove emoji characters from a string?
  29. Incorrect string value: ‘\xEF\xBF\xBD’ for column
  30. Could not load file or assembly ‘MySql.Data, Version=6.2.2.0

Leave a Comment