Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Manage NuGet Pacages -> internet -> MySql.Data
- static void Main()
- {
- // some connection string
- string conStr = "Server=localhost;Database=world;Uid=root;Pwd=;Encrypt=true;";
- MySqlConnection con = new MySqlConnection(conStr);
- con.Open();
- using (con)
- {
- MySqlCommand cmd = new MySqlCommand("select name from country", con);
- MySqlDataReader reader = cmd.ExecuteReader();
- while (reader.Read())
- {
- Console.WriteLine(reader[0]); //first column
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment