title: How to read and print out data from mysql in c#
body: <p>My problem is that I can't print  out all the data from the table in my mysql database, I got out just last row in the given table "teacher". is there anyone who can help me find the error?</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.ComponentModel;
  using System.Data;
  using System.Drawing;
  using System.Linq;
  using System.Text;
  using System.Windows.Forms;
  using MySql.Data.MySqlClient;
  
  namespace ReadDataFromMysql
  {
      public partial class Form1 : Form
      {
          public Form1()
          {
              InitializeComponent();
          }
  
          private void button1_Click(object sender, EventArgs e)
          {
              string sql = " SELECT * FROM teacher  ";
              MySqlConnection con = new MySqlConnection("host=localhost;user=root;password=859694;database=projekt;");
              MySqlCommand cmd = new MySqlCommand(sql, con);
  
              con.Open();
  
             MySqlDataReader  reader = cmd.ExecuteReader();
  
             while (reader.Read()) {
                 data2txt.Text = reader.GetString("id");
                datatxt.Text = reader.GetString("userId");
             }
  
          }
  
          private void btnclose_Click(object sender, EventArgs e)
          {
              Close();
          }
      }
  }
  </code></pre>