how can filter database name from connection string using c#

Question

0.00/5 (No votes)

See more:

Dear All

i knew it it is stupid question but i don't know so ask you all expert need help

C#

try
            {
                using (MySqlConnection con = new MySqlConnection(txtOtherConStr.Text.Trim()))
                {
                    foreach()
                    {
                    
                    }
                    
                    }

          }

This is my code my connection string in the txtOtherConStr.Text(data source=localhost; uid=root; pwd=root; database=Hr;)

i want to database=Hrhow can i get pls help meeeeeee

Posted 3-Mar-14 20:07pm

Arjunwalmiki

Add a Solution

Comments

Kornfeld Eliyahu Peter 4-Mar-14 2:11am

Did you heard about regex?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

*dan!sh* · Answer 1 · 2014-03-03T20:18:00

Solution 1

I am not a Regex expert but this pattern would be a good start I guess: database=(.*?). You can then use Match.Groups property to get the database name.

Posted 3-Mar-14 20:18pm

dan!sh

Comments

Arjunwalmiki 4-Mar-14 2:26am

Sorry i don't know this

dan!sh 4-Mar-14 2:27am

Check out about Regex on MSDN

ErBhati · Answer 2 · 2014-03-03T20:18:00

Solution 2

C#

First Take txtOtherConStr.Text in a string like string st=txtOtherConStr.Text.Trim()
then split it by (;) like
string []st1=st.split(;) then You have st1[0],st1[1],t1[2],st1[3]..Now find string which have database .

i think itis st1[3] now spilt it again by (=).. then u have the databasename

Posted 3-Mar-14 20:18pm

ErBhati

v2

Comments

Arjunwalmiki 4-Mar-14 2:25am

ErBhati,

string st = txtOtherConStr.Text.Trim();
string []st1=st.Split(;);
st=st1[3];

is this right?

ErBhati 4-Mar-14 2:33am

Arjun
string st = txtOtherConStr.Text.Trim();
string []st1=st.Split(;);
after this
string [] ss=st1[3].spilt('=');
now u have ss[0] and ss[1].
I think this solve your problem

ErBhati 4-Mar-14 7:11am

plz select as answer for others if it helps you....