Ubuntu-Forum & Kubuntu-Forum | www.Ubuntu-Forum.de

Quellcode

 /usr/lib/mono/2.0

Quellcode

 sudo gacutil -i mysql.data.dll 

Quellcode

 using System;
 using System.Data;
 using MySql.Data.MySqlClient;
 
 public class Test
 {
    public static void Main(string[] args)
    {
       string connectionString =
          "Server=localhost;" +
          "Database=test;" +
          "User ID=root;" +
          "Password=password;" +
          "Pooling=false";
       IDbConnection dbcon;
       dbcon = new MySqlConnection(connectionString);
       dbcon.Open();
       IDbCommand dbcmd = dbcon.CreateCommand();
       // requires a table to be created named employee
       // with columns firstname and lastname
       // such as,
       //        CREATE TABLE employee (
       //           firstname varchar(32),
       //           lastname varchar(32));
       string sql =
           "SELECT firstname, lastname " +
           "FROM employee";
       dbcmd.CommandText = sql;
       IDataReader reader = dbcmd.ExecuteReader();
       while(reader.Read()) {
            string FirstName = (string) reader["firstname"];
            string LastName = (string) reader["lastname"];
            Console.WriteLine("Name: " +
                  FirstName + " " + LastName);
       }
       // clean up
       reader.Close();
       reader = null;
       dbcmd.Dispose();
       dbcmd = null;
       dbcon.Close();
       dbcon = null;
    }
 }

Quellcode

[Task:File=/home/georg/Projects/test/test/Main.cs, Line=2, Column=15, Type=Error, Priority=Normal, Description=The type or namespace name `Data' does not exist in the namespace `System'. Are you missing an assembly reference?(CS0234)]
[Task:File=/home/georg/Projects/test/test/Main.cs, Line=3, Column=8, Type=Error, Priority=Normal, Description=The type or namespace name `MySql' could not be found. Are you missing a using directive or an assembly reference?(CS0246)]