How to get data from Mysql Database?

Question

I have this code snippet where it takes the information from a database field and goes to textBlock, but now I need to fill in some textblock.

EX: In the database has name=maria Rg=123 Cpf=456 ai in the program goes have the textblock that will take name, Rg, Cpf.

Code:

 using (_connection = new MySqlConnection("Database=test;Data Source=localhost;User Id=root;Password=teste;SslMode=None;"))
        {
            System.Text.EncodingProvider ppp;
            ppp = System.Text.CodePagesEncodingProvider.Instance;
            Encoding.RegisterProvider(ppp);

            _connection.Open();
            var cmd = new MySqlCommand("select name from user where id=1", _connection);
            using (var reader = cmd.ExecuteReader())
            {
                if (reader.Read())
                {
                    textBlock.Text = (reader.GetString("name"));
                }

            }

        }

Answer 1

If that’s what I understand, just increment the fields in the query and text.

using (_connection = new MySqlConnection("Database=test;Data Source=localhost;User Id=root;Password=teste;SslMode=None;"))
{
    System.Text.EncodingProvider ppp;
    ppp = System.Text.CodePagesEncodingProvider.Instance;
    Encoding.RegisterProvider(ppp);

    _connection.Open();
    var cmd = new MySqlCommand("select nome, Rg, Cpf from user where id=1", _connection);
    using (var reader = cmd.ExecuteReader())
    {
        if (reader.Read())
        {
            textBlocknome.Text = (reader.GetString("name"));
            textBlockRg.Text = (reader.GetString("Rg"));
            textBlockCpf .Text = (reader.GetString("Cpf "));
        }
    }
}