説明のないとってもシンプルなサンプルプログラム集

COBOL	awk	C言語	D言語	GO言語	Lua	Vim
bash	Perl	Gauche	Clojure	CLISP	EmacsLisp	VimScript
tcsh	Ruby	Groovy	Java	C#	VBScript	JavaScript
Io言語	Python	Erlang	Scala	VB.NET	Excel/VBA	PHP
Tcl	Haskell		OCaml	PowerShell	Windows	Unix/Linux

C#(mono) > MySQLへ接続する

mysql.cs

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 
40 
41 
42 
43 
44 
45 
46 using System;
using System.Data;
using MySql.Data.MySqlClient;

class Test
{
	static void Main()
	{
		MySqlConnection conn = new MySqlConnection(
		"userid=root;password=12345678;database=sample;host=localhost");
		conn.Open();

		MySqlCommand cmd = new MySqlCommand();
		cmd.Connection = conn;
		cmd.CommandText =
			"CREATE TABLE mytbl (id INT,name VARCHAR(10));"
			+ "INSERT INTO mytbl (id,name) VALUES (1,'apple');"
			+ "INSERT INTO mytbl (id,name) VALUES (2,'banana');"
			+ "INSERT INTO mytbl (id,name) VALUES (3,'candy');";
		cmd.Prepare();
		cmd.ExecuteNonQuery();

		MySqlCommand cmd2 = new MySqlCommand("SELECT * FROM mytbl", conn);
		cmd2.CommandText = "SELECT * FROM mytbl";
		MySqlDataReader reader = cmd2.ExecuteReader();

		while (reader.Read()) 
		{
			Console.WriteLine((string)reader["name"]);
		}

		reader.Close();
		reader = null;

		cmd.CommandText = "DROP TABLE mytbl";
		cmd.Prepare();
		cmd.ExecuteNonQuery();

		cmd2.Dispose();
		cmd2 = null;
		cmd = null;
		conn.Close();
	}
}

# unzip -d hoge mysql-connector-net-6.9.4-noinstall.zip
# cd hoge/v2.0
# cp *.dll /usr/lib/mono/2.0/
# cd /usr/lib/mono/2.0
# gacutil -i MySql.Data.CF.dll
# gacutil -i MySql.Data.dll
# gacutil -i MySql.Data.Entity.dll
# gacutil -i MySql.Web.dll

$ mcs mysql.cs -r:System.Data -r:MySql.Data
$ mono mysql.exe
apple
banana
candy
$

* 確認環境 Debian Linux(Wheezy)