Mono Weekly News - January 10, 2003

**Commits**

     Gtk.Window main_window = (Gtk.Window) gxml["main_window"];

     [GladeWidget("main_window")]
        Gtk.Window main_window;

Log on to the MySQL client tool mysql:

DanielMorgan@DANPC ~
$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 3.23.51-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

Change to a database:

mysql> use test
Database changed

Create a database table named hello_world_test with the columns hello_id and
hello_desc.
hello_id is the id to this table and hello_desc is an attribute that is a
description.

mysql> create table hello_world_test (
    -> hello_id varchar(2),
    -> hello_desc text);
Query OK, 0 rows affected (0.01 sec)

Insert a row into the new table named hello_world_test
with hello_id set to 'HW'
and hello_desc set to 'Hello World'.

mysql> insert into hello_world_test (hello_id, hello_desc) values
('HW','Hello W
orld');
Query OK, 1 row affected (0.00 sec)

Verify the data in the table.

mysql> select * from hello_world_test;
+----------+-------------+
| hello_id | hello_desc  |
+----------+-------------+
| HW       | Hello World |
+----------+-------------+
1 row in set (0.02 sec)

Now, create the SQL statement you will use in your C# program.

mysql> select hello_desc from hello_world_test where hello_id = 'HW';
+-------------+
| hello_desc  |
+-------------+
| Hello World |
+-------------+
1 row in set (0.02 sec)

// MySqlHelloWorld.cs
//
// On Windows, compile like:
//     mono C:/cygwin/home/MyHome/mono/install/bin/mcs.exe
MySqlHelloWorld.cs \
//          -lib:C:/cygwin/home/MyHome/mono/install/lib \
//          -r System.Data.dll -r Mono.Data.MySql.dll
// On Linux, compile like:
//    mcs MySqlHelloWorld.cs -r System.Data -r Mono.Data.MySql
//
//DanielMorgan@DANPC ~/mono/20021223/mcs/class/Mono.Data.MySql/Test
//$ mono f:/cygwin/home/DanielMorgan/mono/install/bin/mcs.exe
MySqlHelloWorld.cs
//    -r System.Data.dll -r Mono.Data.MySql.dll
// Compilation succeeded
//
//DanielMorgan@DANPC ~/mono/20021223/mcs/class/Mono.Data.MySql/Test
//$ mono MySqlHelloWorld.exe
//Result: Hello World
//
using System;
using System.Data;
using Mono.Data.MySql;

class MySqlHelloWorld {
        static void Main(string[] args) {
                string connectionString = "Database=test";
                string sql =
                        "SELECT hello_desc " +
                        "FROM hello_world_test " +
                        "WHERE hello_id = 'HW'";

                // connect
                IDbConnection dbcon = new MySqlConnection();
                // set the connection string
                dbcon.ConnectionString = connectionString;
                // open a connection to the database
                dbcon.Open();
                // create command
                IDbCommand dbcmd = dbcon.CreateCommand();
                // set the command's SQL
                dbcmd.CommandText = sql;
                // execute the SQL
                IDataReader reader = dbcmd.ExecuteReader();
                // read the first row in the result
                if(reader.Read()) {
                        // display the result
                        Console.WriteLine("Result: " + reader["hello_desc"]);
                }
                else {
                        // display message row not found
                        Console.WriteLine("Row not found.");
                }

                // clean up
                reader.Close();
                reader = null;
                dbcmd.Dispose();
                dbcmd = null;
                dbcon.Close();
                dbcon = null;
        }
}

Top White Papers

Subscribe to Our Daily Newsletter

Current Newswire:

More on LinuxToday

Mono Weekly News - January 10, 2003

1.1 Switch support has landed in Mono CVS.

1.2 Glade# use attributes and implicit names.

1.3 Mono debugger now has support for multi-thread debugging.

1.4 Mono and Mono ASP.NET as an Apache module.

1.5 Zoltan has published his Code Coverage analysis tool for Mono.

1.6 Paolo added a memory profiler to Mono.

1.7 Steve Newman contributed his Javascript interpreter to Mono.

1.8 Jonathan Pryor has published his type-reflector.

2. Meet the team. This week Daniel Morgan.

Interview with Daniel Morgan

3. The Mono Spell.

4. Mono Socials: Duncan does Tokyo.

5. CVS Activity.

6. Mailing List Activity.