Select

var query = @"SELECT rodada FROM fut_jogos where id_jogo = @id_jogo";
 
               var cmd = new MySqlCommand();
               cmd.CommandText = query;
               cmd.CommandType = CommandType.Text;
               cmd.Parameters.AddWithValue("@id_jogo", idJogo);
 
 
               DataSet ds = _dal.Consultar(cmd);
 
               if ((ds.Tables.Count > 0) && (ds.Tables[0].Rows.Count > 0))
               {
                   DataRow dr = ds.Tables[0].Rows[0];
 
                   retorno = Convert.ToInt16(dr["rodada"].ToString());
                   
               }