using System;
 using System.Data;
 
 using ByteFX.Data.MySqlClient;
 
 public class ConnectToDatabase {
 
 		public static void Main(string [] args) {
 
 				string username = args[0];
 				string password = args[1];
 
 			    string connectionString = string.Format("Server=localhost;" +
 		  "Database=monodn;User ID={0};Password={1};", username, password);
 
 				MySqlConnection conn = null;
 			    DataSet monodn = new DataSet("monodn");
 
 				try {
 					    conn = new MySqlConnection(connectionString);
 					    conn.Open();
 
 					    MySqlDataAdapter adapter = new MySqlDataAdapter(
 							    "select * from book", conn);
 					    MySqlCommandBuilder cmdBuilder =
 							    new MySqlCommandBuilder(adapter);
 
 					    adapter.Fill(monodn);
 					    conn.Close();
 
 					    DataRow [] rows = monodn.Tables[0].Select("id = 1");
 					    DataRow row = rows[0];
 
 					    DateTime pubDate = (DateTime)row["pubdate"];
 					    Console.WriteLine("original pubdate: {0}", pubDate);
 					    row["pubdate"] = pubDate.AddDays(15);
 					    Console.WriteLine("new pubdate:	  {0}",
 							    monodn.Tables[0].Rows[0]["pubdate"]);
 
 					    conn.Open();
 					    adapter.Update(monodn);
 					    conn.Close();
 
 				} catch (Exception e) {
 					    Console.Error.WriteLine(e);
 				} finally {
 					    if (conn != null && conn.State == ConnectionState.Open) {
 							    conn.Close();
 					    }
 				}
 		}
 }