C#

Vipin.d wrote:

// i need to perform this in con1
command.CommandText = "Insert ...";
command.ExecuteNonQuery();

// Execute i need to perform this in con2
command.CommandText = "Update...";
command.ExecuteNonQuery();

using (SqlConnection conn = new SqlConnection())
{
 //set the first cs
 string cs1 = "connection string 1";
 conn.ConnectionString = cs1;

 conn.Open();

 SqlTransaction trans = conn.BeginTransaction();

 //do the the select query

 if (InsertSecondDB())
 {
  //update first DB
  trans.Commit();
 }
 else
 {
  trans.Rollback();
 }

 conn.Close();
}

clife537 wrote:

server application path