Devart Forums

Code: Select all

                MySqlConnection Connection = new MySqlConnection();
                Connection.UserId = "test";
                Connection.Password = "test";
                Connection.Host = "test";
                Connection.Database = "testdb";
                Connection.Open();


                if (Connection.State == System.Data.ConnectionState.Open)
                {
                    string query = string.Format("select sessions_enddate from sessions where sessions.sessions_id = 48;");

                    MySqlCommand myCommand = new MySqlCommand(query, Connection);

                    MySqlDataReader myReader = myCommand.ExecuteReader();

                    // Always call Read before accessing data. 
                    while (myReader.Read())
                    {
                        // returns 01.01.0001 00:00:00
                        Console.WriteLine(myReader["sessions_enddate"].ToString());
                        
                        // returns 01.01.0001 00:00:00
                        DateTime EdnDate = myReader.GetDateTime(myReader.GetOrdinal("sessions_enddate"));
                    }

                    // always call Close when done reading. 
                    myReader.Close();

                    Console.ReadKey();
                }