How to replace part of Connection String?

Question

I'm using c# and I need to replace a string with other data. This is the string, the servername, user1 and 380kj data and length can change.

"Data Source=servername;User ID=user1;Password=380kj"

I want this result:

"Data Source=servername;User ID=XXXXX;Password=XXXXX"

I have done an IndexOf on User ID and Password but I don't know how to get the exact count to use the remove function so I can then insert the XXXXX into the string.

   int index = SaleDatabase.ConnectionString.IndexOf("User ID=");
   int index2 = SaleDatabase.ConnectionString.IndexOf(";Password");

What can I do?

thanks...

msdn.microsoft.com/en-us/library/ms228599.aspx msdn.microsoft.com/en-us/library/ms228362.aspx — Quintium
– Quintium, Commented Aug 12, 2014 at 20:51
What if the password has a semicolon in it, then it will be inside quotes! — ErikE
– ErikE, Commented Aug 12, 2014 at 20:52
Good chance this could be dealth with using ConnectionStringBuilders msdn.microsoft.com/en-us/library/ms254947(v=vs.110).aspx — MatthewMartin
– MatthewMartin, Commented Aug 12, 2014 at 20:53
For general strings, use string.Replace or Regex.Replace. Don't mess around with IndexOf nonsense as it makes code needlessly complicated. — user2864740
– user2864740, Commented Aug 12, 2014 at 20:57

M.A. Hanin · Accepted Answer · 2014-08-12 20:54:25Z

17

You can use the String.Replace method, but it seems that in your case you are editing a database connection string, in which case you should use the specific ConnectionStringBuilder for that connection string, such as:

string connStr = "Data Source=servername;User ID=user1;Password=380kj";
System.Data.SqlClient.SqlConnectionStringBuilder sb = new System.Data.SqlClient.SqlConnectionStringBuilder(connStr);
sb.UserID = "XXXXX";
sb.Password = "XXXXX";
connStr = sb.ToString();

answered Aug 12, 2014 at 20:54

M.A. Hanin

8,10435 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matt Burland · Accepted Answer · 2014-08-12 21:00:26Z

4

You should definitely use the ConnectionStringBuilder in this specific case as @M.A. Hamm suggested. But for completeness, you can also do something like this with a simple Regex.Replace. Something like:

    Regex r = new Regex(@"User ID=[^;]*");
    String newString = r.Replace(s,"User ID=XXXX");

Will look for text starting with User ID= and capture all characters up to the next ; (note: if user id contains a ; this would break - but it probably would have broken anyway and would need to have been escaped). Then we just replace the matched string with our new string.

Doing the same for Password= is left as an exercise for the reader.

answered Aug 12, 2014 at 21:00

Matt Burland

45.3k18 gold badges110 silver badges182 bronze badges

1 Comment

ErikE Over a year ago

If escaped it would have quotes around it.

Pavan Josyula · Accepted Answer · 2014-08-12 20:55:26Z

2

Why not split the string by using Split Method by character (";"). Result will be array. Then u can fetch value from result array using simple linq or foreach loop

answered Aug 12, 2014 at 20:55

Pavan Josyula

1,3753 gold badges13 silver badges25 bronze badges

1 Comment

Matt Burland Over a year ago

And reassemble with String.Join.

Felipe Oriani · Accepted Answer · 2014-08-12 21:03:40Z

2

Just use string.Format and generate a new string, for sample:

public static string GenerateConnectionString(string dataSource, string user, string password)
{
   return string.Format("Data Source={0};User ID={1};Password={2}", dataSource, user, password);
}

Some solutions can be very simple. Read more about KISS

answered Aug 12, 2014 at 21:03

Felipe Oriani

38.7k20 gold badges141 silver badges203 bronze badges

Collectives™ on Stack Overflow

How to replace part of Connection String?

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related