1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using MySql.Data;
using MySql.Data.MySqlClient;  

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            String connectionstring = "SERVER=xx.xx.xxx.xxx ;DATABASE=db;UID=username;PASSWORD=passwort;";
            MySqlConnection connection = new MySqlConnection(connectionstring);
            MySqlCommand command = connection.CreateCommand();
            MySqlDataReader reader;
            try {
                connection.Open();
                command.CommandText = "SELECT * FROM kd;";
                reader = command.ExecuteReader();
                
                while (reader.Read()) {
                    for (int i = 0; i < reader.FieldCount; i++)
                        Console.WriteLine(reader.GetValue(i).ToString());
                    
            }
            connection.Close();

            } catch (MySqlException mysqle) {
               Console.WriteLine(mysqle);
            } catch (Exception ex) {
                Console.WriteLine(ex);
            }

        }
    }
}					

1:

MySqlCommand command = connection.CreateCommand();					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:

              
 MySql.Data.MySqlClient.MySqlConnection connection;
 MySql.Data.MySqlClient.MySqlCommand command;

 connection = new MySql.Data.MySqlClient.MySqlConnection(ConfigurationManager.ConnectionStrings["MySqlConnectionString"].ConnectionString);
 connection.Open();

 command = new MySql.Data.MySqlClient.MySqlCommand("update kunden set active=1", connection);
 command.ExecuteNonQuery();
 command.Dispose();
 connection.Close();
 connection.Dispose();					

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:

 MySql.Data.MySqlClient.MySqlConnection connection;
 MySql.Data.MySqlClient.MySqlCommand command;
 MySql.Data.MySqlClient.MySqlDataReader reader;

 connection = new MySql.Data.MySqlClient.MySqlConnection(ConfigurationManager.ConnectionStrings["MySqlConnectionString"].ConnectionString);
 connection.Open();

 command = new MySql.Data.MySqlClient.MySqlCommand("select id from kunden", connection);
 reader = command.ExecuteReader();
 if (reader.Read())
  {
   id = Convert.ToInt32(reader["id"]);
  }
 reader.Close();
 reader.Dispose();
 command.Dispose();
 connection.Close();
 connection.Dispose();