/// <summary>       ///   事务处理        /// </summary>       /// <param name="strSql"></param>       /// <returns></returns>       public bool InportData(string strSql)       {                      SqlConnection sqlConnection = new SqlConnection(DbHelperSQL.connectionString);           sqlConnection.Open();           SqlTransaction myTrans = sqlConnection.BeginTransaction();           SqlCommand sqlInsertCommand = new SqlCommand();           sqlInsertCommand.Connection = sqlConnection;           sqlInsertCommand.Transaction = myTrans;           try           {               sqlInsertCommand.CommandText = strSql.ToString();               sqlInsertCommand.ExecuteNonQuery();               myTrans.Commit();               return true;           }           catch (Exception ex)           {               myTrans.Rollback();               return false;           }           finally           {               sqlConnection.Close();           }       }