Advertisement
Guest User

Untitled

a guest
Jan 6th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.53 KB | None | 0 0
  1.         public void readSQL()
  2.         {
  3.             string sql = " SELECT * FROM teacher  ";
  4.             MySqlConnection con = new MySqlConnection("host=localhost;user=root;password=859694;database=projekt;");
  5.             MySqlCommand cmd = new MySqlCommand(sql, con);
  6.  
  7.             con.Open();
  8.  
  9.            MySqlDataReader  reader = cmd.ExecuteReader();
  10.  
  11.            while (reader.Read()) {
  12.                data2txt.Text = reader.GetString("id");
  13.               datatxt.Text = reader.GetString("userId");
  14.            }
  15.  
  16.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement