public static void kDemoRun(string server = cServer, string userName = cUserName, string passWord = cPassword, string dbName = cDatabase, string port = cPort) { try { string connStr = string.Format(cConnectionStringFormat, server, userName, passWord, dbName, port); IList <AkmTest> list = new List <AkmTest>(); using (var connec = new MySqlConnection(connStr)) { using (var comman = new MySqlCommand()) { connec.Open(); comman.Connection = connec; comman.CommandText = "select timestamp, msg from axts_test"; comman.CommandTimeout = 0; MySqlDataReader reader = comman.ExecuteReader(); while ((reader.Read())) { AkmTest ob = new AkmTest(); ob.Timestamp = Convert.ToDateTime(reader["timestamp"]); ob.Msg = Convert.ToString(reader["msg"]); list.Add(ob); } connec.Close(); } } foreach (var c in list) { Console.WriteLine(c.Timestamp + " - " + c.Msg); } Console.WriteLine("Success"); } catch (Exception e) { Console.WriteLine("{0} Exception caught.", e); } }
public static void kDemoRun(string server = cServer, string userName = cUserName, string passWord = cPassword, string dbName = cDatabase, string port = cPort) { try { string connStr = string.Format(cConnectionStringFormat, server, userName, passWord, dbName, port); IList<AkmTest> list = new List<AkmTest>(); using (var connec = new MySqlConnection(connStr)) { using (var comman = new MySqlCommand()) { connec.Open(); comman.Connection = connec; comman.CommandText = "select timestamp, msg from axts_test"; comman.CommandTimeout = 0; MySqlDataReader reader = comman.ExecuteReader(); while ((reader.Read())) { AkmTest ob = new AkmTest(); ob.Timestamp = Convert.ToDateTime(reader["timestamp"]); ob.Msg = Convert.ToString(reader["msg"]); list.Add(ob); } connec.Close(); } } foreach (var c in list) { Console.WriteLine(c.Timestamp + " - " + c.Msg); } Console.WriteLine("Success"); } catch (Exception e) { Console.WriteLine("{0} Exception caught.", e); } }