코딩블로그

string connectionString =
	"Server=127.0.0.1;" +
	"Database=test;" +
	"User ID=root;" +
	"Password=password;" +
	"Pooling=false";
IDbConnection dbcon;

dbcon = new MySqlConnection(connectionString);
dbcon.Open();
IDbCommand dbcmd = dbcon.CreateCommand();

string sql ="SELECT * FROM mamber";
dbcmd.CommandText = sql;
IDataReader reader = dbcmd.ExecuteReader();
while(reader.Read()) {
	string FirstName = reader[name].ToString();
	Console.WriteLine("Name: " + FirstName);
}

reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
dbcon.Close();
dbcon = null;