Why Does My ExecuteNonQuery Throw 'Connection Property Has Not Been Initialized'?

ExecuteNonQuery: Connection Property Has Not Been Initialized

The error "ExecuteNonQuery: Connection property has not been initialized" indicates a missing connection between the SqlCommand and the database. To resolve this issue, follow these steps:

1. Assign Connection to SqlCommand

In the provided code, the connection established in the line connection1.Open(); is not assigned to the InsertCommand used in the ExecuteNonQuery method. To fix this, use either the constructor or the property to assign the connection to the InsertCommand:

cmd.InsertCommand = new SqlCommand("...");
cmd.InsertCommand.Connection = connection1;

2. Use Using Statement for Resource Disposal

It's recommended to use the using statement to automatically dispose of IDisposable objects like SqlConnection, which also closes the connection when the statement block exits:

using (var connection1 = new SqlConnection(...))
{
    using (var cmd = new SqlDataAdapter())
    {
        using (var insertCommand = new SqlCommand(...))
        {
            // ...
            connection1.Open();
        }
    }
}

3. Optimize Connection Handling

Creating a new connection for every entry in the foreach loop is unnecessary. You can optimize this by creating the connection and adapters outside the loop and reusing them:

var connection1 = new SqlConnection(...);
var cmd = new SqlDataAdapter();
var insertCommand = new SqlCommand(...);
insertCommand.Connection = connection1;

...

connection1.Open();
// ...

// No need to close the connection explicitly

The above is the detailed content of Why Does My ExecuteNonQuery Throw 'Connection Property Has Not Been Initialized'?. For more information, please follow other related articles on the PHP Chinese website!