代码之家  ›  专栏  ›  技术社区  ›  Learning-Overthinker-Confused

查找并删除字符串的一部分,然后再次使用新值添加该部分

  •  -3
  • Learning-Overthinker-Confused  · 技术社区  · 8 年前

    <add key="conString" value="Data Source=My-Pc;Initial Catalog=Db1;User ID=sdfsdf;Password=facebook"></add>
    

    现在,首先,我想删除 初始目录 初始目录 使用新数据库名称的零件。

    public void statistics()
    {
       String connString = System.Configuration.ConfigurationManager.AppSettings["conString"];
       //here i want to remove this part :  Initial Catalog=Db1;
       connString = "Data Source=My-Pc;User ID=sdfsdf;Password=facebook";
    
       //Here I have lots of operation and after that I would like to add this part with new database name
    
       string newDb= "db2";
       //again add that part with new db :  Initial Catalog=Db2;
       connString = "Data Source=My-Pc;Initial Catalog=Db2;User ID=sdfsdf;Password=facebook";
    }
    
    1 回复  |  直到 7 年前
        1
  •  1
  •   mortb    8 年前
    // initialize ConnectionStringBuilder like so:
    String connString = System.Configuration.ConfigurationManager.AppSettings["conString"];
    
    var builder = new ConnectionStringBuilder(connString);
    // set initial catalog to other database: 
    builder.InitialCatalog = "<otherDatabaseName>";
    // retrieve new connectionstring
    var newConnectionString = builder.ToString();