SqlTransaction and error ExecuteNonQuery

Question

hello guys I make script with select insert and update and I used sqltransaction but when thescript after running select and start to run i = this.cmdInsert.ExecuteNonQuery it's error with a word ExecuteNonQuery requires an open and available Connection. The connection's current state is closed. can you help me? thanks.

ali tuncer · Answer

check this link: https://blogs.msdn.microsoft.com/spike/2009/08/20/there-is-already-an-open-datareader-associated-with-this-command-which-must-be-closed-first-explained/

Sanjay Kumar · Answer

try this http://www.c-sharpcorner.com/UploadFile/47548d/simple-mysql-transaction-in-Asp-Net/

Ashish Srivastava · Answer

SqlConnection con = new SqlConnection(constr); SqlCommand objcommand = new SqlCommand(query con); if (con.State == ConnectionState.Closed) { con.Open(); } objcommand.ExecuteNonQuery(); con.Close();

Ashish Srivastava · Answer

SqlConnection con = new SqlConnection(constr); SqlCommand objcommand = new SqlCommand(query con); if (con.State == ConnectionState.Closed) { con.Open(); } objcommand.ExecuteNonQuery(); con.Close();

Chandu Kumawat · Answer

simply Use SqlDataAdapter which is not require any open connection it manage connection internally

Mega Anaska · Answer

when I added con.open still error with There is already an open DataReader associated with this Command which must be closed first.

Saillesh Pawar · Answer

The error is itself specifying the problem you need to open the sqlconnection eg con.open();