Connection string read from textbox

Question

I'm trying to make my mysql connection string read from textbox instaid of direct string what i was trying to do is this

string myConnection = "datasource='" + this.label12 + "';username='" + this.textBox3 + "';password='" + this.textBox4 + "';SSL Mode=Required;Certificate Store Location=CurrentUser;";

And i get the error cannot connect to any mysql server

Coded in c#

Grant Winney · Accepted Answer · 2014-06-13 00:55:20Z

1

You're trying to use label12 and textBox3 directly, which implicitly calls ToString() on the object, and usually just returns the type of object (like "System.Windows.Controls.Label").

Use the Text property of your labels and text boxes. (I also used String.Format for readability.)

var myConnection
    = string.Format("datasource='{0}';username='{1}';password='{2}';SSL Mode=Required;Certificate Store Location=CurrentUser;",
                    label12.Text, textBox3.Text, textBox4.Text);

I don't know if the connection string you're building will work. You may want to check out connectionstrings.com for samples.

edited Jun 13, 2014 at 0:55

answered Jun 13, 2014 at 0:49

Grant Winney

66.6k13 gold badges120 silver badges167 bronze badges

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

Comments

PeaceInMind · Accepted Answer · 2014-06-13 02:22:43Z

1

Please point out servername in connection string as pattern:

string myConnection
    = "Server="+myServerAddress+";Database="+myDataBase+";Uid="+myUsername+";Pwd="+myPassword;

answered Jun 13, 2014 at 2:22

PeaceInMind

1,2173 gold badges12 silver badges33 bronze badges

Collectives™ on Stack Overflow

Connection string read from textbox

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related