I am using a SQL data adapter in a C# windows form and I am trying to run two update statements on two separate databases with one button click using the same string. I keep getting an exception error and I think that the second update statement is trying to use the connection for the first update statement but I can't figure it out. Anybody have any ideas?

```
                string resendacct = textBox_resendVisit.Text.Trim();

                SqlConnection CONN1 = new SqlConnection("Data Source=DBSERVER1.domain.company.org; Initial Catalog=db1; User ID=username; Password=password    ;Trusted_Connection=False");

                //OPEN SQL CONNECTION
                CONN1.Open();

                //CREATE NEW SQLCOMMAND
                SqlCommand cmd = CONN1.CreateCommand();
                cmd.CommandText =
                 "UPDATE PRODUCTIONDB1.dbo.date_time  " +
                     "SET PRODUCTIONDB1.dbo.date_time.sent_datetime = null  " +
                 "FROM PRODUCTIONDB1.dbo.date_time  " +
                 "INNER JOIN PRODUCTIONDB1.dbo.useridentity  " +
                 "ON PRODUCTIONDB1.dbo.useridentity.custidentity = PRODUCTIONDB1.dbo.date_time.custidentity  " +
                 "WHERE PRODUCTIONDB1.dbo.useridentity.account = @resendtimes";
                cmd.Parameters.AddWithValue("@resendtimes", resendacct);
                cmd.ExecuteNonQuery();

                int noRows;

                noRows = cmd.ExecuteNonQuery();

                //THIS COMMAND RESENDS THE DATABASE2 REPORTS!//

                SqlConnection CONN2 = new SqlConnection("Data Source=DBSERV2.domain.company.org; Initial Catalog=db2; Integrated Security=TRUE");

                //OPEN SQL CONNECTION
                CONN2.Open();

                //CREATE NEW SQL COMMAND
                SqlCommand cmd1 = CONN2.CreateCommand();
                cmd.CommandText =
                    "UPDATE PRODUCTIONDB2.dbo.date_time  " +
                        "SET PRODUCTIONDB2.dbo.date_time.timedone = null  " +
                    "FROM PRODUCTIONDB2.dbo.date_time  " +
                    "INNER JOIN PRODUCTIONDB2.dbo.custidentity  " +
                    "ON PRODUCTIONDB2.dbo.custidentity.id = PRODUCTIONDB2.dbo.date_time.custencounter_id  " +
                    "INNER JOIN PRODUCTIONDB2.dbo.custencounter  " +
                    "ON PRODUCTIONDB2.dbo.custencounter.id = PRODUCTIONDB2.dbo.custidentity.custencounter_id  " +
                    "WHERE PRODUCTIONDB2.dbo.custencounter.accountnumber = @resendtimes";
                cmd.Parameters.AddWithValue("@resendtimes", resendacct);
                cmd.ExecuteNonQuery();

                int noRows1;

                noRows1 = cmd1.ExecuteNonQuery();
                //CLOSE SQLCONNECTIONS
                CONN1.Close();
                CONN2.Close();

```