How to form a correct MySQL connection string? [closed] How to form a correct MySQL connection string? [closed] mysql mysql

How to form a correct MySQL connection string? [closed]


try creating connection string this way:

MySqlConnectionStringBuilder conn_string = new MySqlConnectionStringBuilder();conn_string.Server = "mysql7.000webhost.com";conn_string.UserID = "a455555_test";conn_string.Password = "a455555_me";conn_string.Database = "xxxxxxxx";using (MySqlConnection conn = new MySqlConnection(conn_string.ToString()))using (MySqlCommand cmd = conn.CreateCommand()){    //watch out for this SQL injection vulnerability below     cmd.CommandText = string.Format("INSERT Test (lat, long) VALUES ({0},{1})",                                    OSGconv.deciLat, OSGconv.deciLon);     conn.Open();     cmd.ExecuteNonQuery();}


string MyConString = "Data Source='mysql7.000webhost.com';" +"Port=3306;" +"Database='a455555_test';" +"UID='a455555_me';" +"PWD='something';";


Here is an example:

MySqlConnection con = new MySqlConnection(    "Server=ServerName;Database=DataBaseName;UID=username;Password=password");MySqlCommand cmd = new MySqlCommand(    " INSERT Into Test (lat, long) VALUES ('"+OSGconv.deciLat+"','"+    OSGconv.deciLon+"')", con);con.Open();cmd.ExecuteNonQuery();con.Close();