Given a connection string, find the username and password in the connection string?

wowclaw

Do you have to decompose the string? The details are as follows:
public static string sqlConnectionString = "packet size=4096;user id=sa;data source=" + "." + ";persist security info=True;initial catalog=plan;password=aaa";

Now I want to find the username and password in sqlConnectionString and assign them to the variables username and pwd

How to achieve it?

pronice

string str = "packet size=4096;user id=sa;data source=ddd;persist security info=True;initial catalog=plan;password=aaa";
Match m = Regex.Match(str,@"user id=(\w+);.*password=(.*)[;]?");
string username = m.Groups[1].Value;
string pwd = m.Groups[2].Value;

kalian2000

Regular expression:

panicpeer

With ";", then with "="

goddxa

public static string sqlConnectionString = "packet size=4096;user id=sa;data source=" + "." + ";persist security info=True;initial catalog=plan;password=aaa";

plan 1.
string[] str = sqlConnectionString.Split( new char[]{'=',':'});
for(int i = 0;i<str.Lenght;i++
{
  switch(str[i])
  {
    case "user id":
        username=str[i+1];i++;break;
    case"password":
        pwd=str[i+1];i++;break;
    default:
    break;
  }
}

Scenario 2.
    username = "user id=";
    pwd="password=";
    int pos1 = sqlCOnnectionString.Find(username);
    int pos2 = sqlCOnnectionString.Find(";",pos1);
     username = sqlCOnnectionString.SubString(pos1+username.Length,pos2);
   pwd....
Option 3.
Regular // MSDN is not there, I can't write it out

coldfall

DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
builder.ConnectionString = sqlConnectionString;
string username = builder["User ID"];

starsport

coldfall() Reputation: 93
DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
builder.ConnectionString = sqlConnectionString;
string username = builder["User ID"];

This is the easy way

animuth

coldfallis the correct solution.