Create setup file include MySQL database inside it

Question

I developed application form using C# and connected this application with a MySQL database like this

string Coonstring = "datasource=localhost;port=3306;username=root;password=***;Charset=utf8";
string cmd = "select name from project.material ;";
MySqlConnection connectionDatabase = new MySqlConnection(Coonstring);
MySqlCommand cmddata = new MySqlCommand(cmd, connectionDatabase);
MySqlDataReader myreader;

When I try to build this app. and create setup file and get this setup file to another laptop error messagbox appear tell me missing MySQL host.

enter image description here

So what should I do ?

You are pointing to localhost for your MySQL server... is this installed on the target system? — user27414
– user27414, Commented May 7, 2014 at 18:24
@user3525082, but the target machine doesn't have an instance installed at all or one with that name. — Mike Perrenoud
– Mike Perrenoud, Commented May 7, 2014 at 18:27

Mike Perrenoud · Accepted Answer · 2014-05-07 18:25:52Z

2

Add an application configuration file. MSDN Link
Add an entry for a connection string - this can now be changed when deployed. MSDN Link
Change your code to use it (as shown below).
Set the connection string appropriately on the deployed system in the *.exe.config file.

string Coonstring = ConfigurationManager
    .ConnectionStrings["KeyValueYouSupplied"]
    .ConnectionString;

answered May 7, 2014 at 18:25

Mike Perrenoud

68.1k32 gold badges167 silver badges238 bronze badges

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

2 Comments

tariq Over a year ago

This is what i founded in App. config ( <?xml version="1.0" encoding="utf-8" ?> <configuration> <startup> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" /> </startup> </configuration> )

Mike Perrenoud Over a year ago

@user3525082, so add the sections that are appropriate based off of the MSDN article I linked to.

Collectives™ on Stack Overflow

Create setup file include MySQL database inside it

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related