sashomaga

ADO.NET connect to mysql server

Jul 31st, 2013
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.60 KB | None | 0 0
  1. // Manage NuGet Pacages -> internet -> MySql.Data
  2.     static void Main()
  3.     {
  4.         // some connection string
  5.         string conStr = "Server=localhost;Database=world;Uid=root;Pwd=;Encrypt=true;";
  6.         MySqlConnection con = new MySqlConnection(conStr);
  7.  
  8.         con.Open();
  9.  
  10.         using (con)
  11.         {
  12.             MySqlCommand cmd = new MySqlCommand("select name from country", con);
  13.             MySqlDataReader reader = cmd.ExecuteReader();
  14.             while (reader.Read())
  15.             {
  16.                 Console.WriteLine(reader[0]); //first column
  17.             }
  18.         }
  19.  
  20.     }
Advertisement
Add Comment
Please, Sign In to add comment