How to specify password for DataSet C#?

Question

C++ / C#

Good afternoon!
There is such a line

this.cardsTableAdapter.Fill(this.print2DataSet.cards, id_card_for_print);

In it, the DataSet uses a string connector to the MySQL database in which the password is not specified. How to specify the connection password in the code?

Answer 1

When you create MySqlConnection - the connection string is passed there as an argument - the password is passed in it.
If the connection string is taken from some source and it crumples the password - glue it before connecting!
If there are examples here zetcode.com/db/mysqlcsharptutorial (including with a password)