public void attDataBase( string dataBaseName, string mainFileName, string logFileName) ... { SqlConnection connection = new SqlConnection(this.connStr); try ...{ try ...{ SqlCommand command = connection.CreateCommand(); command.CommandText = "dbo.sp_attach_db"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("dbname", SqlDbType.VarChar).Value = dataBaseName; SqlParameter parameter = new SqlParameter("filename1", mainFileName); SqlParameter parameter2 = new SqlParameter("filename2", SqlDbType.VarChar); parameter2.Value = logFileName; command.Parameters.AddRange(new SqlParameter[] ...{ parameter, parameter2 }); connection.Open(); command.ExecuteNonQuery(); } catch (SqlException exception) ...{ throw exception; } catch (Exception exception2) ...{ throw exception2; } } finally ...{ if ((connection != null) && (connection.State != ConnectionState.Closed)) ...{ connection.Close(); connection.Dispose(); } connection = null; GC.Collect(); }}