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

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

linq .net c#

-3

Learning-Overthinker-Confused · 技术社区 · 9 年前

<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 回复 | 直到 8 年前

1

mortb 9 年前

// 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();