C#MYSQL maxの値をクエリした結果

979 ワード

MySqlConnection conn = new MySqlConnection(connetStr);
            //       
            String data = DateTime.Now.ToString("yyyy-MM-dd");
            //    
            Double MaxNumber = 0.0;
            Double TotalNumber = 0.0;
            //           - DayMax
            conn.Open();
            //        
            String data_ym = DateTime.Now.ToString("yyyyMM");
            string tablename = data_ym+ "wzys";
            String sql_work = "SELECT max(wzEventEnergy) FROM " + tablename + " WHERE DATE_FORMAT(acquisitionTime,'%Y-%m-%d')='" + data + "'";
            cmd = new MySqlCommand(sql_work, conn);
            readers = cmd.ExecuteReader();
            while (readers.Read())
            {
                Double number= readers.GetDouble(0);
            }
            conn.Close();

組合せクエリーの結果に対するクエリー
Double number= readers.GetDouble(0);