Exception: There is already an open DataReader associated with this Connection which must be closed first

by

You are using the same connection for the DataReader and the ExecuteNonQuery. This is not supported, according to MSDN:

Note that while a DataReader is open, the Connection is in use
exclusively by that DataReader. You cannot execute any commands for
the Connection, including creating another DataReader, until the
original DataReader is closed.

Updated 2018: link to MSDN

More Related Contents:

  1. Error: You have an error in your SQL syntax – but SQL statement works
  2. is there a more efficient way to write this sql code?
  3. How do I send generated encrypted password from C# to MySQL
  4. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  5. How to connect to MySQL Database?
  6. Configuration System Failed to Initialize
  7. Is it possible to use a MySql User Defined Variable in a .NET MySqlCommand?
  8. How to form a correct MySQL connection string? [closed]
  9. ASP.NET use SqlConnection connect MySQL
  10. Most efficient way to insert Rows into MySQL Database
  11. Enable Entity Framework 6 for MySql (C#) in WinForms of Microsoft Visual Studio 2013
  12. Using Prepared Statement in C# with Mysql
  13. Dynamic MySQL database connection for Entity Framework 6
  14. C# with MySQL INSERT parameters
  15. Unable to connect to any of the specified mysql hosts. C# MySQL
  16. Error-Attempt by method ‘X.set_DbConnection(System.Data.Common.DbConnection)’ to access method ‘Y.get_Settings()’ failed
  17. MySQL Entity Framework Error – The specified store provider cannot be found in the configuration, or is not valid
  18. Bulk copy a DataTable into MySQL (similar to System.Data.SqlClient.SqlBulkCopy)
  19. MySql Last Insert ID, Connector .net
  20. MySQL C# Text Encoding Problems
  21. Asking for legitimate example of calling stored procedure C#: MYSQL
  22. Using SqlDataAdapter to insert a row
  23. Authentication with old password no longer supported, use 4.1 style passwords
  24. How to call Stored Procedures with EntityFramework?
  25. How to pass a table as parameter to MySqlCommand?
  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