How to bind ListBox to database list and show values ​​in text box?

Question

C++ / C#

On the form ListBox and TextBox.
When the form is launched, the ListBox is filled with data from the database.

MySqlConnection con = new MySqlConnection(AppSetting.ConnectonString());
            MySqlCommand cmd;
            cmd = con.CreateCommand();
            cmd.CommandText = "SELECT * FROM patients";
            try
            {
                con.Open();
                MySqlDataReader sdr = cmd.ExecuteReader();

                // Очищаем список

                MyListBox.Items.Clear();

                // Загружаем данные
                while (sdr.Read())
                {
                    string sLastName = sdr.GetString("LastName");
                    MyListBox.Items.Add(sLastName);
                }

                // Закрываем соединение
                con.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("Ошибка");
            }

What does it look like

When you select Surnames in the ListBox, they are filled with data from the TextBox database.

MySqlConnection con = new MySqlConnection(AppSetting.ConnectonString());
            MySqlCommand cmd;
            cmd = con.CreateCommand();
            cmd.CommandText = "SELECT * FROM patients WHERE LastName='"+ MyListBox.Text +"';";
            try
            {
                con.Open();
                MySqlDataReader sdr = cmd.ExecuteReader();

                // Загружаем данные
                while (sdr.Read())
                {
                    string sLastName = sdr.GetString("LastName");
                    txt_LastName.Text = sLastName;
                }

                // Закрываем соединение
                con.Close();
            }
            catch (Exception)
            {
                MessageBox.Show("Ошибка");
            }

After choosing a surname

How to bind by id?

cmd.CommandText = "SELECT * FROM patients WHERE LastName='"+ MyListBox.Text +"';";

Answer 1

try google:
- c# winforms binding
(and also)
- c# winforms binding ListBox - c# winforms
binding TextBox
- c# winforms binding samples
- c# binding MySql
- c# binding MySql samples
ps